Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
epapathanasis
Partner - Contributor
Partner - Contributor

How to hide some rows based of criteria resulting from expression with set analysis

Hello,

I would like to hide rows in a pivot table when the result of expression is less or equal to 0.

Here is the exrpession: 

sum({<SalesDate={"$(='>=' & date(today()-365) )"} > } [Sales Amount])

Labels (3)
1 Solution

Accepted Solutions
epapathanasis
Partner - Contributor
Partner - Contributor
Author

Finally, I have decide to add new expression: if (Column(n) <= 0, Column(n)), who is referred to initial expression, wich i hid. And the problem solved.

View solution in original post

1 Reply
epapathanasis
Partner - Contributor
Partner - Contributor
Author

Finally, I have decide to add new expression: if (Column(n) <= 0, Column(n)), who is referred to initial expression, wich i hid. And the problem solved.