topic Re: Calculated Dimensions in QlikView

Calculated Dimensions

Mon, 26 May 2014 04:42:12 GMT

Hello!

I have a couple of tables and charts that have the following expression as a calculated dimension:

= IF (FLAG_ANOMALY = 1, 'Anomaly',

IF (FLAG_ANOMALY = 0 AND FLAG_INSPECTION = 1, 'No Anomaly')

I use that expression to show that value depending on the flag and other conditions.

Do you recommend me to use it directly in the script for better performance?

(In general, is it better to avoid calculated dimensions if we could?)

Should I get the same result?

Thank you!!!

Re: Calculated Dimensions

tresB — Mon, 26 May 2014 04:47:08 GMT

Yes, if your data size is big, it would be better to do it in the script using mapping , and you should get same result.

Re: Calculated Dimensions

Mon, 26 May 2014 04:51:03 GMT

And would it work if I use the conditionals I mentioned on the corresponding table that have the anomalies?

Re: Calculated Dimensions

tresB — Mon, 26 May 2014 06:55:39 GMT

Yes, that would work too. However, it is suggested to avoid multiple IFs statement. So, if mapping doesn't help, you could think of another alternative of using Pick(Match(....combination that is comparatively better that IFs in terms of performance.