Discussion board where members can get started with QlikView.
I have a table wit one dimension
a cyclic group and a couple expressions.
But i want to show only values with the expression > 0.
Cyclic group : Country, customer_name.
expression : sum_of_Amount.
When i use Country, i want to see only countries with sum_of_amount >0
if i switch to Customer_name, i want to see only customers with sum_of_amount > 0
how to solve this, because now i get everything also the 0 Rows.
Go to Solution.
If you use Sum(AMOUNT) in the first expression and If(Column(1) <> 0, Sum(PRICE), 0) in the second expression and turn on suppress zeroes, then the row will not display if Sum(AMOUNT) is zero.
Is that what you had in mind?
Hope that helps
IN YOUR EXPRESSION
ADD IF ( SUM(AMOUNT)>0,SUM(AMOUNT))
AND CHANGE YOUR CYCLIC GROUP IT WILL SHOW ONLY THOSE COUNTRY OR CUSTOMERS WHEN
But i have another expression where i also do a Sum of price.
So if both are 0 i don't want to show the row, otherwise i have to show all values.
do i have to add in the other expression also
IF(SUM(PRICE) > 0, sum(Price))???