topic Set analysis issue in QlikView

Set analysis issue

samvile18 — Fri, 16 Nov 2012 14:45:50 GMT

Hi all,

I'm trying to write some set analysis do the following:

Count all scheme numbers where the MEASURE is 'Total Members' and the VALUE is inbetween two variables input by the user, this is what I have and I can't get it to work!

=if(vMaxDate=vMaxExtract,Count(DISTINCT{<Measure={'Total Members'},Value={">=$(=Input 1)<=$(=Input 2)"}>}[Scheme No]),0)

The two max date variables just make sure I'm looking at the latest data.

Can anyone see where I'm going wrong?

Re: Set analysis issue

Fri, 16 Nov 2012 16:43:47 GMT

Try the following:

=if(vMaxDate=vMaxExtract,Count(DISTINCT{<Measure={'Total Members'},Value={'>=$([Input 1])'}, Value={'<=$([Input 2])'}>}[Scheme No]),0)

Re: Set analysis issue

MayilVahanan — Fri, 16 Nov 2012 16:57:40 GMT

Try like this

=if(vMaxDate=vMaxExtract,Count(DISTINCT{<Measure={'Total Members'},Value={'>=$([Input 1])<=$([Input 2])'}>}[Scheme No]),0)

Hope it helps

Re: Set analysis issue

Clever_Anjos — Fri, 16 Nov 2012 17:14:40 GMT

You shouldn´t mix >= and <= at same SA. Use the intersection operator "*"

=if(vMaxDate=vMaxExtract,Count(DISTINCT{<Measure={'Total Members'},Value={">=$(=Input 1)"}*{"<=$(=Input 2)"}>}[Scheme No]),0)

Re: Set analysis issue

whiteline — Fri, 16 Nov 2012 18:17:43 GMT

=if(vMaxDate=vMaxExtract,

Count(DISTINCT {<Measure={'Total Members'},Value={">=$(=[Input 1])"}>} * {<Measure={'Total Members'}, Value={"<=$(=[Input 2])"}>} [Scheme No]),0)