Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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