topic Re: Calculated Dimension field error in QlikView

Calculated Dimension field error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am trying to determine a dimension field based on a calculation.

The value 1 gives the count when the FLAG dimension is COMP

The value 2 gives the count when the FLAG dimension is NO COMP.

The value 3 gives the total number of COUNT for the selected period

When the value 2 is more than 10%, then the dimension should be simply be NO_COMP and ignore COMP.

I tried to calculate a dimension field based on this, it gives me an error.

Please any one can hint me the error or say me the way to achieve it.

Thanks in advance

Jegadish

Hi Sunny,

I have added an example as requested

Jegadish

Re: Calculated Dimension field error

sunny_talwar — Tue, 09 Aug 2016 10:12:51 GMT

You will need to wrap your expression around with the Aggr() function and use the dimension you are doing the two counts against

Re: Calculated Dimension field error

Anonymous — Fri, 12 Aug 2016 07:28:41 GMT

Hi sunny, thanks for your suggestion,

I tried this sentence, it gives me an error.

FLAG IS THE DIMENSION, it contains two values 'COMP & NON COMP')

IF THE COUNT OF NON_COMP is superior to 10% then the DIMENSION FLAG should be considered as NON COMP otherwise it gets the value of the DIMENSION)

=If(Aggr(FLAG, count(distinct {<FLAG = {'NO COMP'}>})/count(distinct {<FLAG = {'NO COMP','COMP'}>}) > 10, 'NO COMP', FLAG))

Thanks in advance for your kind help

Re: Calculated Dimension field error

sunny_talwar — Fri, 12 Aug 2016 09:50:54 GMT

Would you be able to share a sample?

Re: Calculated Dimension field error

sunny_talwar — Fri, 12 Aug 2016 14:02:24 GMT

I guess we have managed to resolve this outside of Qlik Community, would you be able to close this thread by providing a jist of what was needed and closing this thread by marking either your own response as correct or marking assumed answer.

Best,

Sunny

Re: Calculated Dimension field error

Anonymous — Fri, 12 Aug 2016 14:31:55 GMT

=Aggr(If(Count(DISTINCT {<FLAG = {'NO COMP'}>}FLAG)/Count(DISTINCT {<FLAG = {'NO COMP','COMP'}>}FLAG) > 0.10, 'NO COMP', FLAG), DEPADR_PAYS_LIB, MAG_LIBELLE)