Tag Archives : data-modeling

60 – Subset Ratio Tip

One quick tip about data modeling. If you find things in your model are not associating right, take a look at your key fields. If you add up the subset ratio percentages of a key in each tables that i...

63 – Concatenated Keys

What do you do when you need to associate multiple fields between two tables? Qlik creates a synthetic key and everyone says that’s bad! First it’s good to understand what a synthetic key ...

77 – Keys

Here are a few things I strongly suggest in working with Qlik key fields. Make separate key fields* Prefix the field with ‘%’ Set HidePrefix variable to ‘%’ Use AutoNumber *Bec...