Category Archives: datamodeling

datamodeling

Bitmetric Friday Qlik Test Prep – Week 18 – Subset ratio

May 20, 2022 – 09:49

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »
Tags , | Comments Off on Bitmetric Friday Qlik Test Prep – Week 18 – Subset ratio
datamodeling

Bitmetric Friday Qlik Test Prep – Week 8 – Sales & Budget model – Solution

March 1, 2022 – 10:02

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »
Tags , , | Comments Off on Bitmetric Friday Qlik Test Prep – Week 8 – Sales & Budget model – Solution
datamodeling

Friday Qlik Test Prep – Week 3 – Circular references and Synthetic Keys

January 25, 2022 – 10:00
Qlik certification test question 3 - circular references and synthetic keys

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »
Tags , | Comments Off on Friday Qlik Test Prep – Week 3 – Circular references and Synthetic Keys
datamodeling Script Utilities

Auto AutoNumber your key fields

September 27, 2019 – 16:31

A quick note on a cool feature that I recently learned from Oleg Troyansky: AutoNumber.

I hear you thinking: “What? You didn’t know about AutoNumber? It’s been around for years. Hand over your Luminary badge!“. Admittedly, this is also what I thought when I hear Oleg mention it but it turned out that I misunderstood. Oleg wasn’t talking about the AutoNumber() script function, but the AutoNumber script statement. This statement was added in the June 2018 release of Qlik Sense (as well as QlikView 12.20) and lets you AutoNumber multiple fields, across multiple tables in a single line of script. And no, despite it being available for over a year, I hadn’t heard about it before. I’ll certainly be using it going forward though!

read more »
Tags , , , | Comments (16)
datamodeling Script

A very elegant link table script

September 8, 2016 – 17:00

Some nice out of the box thinkingToday was the last day of the Masters Summit for Qlik in Johannesburg and we all had a great time. One of the things I very much enjoy about these events is the chance to speak with so many experienced people who are enthusiastic about Qlik and keen to share their knowledge. I always go home with some cool new tricks and insights.

What I want to share with you today is an alternative script for building a link table. This was shared with me by Rene McGregor and the nice folks over at QlikView South Africa (who have also been very supportive in bringing the Masters Summit to South Africa, much appreciated).

read more »

Tags , , | Comments (11)