Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
federerman
New Contributor III

How to Show Null Data in a Chart (Power of Gray)

How to Show Null Data in a Chart (Power of Gray)

When making selections in a Qlik chart, the default behavior is to narrow down all dimensions in the chart to only those that have data.  In other words, as you continue to drill into a Qlik object, the dimensions often present fewer and fewer options.  Additionally, it might be the case that between data loads, your data changes and you no longer have any data for a given dimensional value.

How do I create a chart object that has static dimensions, so that even when selections are made, the chart axes present ALL the dimensional values/combinations?

See screenshots below for more detail.  If you are familiar with SAS, I’m looking for the PRELOADFMT option.  This seems like it should be an option to go along with Qlik’s “Power of Gray” campaign.

 

Before Selection

show null before.png

 

After Selection

show null after.png