Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have 6 different sheets with multiple straight tables (each KPI expression is bit bigger with set analysis). I need to build homepage where it should have a another straight table which shows Total values of each straight tables from other 6 sheets.
If i am using same expressions with Total function, i am getting the values however it is creating performance issue. Homepage table is taking lot of time to calculate.
In excel, if we need to get value from another sheet, we simply take the sheet and cell info. Do we have the same way in Qlik like using sheet/chartID/KPI name can we get the information into homepage table?
Please give any another suggestion which improves performance. I have tried with variable but no use, there is no chance of changing anything at back end.
Thanks in advance.
Regards,
Raju
By removing Count Distinct, by using flag you could improve your expressions performance.
As far as I known there is no way to refer to the other straight table expression.
Thank you.
Friends, any other suggestions?