topic Referring Calculated Dimension in an Expression - Optimization in QlikView

Referring Calculated Dimension in an Expression - Optimization

Wed, 15 Feb 2017 22:32:31 GMT

Hi,

I have a straight table that has a column "CompletionStatus" which is a calculated dimension( If (ConditionSatisfied), 'Completed', 'Not Complete')). Now, I have a second column StudentDescription which should populate only when CompletionStatus='Completed'. I tried if(CompletionStatus='Completed', StudentDescription, Null()). But, this does not seem to work, since CompletionStatus is not a field. For now, I am using the expression in CompletionStatus to make the second column StudentDescription work If (ConditionSatisfied), StudentDescription, Null())).

But this is causing performance issues as I have millions of records, and every record has an associated CompletionStatus and StudentDescription.

How can I optimize the expression If (ConditionSatisfied), StudentDescription, Null())). for better performance?

Thanks!

Re: Referring Calculated Dimension in an Expression - Optimization

aarkay29 — Thu, 16 Feb 2017 05:13:46 GMT

the best approach would be to move the calculation to script if possible.
Limit the number of rows in the straight table by specifying in the presentation tab.
or On open sheet make predefined selections such as Current month/year to limit the no.of rows

Re: Referring Calculated Dimension in an Expression - Optimization

sasikanth — Thu, 16 Feb 2017 05:57:02 GMT

And one more thing is Force user to select any combination of filters so that the no.of records will be reduced .

Ex: Year, Month etc.

1) Create a calculation condition in chart general properties

GetselectedCount(Year)<0 and GetselectedCount(Month)>0

2) Go to Error Messages and select Condition unfulfilled Then write a message

"Please select at least one Year and Month" it will be easy for the user