Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

filter out into the data containing Medicine = {"*FENTANYL*", "*HYDROMORPHONE*", "*MORPHINE*", "*OXYCODON"} into new category OpioidMedicines in set

can i do this with set analysis where the data containing the following keywords be grouped as opioid and just display the others as it is 

Labels (1)
1 Reply
Digvijay_Singh

Don't think so, The better way to do is in the script like below - 

If(wildmatch(Medicine,'*FENTANYL*', '*HYDROMORPHONE*', '*MORPHINE*', '*OXYCODON'),'OpioidMedicines', Medicine) as Medicine_Formatted