Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

pedlopes
Not applicable

Create interval in dimension calculate

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

3 Replies
sunny_talwar
Not applicable

Re: Create interval in dimension calculate

Have you thought about using a class function?

Class function

pedlopes
Not applicable

Re: Create interval in dimension calculate

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

sunny_talwar
Not applicable

Re: Create interval in dimension calculate

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

=Class(yourExpression, Interval, InBetweenLabel)


HTH

Best,

Sunny