topic Re: Create interval in dimension calculate in QlikView

Create interval in dimension calculate

Anonymous — Tue, 07 Apr 2015 19:22:12 GMT

Hi all,

I need some help with this calculate dimension.

=if(sum(Unit_base_demand*PrecoSimu2)>50,Dual('>50',1),if(sum(Unit_base_demand*PrecoSimu2)>100,Dual('>100',2),if(sum(Unit_base_demand*PrecoSimu2)>150,Dual('>150',3),Dual('>200',4))))

I need to create a calculate dimension with sales value at intervals.

I need to turn 'sum(Unit_base_demand*PrecoSimu2)' on the field??

Tanks in advance,

Pedro Lopes

Re: Create interval in dimension calculate

sunny_talwar — Tue, 07 Apr 2015 19:39:29 GMT

Have you thought about using a class function?

Class function‌

Re: Create interval in dimension calculate

Anonymous — Tue, 07 Apr 2015 20:40:24 GMT

I try but my problem is i don´t have a fisical field. I want to create class function with calculated value or create a new field.

Like this, Field1=sum(Unit_base_demand*PrecoSimu2)

It´s possible?

Tanks

Re: Create interval in dimension calculate

sunny_talwar — Tue, 07 Apr 2015 20:48:36 GMT

I believe it is, you can use a calculated field to be within your class function.

=Class(yourExpression, Interval, InBetweenLabel)

HTH

Best,

Sunny