Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kevbrown
Creator II
Creator II

Banding

Easy one I'm sure and I think I need to use the class function but just to check

I have a Straight table of data and i need a banding column,  The column I need banded is Project Period with values of 0 up to 96. I need these banded in 0<10, 10<20, 20<30 etc.

Should i use the class function

1 Solution

Accepted Solutions
Gysbert_Wassenaar

If your intervals are all the same then the class function is the easiest way to create the bands: class([Project Period],10)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

If your intervals are all the same then the class function is the easiest way to create the bands: class([Project Period],10)


talk is cheap, supply exceeds demand

View solution in original post

kevbrown
Creator II
Creator II
Author

What if the intervals are different. For example. I have a field that i want to count and put into bandings of - 1,2,3,4,5,6,7, 8-14, 15-21, 22-28, 29 days - 6 months, 6 months - 12 months and > 12 Months

Kev

Gysbert_Wassenaar

You can use a largish nested if statement or create another table with the intervals and use the intervalmatch function to match the intervals to your period values.


talk is cheap, supply exceeds demand