Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Anonymous
Not applicable
Author

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.