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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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