Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Iam new to qliksense, could you please help how to optimize the below wildmatch.
IF(Unit='myunit' AND WildMatch (section,'*100*','*101*','*103*','*104*','*105*','*106*','*107*','*108*','*109*','*110*','*111*') , DUAL('VIP Unit',1),
IFUnit='myunit' AND WildMatch (section,'*172*','*173*','*174*','*175*','*176*','*177*','*178*','*179*','*180*','*181*','*182*','*183*','*184*','*185*','*186*','*187*','*188*','*189*','*190*'), DUAL('Director Unit',2))) AS UnitSUB_unit
Below one will make better.
Pick(Wildmatch(section,'*100*','*101*','*103*','*104*','*105*','*106*','*107*','*108*','*109*','*110*','*111*')+1, DUAL('Director Unit',2), DUAL('VIP Unit',1))
It looks good to me as is. Do you have a concern?
If you can show what the entire section value looks like, I may have a suggestion.
-Rob
You could use a mapping, see: Mapping-and-not-the-geographical-kind
- Marcus