Discussion board where members can get started with Qlik Sense.
I have the Following table:
The expresssion is as follows:
If(WildMatch(Factory_Code,'4*'),'Exclude service center',
Factory_Code= '9001' or
If(WildMatch(Factory_Code,'*'),'Standard'))) as Factory_Section.
In this code, I want the third condition to display all the Factory_Codes (i.e. it should include the values of 'Exclude service center' and 'Exclude HO' as well)
The Output should be as follows:
However in Future, the Factory_Codes may increase or decrease.
So wanted the necessary changes to be made in the Code.
Thanks in Advance.
Go to Solution.
you can do it with the below script:
Factory_Code='8008','Exclude HO' )) as Factory_Section
'Standard' as Factory_Section
why do you need the third condition ?
what's your desired result on UI ?
I know that No selections with give all the Factory_Codes, but i want it to happen on the 'Standard' selection.
Basically that's a requirement I need to fulfil.
This works perfectly,
Thank you ..!!
Then please close the thread by marking the correct answer as correct