topic How to use set analysis in if condition? in QlikView

How to use set analysis in if condition?

lawrance — Fri, 27 Jan 2017 18:33:39 GMT

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

sunny_talwar — Fri, 27 Jan 2017 18:34:57 GMT

Can you share what is included within the variables?

lawrance — Fri, 27 Jan 2017 18:53:33 GMT

HI,

I variable I just use current date and month start date

Thanks,

Lawrance. A