Qlik : 009_Section Access : Data Reduction using Link Table (Create Field combinations dynamically)
In video number 6, we learnt how to do data reduction in Qlik Sense application using Link Table. We have to create Link Table by various field combinations.
For 2 fields we have 2*2 (i.e. 4 combinations).
For 3 fields, we have 2*2*2 (i.e. 8 combinations).
For 4 fields we have 2*2*2*2 (i.e. 16 combinations) and so on.
It is difficult to manually create all these combinations. In this video, I will show you how create these combinations dynamically by writing only few lines.
I am not the original author of this script as I have seen this long time ago on a blog post. Unfortunately, I haven’t remembered where exactly I read this but at that time, I just implemented on one of my application and it worked like a charm. So, the credit goes to the person who wrote it. If you know the person’s name, do comment below. I will update his/her name in my description.
Before watching this video, you must had checked video number 6. Also, I am hoping that you know how to use For Loop and Peek function in Qlik Sense script.
#qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #qlikdatamodel #LinkTable #Loop #Peek