suppressing values in straight tables

Fri, 25 Mar 2011 14:50:21 GMT

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

suppressing values in straight tables

Anonymous — Fri, 25 Mar 2011 16:13:47 GMT

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.

topic suppressing values in straight tables in QlikView

suppressing values in straight tables

suppressing values in straight tables