Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor

Sort data into two categories


I have some data that needs sorting. The problem is that once the if condition is fulfilled by a value, that value gets sorted and cant be accessed again. As an example, say I need to sort one value into two categories. For the sake of the example let this be that I have the following task:

If([color]='red', 'red',

if([color]='red','RGB,'not assigned))

So basically I want to assign the value 'red' to its own category and to 'RGB'. How is that done?

I've been struggling with this for a long time now.

Thank you so much!

2 Replies
Valued Contributor II

Re: Sort data into two categories

you can categorize any value into one classification bucket at a time..

to achieve the your requirement, try to create 2 separate fields instead of 1 field...

If([color]='red', 'red','not assigned') as Calsifcation1,

If([color]='red', 'RGB','not assigned') as Calsifcation2..

you can try like this also..

If([color]='red', 'red-RGB','not assigned') as Calsifcation3

New Contributor

Re: Sort data into two categories

Thanks for the reply, I see your point. However, how can I access these new created buckets?