Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
valpassos
Creator III
Creator III

Grouping value intervals

Hi again community,

I've the following scenario:

I have a version field consisting of values 0.1, 0.1, 0.2,... 1.0, 1.1, 1.2,... 2.0

And I want to group these by saying that

from 0.1 version to 1.0, it's 1st review cycle.
from 1.1 to 2.0, it's 2nd review cycle
...

...

And so on.

I will then group this by my dimension and use it as a filter on my application and on my metrics.

I want to do this on script, on my fact table - but I don't know how to group these values. Using IF's? Interval match? Class() ?

Thanks in advance!,

Lisa

Labels (1)
1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

You can use the Ceil() function; see attached

GroupingValueIntervals.png

View solution in original post

2 Replies
lorenzoconforti
Specialist II
Specialist II

You can use the Ceil() function; see attached

GroupingValueIntervals.png

valpassos
Creator III
Creator III
Author

Oh, wow, that is a neat trick!

Thanks @lorenzoconforti 🙂