Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Filip,
u have not taken 'SalesAmount' as your dimension
please find attached Qvw
Regards
harshal
please used Set Analysis in chart....
Sum({<SalesAmount={">25000"}>}SalesAmount)
Count({<SalesAmount={"25000"}>}SalesArea)
try with the expression
count(If(SalesAmount>25000, SalesArea))
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.
try this
Count({<SalesAmount={"> 25000"}>}SalesArea)