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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot: Hide Rows where Values > ???

I have a Pivot Table where I want to Hide all Values smaller than e.g. 10.000.

I do not want to see an empty field but I would like to hide the complete row like it is  not in the selection. Is this possible?

Thanks in advanced

Thomas

2 Replies
Jason_Michaelides
Partner - Master II
Partner - Master II

Hi Thomas,

See attached - you need to put the same IF statement in all expressions.

Hope this helps,

Jason

SunilChauhan
Champion II
Champion II

see the attched file

hope you required this

Sunil Chauhan