topic Optimizing Wildmatch in App Development

Optimizing Wildmatch

Anonymous — Fri, 30 Nov 2018 02:18:06 GMT

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

Re: Optimizing Wildmatch

Anil_Babu_Samineni — Fri, 30 Nov 2018 04:13:02 GMT

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))

Re: Optimizing Wildmatch

rwunderlich — Fri, 30 Nov 2018 05:46:14 GMT

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

Re: Optimizing Wildmatch

Anonymous — Fri, 30 Nov 2018 08:26:16 GMT

I have around 50 such if and pick wildmatch selections. is there any other function to optimize the script

Re: Optimizing Wildmatch

marcus_sommer — Fri, 30 Nov 2018 14:32:15 GMT

You could use a mapping, see: Mapping-and-not-the-geographical-kind

- Marcus