Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
patrou38
Creator
Creator

Calculated dimension

Hello,

as you can see in the attached dimension (Day), I have a simple chart with 1 dimension and 1 experession.

I would like aggregate the dimension by days >=10 and Day >= 15  and day <=16.

i really don't know how I can do that 😞

thank you for your help.

Patrick

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Use this as dimension:

=if(Day>=10 and Day<15,'>=10', if(Day>=15 and Day<16, '>=15',if(Day<=16 , '<=16')))

View solution in original post

3 Replies
sunny_talwar

Are you looking for something like this?

Capture.PNG

Frank_Hartmann
Master II
Master II

Use this as dimension:

=if(Day>=10 and Day<15,'>=10', if(Day>=15 and Day<16, '>=15',if(Day<=16 , '<=16')))

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Why not trying to use Class function:

Screenshot_2.jpg