topic Re: Suppress Row in Pivot Chart in QlikView

Suppress Row in Pivot Chart

jzimolong — Thu, 15 Jan 2015 15:33:49 GMT

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.

Re: Suppress Row in Pivot Chart

morganaaron — Thu, 15 Jan 2015 15:35:24 GMT

Hi Joseph,

If you go to the Presentation tab and select 'Suppress Zero-Values' this will get rid of anything not returning a rank.

Re: Suppress Row in Pivot Chart

jzimolong — Thu, 15 Jan 2015 15:37:08 GMT

Yes, I tried that and it does not work, in context of this particular chart. That is what I'm trying to figure out, it doesn't make sense why it is not working.

Re: Suppress Row in Pivot Chart

morganaaron — Thu, 15 Jan 2015 15:38:25 GMT

I downloaded your attached document, selected suppress zero-values, and it seems to work fine for me?

Re: Suppress Row in Pivot Chart

jzimolong — Thu, 15 Jan 2015 15:41:51 GMT

I just opened the .qvw you attached and I still see the empy rows (with dashes). I'm not sure what is happening.

Re: Suppress Row in Pivot Chart

reshmakala — Thu, 15 Jan 2015 15:50:35 GMT

Even I find it working fine when I select Supress Zero-values. Might be a bug in your version?

Re: Suppress Row in Pivot Chart

jzimolong — Thu, 15 Jan 2015 15:54:44 GMT

I've got Version 11.20.11922.0 SR2

Seems strange there would be a bug like this. Could you send screen shot of what it looks like, or re-attach the .qvw you got it working with, like Aaron did?

Re: Suppress Row in Pivot Chart

reshmakala — Thu, 15 Jan 2015 15:58:35 GMT

See the snapshot below and the application attached. I use 11.2 SR6

Re: Suppress Row in Pivot Chart

morganaaron — Thu, 15 Jan 2015 16:05:34 GMT

I think this could be your issue - I've got SR8 and SR2 running on various platforms, it works fine for me on SR8 but has the same issue you're seeing in SR2.

EDIT: Ah - just read from a previous thread that suppression of zero values is automatically disabled when the Rank() function is used and NULL values are disregarded. I'm assuming this is handled differently in later SRs than SR2 hence the difference.

Re: Suppress Row in Pivot Chart

Thu, 15 Jan 2015 16:12:59 GMT

Hi Joseph,

PFA

Re: Suppress Row in Pivot Chart

Clever_Anjos — Thu, 15 Jan 2015 16:14:01 GMT

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

Re: Suppress Row in Pivot Chart

morganaaron — Thu, 15 Jan 2015 16:16:30 GMT

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.

Re: Suppress Row in Pivot Chart

jzimolong — Thu, 15 Jan 2015 16:22:06 GMT

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

Re: Suppress Row in Pivot Chart

jzimolong — Thu, 15 Jan 2015 16:32:48 GMT

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

Re: Suppress Row in Pivot Chart

Clever_Anjos — Thu, 15 Jan 2015 16:48:30 GMT

I´ve just did it here