How to change the dimension in Funnel Chart based on Buttons clicks

[syedmazhar]

Hi All,

I have created a master dimension as i need to change the dimensions based on button click. In master dimension i have written Pick- Match and this is working fine. We can see the expected result but the chart is taking time to load the data due to which we are facing performance issue.

Expression in Master Dimension:

pick(Match($(Buttonchange),0,1,2),Region,Country,State)

This is working as expected, but the chart is taking time to load due the above logic.

Please help me on this performance issue.

Thanks in advance.

[Alan_Slaughter]

Hi  syedmazhar, maybe this link can help with diagnosing your performance. 

https://adminplaybook.qlik-poc.com/