topic Set Analysis Difference in QlikView

Set Analysis Difference

Tue, 07 Oct 2014 13:42:37 GMT

Hi All,

Could someone please shed a bit of light on this dillema, when no selections have been made, why would the following expressions give different results:

1) Count({$<[Float beds] = {'Good'}>} NTIMB) and

2) Count(If([Float beds] = 'Good',NTIMB,0))

The first one gives me the correct results, but objects won't change when I make selections from list boxes, which I need it to.

Thanks

Re: Set Analysis Difference

alexandros17 — Tue, 07 Oct 2014 13:44:37 GMT

Pay attention, the secount expression counts even zero values ...

transform in

Sum(If([Float beds] = 'Good',1,0))

Let me know

Re: Set Analysis Difference

Clever_Anjos — Tue, 07 Oct 2014 13:45:49 GMT

I think you should SUM, instead of count, because counting 0´s returns them too

1) Count({$<[Float beds] = {'Good'}>} NTIMB) and

2) SUM(If([Float beds] = 'Good',NTIMB,0))

Re: Set Analysis Difference

Tue, 07 Oct 2014 13:47:15 GMT

Thanks guys,

I think I was half asleep....

Herbert