How to not hide excluded values in pivot chart

[Anonymous]

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

[petter]

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

[Anonymous]

Oops..My bad I just updated the file

[petter]

Adjusting these settings might be what you need to do:

[Anonymous]

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??

[petter]

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

[pradosh_thakur]

try suppressing null as well. may work for you.

[Anonymous]

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

[pradosh_thakur]

did you use it for both column ?

[Anonymous]

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