Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Did you attach the wrong file. It doesn't resemble the screenshot you have at all...
Oops..My bad I just updated the file
Adjusting these settings might be what you need to do:
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??
I have no solution for that... maybe some others will pitch in on that.
try suppressing null as well. may work for you.
Thanks for your reply..that option didn't work
did you use it for both column ?
yeah..if we do that it is hiding all excluded values which doesn't solve my purpose