Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

siepe1990
New Contributor II

Grouping List Box Values

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.

Tags (2)
1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Grouping List Box Values

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')))

2 Replies
nagaiank
Valued Contributor III

Re: Grouping List Box Values

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')))

siepe1990
New Contributor II

Re: Grouping List Box Values

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

KR,

Stefan

Community Browser