Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscools
Creator II
Creator II

How to exclude lines in a pivot table if 0 is result for an expression

Hello,

i have a pivot table with a few dimensions and a few expressions.

one of these expressions is :

sum ( { < OrderStatus={"Placed", "On hold"}>} OrderPriceUnitNet * OrderQtyOpen) - sum ( {<Orderstatus = { " Placed", "On hold"}>} OrderPriceUnitNet * OrderQtyInPicking)

I would only that a line appears in my pivot table when te above expression is bigger then zero.

In the example attached i have 2008 lines, but only  23 of them have an "# open total" that is bigger then zero and therefore relevant.

What can i do to exclude these not relevant lines?

thanx very much!!!

grtz,

chris

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
its_anandrjs

Try to use option      in chart properties >> dimension >> suppress When Value is Null option by selecting the dimension and apply that.

Regards

Anand

Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

chriscools
Creator II
Creator II

Hey Gysbert,

Thank you for your solution, it works perfect!!

i also tried supressing the null values on the dimension as Anand Chouhand suggest, but i guess this doesn't work because it's not the dimension which has null values, but the the calculated that must be seen as  a null just as you suggest?

grtz,

chris

Gysbert_Wassenaar

Yes, all the expressions should be zero in order for the row to be suppressed. There could be other ways of making sure of this, but those will likely perform worse.


talk is cheap, supply exceeds demand