Count(Difference=0) as a pie chart expression

Tue, 17 Feb 2015 10:50:37 GMT

Hi all,

This might be a really simple question to you all but i'm struggling a bit so would really like some help, thanks a lot in advance.

I am creating this pie chart with the hope to demonstrate the number of difference (between the same variable in two difference dataset) that are 1) =0, 2) <>0 . The field name I used is called 'Difference' and so my two expressions are 1) Count(Difference=0) and 2) Count (Difference <>0). However the end result is just showing me half and half for each expression which doesn't match the actual data.

Does anyone one know what went wrong and how I could rectify this?

Thanks again!

Re: Count(Difference=0) as a pie chart expression

jonathandienst — Tue, 17 Feb 2015 11:02:57 GMT

The expressions should be like:

Count({<Difference = {0}>} <some field that is never null>)

Count({<Difference -= {0}>} <some field that is never null>)

Count needs to count something, so use a field that has no null values and replace the placeholder in these expressions with that field name.

HTH

Jonathan

topic Count(Difference=0) as a pie chart expression in QlikView

Count(Difference=0) as a pie chart expression

Re: Count(Difference=0) as a pie chart expression