topic Re: count with null values in chart in QlikView

count with null values in chart

Anonymous — Mon, 20 Jan 2014 11:10:15 GMT

Hi,

How to explain this... I have a problem counting with null values...
My issue is that when null values appears in my pivot table, i cannot use the count() function...

What I want to do, is to count how many sales areas where I sales over a fixed value (25000)...

Chart 1 shows values over 25000 with the following expression: sum(If(SalesAmount>25000, SalesAmount))

In Chart 2 I would like to count how many with the following expression: If(SalesAmount>25000, count(SalesArea))

My problem is that I get a null value (yellow marked) because of the "hidden" amount which is under Transport... that is removed cause of my condition with fixed price.

Please see my attached qvw-file.

Can someone tell me why this happens, and maybe suggest a solution that will resolve the problem.

Thanks in advance.

Best regards,

Filip

Re: count with null values in chart

Mon, 20 Jan 2014 11:26:55 GMT

Hi Filip,

u have not taken 'SalesAmount' as your dimension

please find attached Qvw

Regards

harshal

Re: count with null values in chart

Mon, 20 Jan 2014 11:28:01 GMT

please used Set Analysis in chart....

Sum({<SalesAmount={">25000"}>}SalesAmount)

Count({<SalesAmount={"25000"}>}SalesArea)

Re: count with null values in chart

maxgro — Mon, 20 Jan 2014 11:39:41 GMT

try with the expression

count(If(SalesAmount>25000, SalesArea))

Re: count with null values in chart

Mon, 20 Jan 2014 12:03:04 GMT

Hi,

Try adding SalesAmount as a dimension. Attached is the sample qvw. See the difference if you enable and disable the salesamount dimension as well.

Re: count with null values in chart

santharubban — Mon, 20 Jan 2014 17:30:06 GMT

try this

Count({<SalesAmount={"> 25000"}>}SalesArea)