topic Re: How to not hide excluded values in pivot chart in QlikView

How to not hide excluded values in pivot chart

Anonymous — Thu, 04 Jan 2018 16:51:56 GMT

Hi Folks,

I attached a sample qlik file in this post.I want the excluded columns to be displayed on pivot chart even after making a selection on specific dimension but all excluded rows should display '-' or o on the chart

Updated the file ...Message was edited by: Krishna Chaitanya Koyyalamudi

Re: How to not hide excluded values in pivot chart

petter — Thu, 04 Jan 2018 17:05:33 GMT

Did you attach the wrong file. It doesn't resemble the screenshot you have at all...

Re: How to not hide excluded values in pivot chart

Anonymous — Thu, 04 Jan 2018 17:09:59 GMT

Oops..My bad I just updated the file

Re: How to not hide excluded values in pivot chart

petter — Thu, 04 Jan 2018 19:02:22 GMT

Adjusting these settings might be what you need to do:

Re: How to not hide excluded values in pivot chart

Anonymous — Thu, 04 Jan 2018 19:08:31 GMT

This works fine but the only problem I see is ,It displays one empty cell for release-month dimension and one empty cell for job dimension at the end.Any workaround to hide that empty cells??

Re: How to not hide excluded values in pivot chart

petter — Thu, 04 Jan 2018 19:26:13 GMT

I have no solution for that... maybe some others will pitch in on that.

Re: How to not hide excluded values in pivot chart

pradosh_thakur — Thu, 04 Jan 2018 21:05:32 GMT

try suppressing null as well. may work for you.

Re: How to not hide excluded values in pivot chart

Anonymous — Thu, 04 Jan 2018 21:36:59 GMT

Thanks for your reply..that option didn't work

Re: How to not hide excluded values in pivot chart

pradosh_thakur — Thu, 04 Jan 2018 21:49:51 GMT

did you use it for both column ?

Re: How to not hide excluded values in pivot chart

Anonymous — Thu, 04 Jan 2018 21:58:36 GMT

yeah..if we do that it is hiding all excluded values which doesn't solve my purpose

Re: How to not hide excluded values in pivot chart

neha_shirsath — Fri, 05 Jan 2018 06:04:27 GMT

Find the attached file.

Hope this will help you.

Re: How to not hide excluded values in pivot chart

Anonymous — Fri, 05 Jan 2018 15:57:45 GMT

I don't want the excluded jobs to disappear when I pick a release month

Re: How to not hide excluded values in pivot chart

petter — Sun, 07 Jan 2018 10:00:28 GMT

You can make them look better but not remove them by doing this:

Add an expression (in the Definition property) of the Text Color of the measure expression:

And removing dashes as Null Symbol and Missing Symbol:

Re: How to not hide excluded values in pivot chart

MarcoWedel — Sun, 07 Jan 2018 23:23:59 GMT

Hi,

maybe one solution could be:

hope this helps

regards

Marco

Re: How to not hide excluded values in pivot chart

Anonymous — Mon, 08 Jan 2018 16:24:04 GMT

Awesome it works ..I am trying to tweak that solution little bit .Is there anyway we can just hide the excluded release-months ??