Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
chapil
Contributor III
Contributor III

OR & AND with a SET ANALYSIS

Hello guys, 

 

Need some help again about set analysis expression 

Cause I don't want to use if everywhere I need to manage with the set analysis expression 

This is my table  : 

chapil_1-1636735780626.png

 

 

So I want to select : 

Immo name = 1  and  asset_number_null =1 or (asset_number_null=0 and <500 =1)

I don't have the solution to do the "or" 

the correct answer here will be : all expect the last one

 

I'm asking cause I m not sure this is working as well : 

Count({$ < [Immo name]= {1}, [Asset number null] = {1}, [<500]= {1}>} ID)

Thanks in advance for your help 

 

NB: All my mesure are calculated

 

Labels (3)
1 Reply
Digvijay_Singh

Something like this may be, didn't test though - 

Count({$ < [Immo name]= {1}, [Asset number null] = {1}> +
<[<500]= {1},[Asset number null] = {0}>}
ID)