What is Wildmatch and Mixmatch Function Where we u... - Qlik Community

jonesbrown · ‎2019-11-10

Hi All

I am new to Qlikview

What is Wildmatch and Mixmatch Function Where we use give me an example

plz help.

anat · ‎2019-11-11

hi Jones,

use the below link to know about match condition.

use cases are :

for performance wise we have to use match function in place of multiple IF condition like

if (Country='ABC' or Country='XYX',sales) as Sales this is the costly expression in terms of performance

so we can use the match function in place of If condition.

if(match(Country,'ABC','XYX'),sales) as Sales

Yousef_Amarneh · ‎2019-11-11

you can see the below links, the example included also

Yousef Amarneh

What is Wildmatch and Mixmatch Function Where we use give me an example