Slowness Issue With SSAS Tabular Data Connection

[shamiul_islam]

I created a dashboard with only two transaction table where one is Sales Table and another is Outstanding Table by connecting SSAS data connection. I created QVD file for those table and there is 1.5Cr + lines fetched by the dashboard. The dashboard became very slow when I click on an object, it will response 5-8 minutes later. And when I open the dashboard on developer/publisher mode it takes 5-8 minutes to open. How can I solve this slowness issue? If anyone know about this, help me to solve this issue.

Thanks in advance 🙂

[Brett_Bleess]

Not sure if this is what you are looking for or not, but couple of Design Blog posts with one idea:

https://community.qlik.com/t5/Qlik-Design-Blog/Enhancing-the-User-Experience-Using-Conditional-Expre...

https://community.qlik.com/t5/Qlik-Design-Blog/Enhancing-the-User-Experience-Using-Conditional-Expre...

Here is the base URL to this area if you wish to search further on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett