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

Change in Sales Pivot

Hi stalwar1

In the attached QVW you had helped me create a filter for change in values (Increase or Decrease). Now, how do I show the increase and decrease values in separate pivot tables?  Instead of using the Change filter if I need to show a pivot table with increase values and another pivot table with decreased values how can we achieve that?

12 Replies
sunny_talwar

On the presentation tab select 'Suppress Zero Value'

Not applicable
Author

I am currently selecting 'Suppress Zero Value' but still it's giving those lines with '-' values.

sunny_talwar

Do you have may be another expression? Not sure, I would have to take a look at it...