topic Re: Grouping List Box Values in QlikView

Grouping List Box Values

Anonymous — Mon, 23 Jul 2012 12:02:49 GMT

Hello everyone,

I have a Dashboard which shows how many 'Days of Sales' a customer has outstanding at the moment.

Values range from everywhere between 0 and 400.

I'm trying to create an easier way to select all values below or above a certain value (or between two values).

So I have a list box with all the values (1, 2, 3, 4, 5, etc. etc. 300, 301, 310, etc. etc.).

Now I want to create groups, let's say <10, >10<50, >50<100,>100.

Is there a way to do this? I have been searching for a solution, but can't find one...

Thanks in advance!

Kind regards,

Stefan.

nagaiank — Mon, 23 Jul 2012 12:12:00 GMT

Create a list for the expression

=If([Days of Sales]<10,'<10',If([Days of Sales]<50,'10-50',If([Days of Sales]<100,'50-100','>100')))

Anonymous — Mon, 23 Jul 2012 12:14:59 GMT

Wow, that simple huh Thanks, often the simplest way is the best (I had been working in my script and everything )

KR,

Stefan