Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kkoyyalamudi
Contributor

How to not hide excluded values in pivot chart

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

1.PNG

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

14 Replies
MVP
MVP

Re: How to not hide excluded values in pivot chart

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

kkoyyalamudi
Contributor

Re: How to not hide excluded values in pivot chart

Oops..My bad I just updated the file

MVP
MVP

Re: How to not hide excluded values in pivot chart

Adjusting these settings might be what you need to do:

2018_01_04_19_55_17_QlikView_x64_C_Users_Petter_Downloads_Test.qvw_.png

2018_01_04_19_57_06_QlikView_x64_C_Users_Petter_Downloads_Test.qvw_.png

kkoyyalamudi
Contributor

Re: How to not hide excluded values in pivot chart

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

MVP
MVP

Re: How to not hide excluded values in pivot chart

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

pradosh_thakur
Honored Contributor II

Re: How to not hide excluded values in pivot chart

try suppressing null as well. may work for you.

Capture.PNG

Learning never stops.
kkoyyalamudi
Contributor

Re: How to not hide excluded values in pivot chart

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

pradosh_thakur
Honored Contributor II

Re: How to not hide excluded values in pivot chart

did you use it for both column ?

Learning never stops.
kkoyyalamudi
Contributor

Re: How to not hide excluded values in pivot chart

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