Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
lawrance
Creator II
Creator II

How to use set analysis in if condition?

Hi,

Please help me to use set analysis for the below chart expression.

=If(GetSelectedCount(Field_Name)>=1 and GetSelectedCount(Field_Name2)>=1,0,

if(GetSelectedCount(Field_Name3)>=1 and GetSelectedCount(Field_Name2)>=1,0,

if(Count(if(Field_Name>=$(variable1) and Field_Name1<=$(variable2), field_Name4,null()))>0 and '$(variable)'='value1' and '$(variable2)'='value2',1,

if(count(if(Field_Name2=GetFieldSelections(field_name2),field_4,null()))>0 and '$(variable1)' = 'value' and '$(variable2)'='value2',1,0))))

Thanks,

Lawrance A

2 Replies
sunny_talwar

Can you share what is included within the variables?

lawrance
Creator II
Creator II
Author

HI,

I variable I just use current date and month start date

Thanks,

Lawrance. A