topic Re: Banding in QlikView

Banding

kevbrown — Thu, 02 Oct 2014 14:13:09 GMT

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

Re: Banding

Gysbert_Wassenaar — Thu, 02 Oct 2014 14:24:30 GMT

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

Re: Banding

kevbrown — Thu, 02 Apr 2015 08:10:17 GMT

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

Re: Banding

Gysbert_Wassenaar — Fri, 03 Apr 2015 09:57:45 GMT

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.