Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I noticed a performance issue after I created a specific visualization in Qlik Sense. I believe the performance issue was caused due to a high amount of 'if' clauses that I used. I have two separate tables for two different items and they have different fields, so for instance:
- I have created three drop-down menus, using a variable extension. For each of these drop downs there is a variable that I have created. The drop-downs are supposed to filter the data that I have. Each of the options in the drop-down menus have conditions such as the below one:
=if(vVariable='Device1', 'Field1'
,if(vVariable='Device2', 'Field2'))
- I created a bar chart that also has some conditions and is supposed to be working with the drop down menus.
Basically, what I notice as a result is that the too many conditions that I put are causing the visual to load for more than 6 minutes every time you change a selection in the drop-down menus.
So, I am wondering is there an easier way to do this? Imagine that you need to display data for two different devices on the same page. Meaning that somewhere you should be able to select which of the two devices you want to see calculations for... Is there any possibility to create sub-sheets in the main sheet for example? So that I can completely avoid the too many 'if' conditions that are causing Qlik to be slow?
Thank you in advance,
Shelly
Maybe just use alternate state?
Hi Lorenzo,
Thanks for your reply!
Do you have something as an example that I can see?
Best Regards,
Shelly
See Alternate State sheet in the attached
Let me know if you are looking for something different