Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am working on improving performance of my QVW. I have four tabs and I see two of the tabs are problematic. In those two tabs we are calculating 27 same measures. In each tab we are presenting the same measures in 5 different straight tables with different dimensions. When the QVW is opened from the access point its taking 1.45 minutes to load and switching between tabs is recalculating the measures. No if clauses are used. For all the measures I am using variables. For example In settings/variableOverview I have variable vTotal and the value I have is
sum({<DateType={'Resolved'},disputeStatus= >}DataTypeCounter) . I am using this variable in my expressions as $(vTotal).
Please let me know if there is anything I need to look into.
Any help is highly appreciated.
Thanks
Hi SRG,
Expression(Variable) seems easy ,but how much data it is calculating we need to consider for optimization.
i mean if you have GB's of data for each filter change application refresh will take time so try to archive data for some amount of data (Ex: if you are showing 10 years data now try to decrease for 4 years)
optimization will depend on below things also
For some more information please go through the below links
https://community.qlik.com/t5/New-to-QlikView/Best-Optimization-Techniques-Qlikview/m-p/1322791
https://community.qlik.com/t5/QlikView-Documents/Best-Practices-for-Optimizing/ta-p/1482469