topic Re: Pivot Chart Calendar - How do I keep all months up regardless of selection? in QlikView

Pivot Chart Calendar - How do I keep all months up regardless of selection?

tschullo — Wed, 20 May 2015 14:11:54 GMT

I have a rather simple "Gantt chart" if you will, that tracks the progress of audits for the current year.

The table consists of a key to the audit table, audit status, audit phase and then month and week as dimensions and one expression that sets the gantt chart value for that phase (i.e. start date, end date, space char for in between)

My issue is that when a selection is made say of Completed audits,

I lose weeks that have no data for "Completed" audits.

I would like my "full calendar" look to stay up regardless of selections.

Any ideas?

Re: Pivot Chart Calendar - How do I keep all months up regardless of selection?

Anonymous — Wed, 20 May 2015 14:33:46 GMT

tried to select the option detached.

Re: Pivot Chart Calendar - How do I keep all months up regardless of selection?

Wed, 20 May 2015 14:34:11 GMT

Hi Tony,

There are several ways to do this including detaching the object or to use alternative state. My recommendation however would be to use set analysis and add a {1} into your expression to always show the full data set, independent of selections.

Good luck!

Re: Pivot Chart Calendar - How do I keep all months up regardless of selection?

JonnyPoole — Wed, 20 May 2015 14:37:46 GMT

You may also need to select 'show all values' on the dimensions tab for each dimension and perhaps uncheck 'suppress zeros' and 'suppress missing' on the presentation tab ... as you know by default qlik charts 'listen' to the selections but also by default they suppress zero or missing columns and rows. That should cover it.

Re: Pivot Chart Calendar - How do I keep all months up regardless of selection?

tschullo — Wed, 20 May 2015 15:46:13 GMT

Thanks Jonathan, I had the 'show all values', unchecking 'suppress zeroes/missing' did the trick.

I really appreciate your quick response.

This works better than detach because I did want to be able to select subsets of the data, I just didn't want to lose parts of my calendar in the process.

Thanks again!