Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
neha_shirsath
Specialist
Specialist

Find the attached file.

Hope this will help you.

Anonymous
Not applicable
Author

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

petter
Partner - Champion III
Partner - Champion III

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:

2018-01-07 10_57_47-Chart Properties [sum(Result)].png

And removing dashes as Null Symbol and Missing Symbol:

2018-01-07 10_58_17-Chart Properties [sum(Result)].png

MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Thread_286780_Pic2.JPG

QlikCommunity_Thread_286780_Pic1.JPG

QlikCommunity_Thread_286780_Pic4.JPG

QlikCommunity_Thread_286780_Pic3.JPG

QlikCommunity_Thread_286780_Pic5.JPG

hope this helps

regards

Marco

Anonymous
Not applicable
Author

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