count with null values in chart

[Anonymous]

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

[#2]

Hi Filip,

u have not taken 'SalesAmount' as your dimension

please find attached Qvw

Regards

harshal

[#3]

please used Set Analysis in chart....

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

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

[maxgro]

try with the expression

count(If(SalesAmount>25000, SalesArea))

[#5]

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.

[santharubban]

try this

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