topic Re: if condition in set analysis. ? in QlikView

if condition in set analysis. ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How can I write this if condition in set analysis.

=If(Count(DISTINCT if(dealstate_id=8 or dealstate_id =9 ,customerIdNumber))>0,'Yes','No')

tresB — Fri, 27 Jul 2018 06:56:44 GMT

If(Count( Distinct {<dealstate_id={8,9}>} customerIdNumber) >0,'Yes','No')

nishanthi_8 — Fri, 27 Jul 2018 06:56:56 GMT

if(count(distinct {<dealstate_id={8,9}>} customerIdNumber)>0,'Y','N')

ogautier62 — Fri, 27 Jul 2018 06:56:57 GMT

Hi,

something like that :

if(count ({<dealstate_id = {8,9} >} distinct customerIdnumber ) >0,'yes','no')

it depends on your context : chart or textbox

may be add all in count if necessary

in a chart this will be calculated on your dimension

aggr if you want another dimension

regards