Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

suppressing values in straight tables

Hi,

I have a straight table with a name, previous months value, this months value and the growth.
dim: name
exp:

- previous month value: =sum({$<date={'$(vPreviousMonth)'}>} value)
- this month value: =sum(value) //i have a bookmark which selects the current month so it's the right data
- growth: =if(sum({$<date={'$(vPreviousMonth)'}>} value)<>sum(nbfte),(sum({$<date={'$(vPreviousMonth)'}>} value) / sum(value)-1) *-1)

now this shows the values when the value of this and previous month aren't the same. The other fields are empty... the problem is that i don't want to see the empty fields... but suppress zero values doesn't work. pls help 🙂

thx

1 Reply
mov
Champion III
Champion III

If I got the question right, you have columns A, B and (A-B), and you want to hide rows where A-B=0.
If this assumption is correct, one of possible solutions is to use conditions for A and B expressions:
A: if(A=B, 0, A)
B: if(A=B, 0, B)
In this case "suppress when 0" will work.