Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
alwinsch
Creator
Creator

Cyclic Group - don't show Zero values

Hi,

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.

For example.

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.

Kind Regards,

Alwin

1 Solution

Accepted Solutions
jonathandienst

Hi

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

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
anantmaxx
Specialist
Specialist

IN YOUR EXPRESSION

ADD IF ( SUM(AMOUNT)>0,SUM(AMOUNT))

AND CHANGE YOUR CYCLIC GROUP IT WILL SHOW ONLY THOSE COUNTRY OR CUSTOMERS WHEN

> 0

REGARDS,

ANANT

alwinsch
Creator
Creator
Author

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))???

thanks.

A.

jonathandienst

Hi

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

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post