Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis Difference

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

H

1 Solution

Accepted Solutions

Re: Set Analysis Difference

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

transform in

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


Let me know

3 Replies

Re: Set Analysis Difference

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

transform in

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


Let me know

Employee
Employee

Re: Set Analysis Difference

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))

Not applicable

Re: Set Analysis Difference

Thanks guys,

I think I was half asleep....

Herbert

Community Browser