topic Re: Set Analysis in Condition for Dimension in QlikView

Set Analysis in Condition for Dimension

byrnel0586 — Fri, 21 Apr 2017 15:38:03 GMT

Hi,

I have dimension which I only want the value to show when: Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0

I have the above expression in the 'Enable Conditional' box, but it's still showing for all Gaps even when not >0.

Have I done something wrong?

Thanks,

Linda

Re: Set Analysis in Condition for Dimension

Anonymous — Fri, 21 Apr 2017 15:40:05 GMT

this expression will be calculated without dimension for the whole chart...

you could change your expression:

if(Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0 ,Sum({<MeasureID={'OMW'},Month=,Year=>}Gap) )

Re: Set Analysis in Condition for Dimension

byrnel0586 — Fri, 21 Apr 2017 15:44:00 GMT

Thank you. I tried that. The dimension is actually 'DUE_DATE' so I only want the DUE_DATE to show when:

Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0 )

Based on your response I tried in the Enable Condition:

if(Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0 ,DUE_DATE )

and it also did not work.

Re: Set Analysis in Condition for Dimension

Anonymous — Fri, 21 Apr 2017 15:50:37 GMT

no, you must change the expression not the condition for the expression...

Re: Set Analysis in Condition for Dimension

byrnel0586 — Fri, 21 Apr 2017 15:55:58 GMT

I also tried that and I get "// Error in calculated dimension". It is a pivot table and on an individual patient level for each row. Did I miss something in the expression maybe?

Re: Set Analysis in Condition for Dimension

Anonymous — Fri, 21 Apr 2017 15:57:25 GMT

please post a sample...

Error in calculated dimension appears , if you use aggregation functions without aggr() in the calculated dimension...

Conditional disables the whole dimension / expression, not only a row...