Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

Hi All

I am new to Qlikview

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

plz help.

 

2 Replies
Highlighted
Creator
Creator

hi Jones,

use the below link to know about match condition.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Condi...

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