topic Re: Expression as a dimension in QlikView

Expression as a dimension

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

I have a table

I need a dimension, something similar to class function

if(Sum(Aggr(Sum(C),A))>=10 and Sum(Aggr(Sum(C),A))<20,'Low',

if(Sum(Aggr(Sum(C),A))>=20 and Sum(Aggr(Sum(C),A))<30,'Medium','High'))

So, I want Low, Medium, High as Dimension values and then want some expressions to be aggregated based on the calculated dimension.

Thanks

Naresh

sunny_talwar — Wed, 01 Aug 2018 13:30:23 GMT

Try this

Aggr(

If(Sum(C) >= 10 and Sum(C) < 20, 'Low',

If(Sum(C) >= 20 and Sum(C) < 30, 'Medium', 'High'))

, A)

Anil_Babu_Samineni — Wed, 01 Aug 2018 13:32:25 GMT

Will you able to create calc. dim like below?

=if([Sum(C)]>=10 and [Sum(C)]<20,'Low',if([Sum(C)]>=20 and [Sum(C)]<30,'Medium','High'))

=if(Aggr(Sum([Sum(C)]),A)>=10 and Aggr(Sum([Sum(C)]),A)<20,'Low',if(Aggr(Sum([Sum(C)]),A)>=20 and Aggr(Sum([Sum(C)]),A)<30,'Medium','High'))

NareshGuntur — Thu, 02 Aug 2018 06:51:55 GMT

Thanks Sunny

NareshGuntur — Thu, 02 Aug 2018 06:52:25 GMT

Thanks Anil. I tried this.