Suppress Row in Pivot Chart

[jzimolong]

I've been trying to figure this out, based on a separate question in the following thread:

http://community.qlik.com/thread/148381

In attached file, how can the Pivot Chart only display rows where "RCA_WISE" has a value?

Seems simple enough, but no matter what I try, it is not working.

[Clever_Anjos]

Change your expression to

if(Rank( Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO),0)

and tick 'Supress zero values' at presentation tab

[morganaaron]

This doesn't work unfortunately, neither does the above suggestion, as when using the rank() function it disables the ability to suppress zero values entirely.

[jzimolong]

Ok, I'm installing SR7, so I'll report back to see if my issue is resolved.

[jzimolong]

Sure enough, I installed SR7 and it works now.  Thanks for the lead on the version Reshma.

[Clever_Anjos]

I´ve just did it here