Grouping the categories in QlikView

[sujayrpatil]

I have one field called "OS Combination" and below is the list of field values I have.

ALL

ANDROID & IOS & MAC

ANDROID & MAC

ANDROID & WINDOWS & MAC

ANDROID ONLY

IOS & ANDROID

IOS & MAC

IOS & WINDOWS & ANDROID

IOS & WINDOWS & MAC

IOS ONLY

MAC ONLY

WINDOWS & ANDROID

WINDOWS & IOS

WINDOWS & MAC

WINDOWS ONLY

From the above field I need to create another filter which should contain ANDROID, WINDOWS, IOS , MAC.

So when I select ANDROID form this list box ANDROID related string should be selected in the above filter.

same for IOS , MAC and WINDOW. How can I create filter based on the above list of the field values.

Thanks,

Sujay

[martinpohl]

Hi 

add to your script:

Temp:

load

"OS Combination",

subfield("OS Combination",' ') as OS

resident Yourtable;

OS:

noconcatnate load

"OS Combination",

OS

resident Temp where not match(OS,'&','ONLY');

drop table Temp;

then you will get for eample for the line 

ANDROID & MAC

Combined,            OS

ANDROID & MAC, ANDROID

ANDROID & MAC, MAC

Regards

[Brett_Bleess]

Have a look at the following Design Blog post, it might be another way to go at things possibly.

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett