Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

OR Logic

Hello, 

How can I only show subregions called 'Logan' or 'Beaudesert' in a table? 

The below isn't working - 

=if([SubRegion]='Logan' or
[SubRegion]='Beaudesert',
[SubRegion])

 

Thanks 

Labels (3)
1 Reply
Taoufiq_Zarra

@Taylorcc 

for exemple for this input :

Taoufiq_Zarra_0-1628001878029.png

 you can use this expression :

=if(Match(SubRegion,'Logan','Beaudesert')>0,SubRegion)

output:

Taoufiq_Zarra_1-1628001917754.png

and Supress when Value is Null

you can use also wildmatch 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉