topic How do I get values with no data to display on the axis? in QlikView

How do I get values with no data to display on the axis?

hjm35055 — Wed, 30 Nov 2016 04:42:52 GMT

Hi,

I have the following chart. How do I get the numbers to display where there are no values?

Thank you!

Re: How do I get values with no data to display on the axis?

dineshm030 — Wed, 30 Nov 2016 04:45:13 GMT

Can you provide the sample QVW?

Re: How do I get values with no data to display on the axis?

tresB — Wed, 30 Nov 2016 04:47:34 GMT

Have you tried unchecking 'Suppress Zero-Values' in the presentation tab of the chart?

Re: How do I get values with no data to display on the axis?

hjm35055 — Wed, 30 Nov 2016 04:52:39 GMT

yes, that is unchecked.

Re: How do I get values with no data to display on the axis?

tresB — Wed, 30 Nov 2016 05:03:44 GMT

Could you post a sample qvw?

Re: How do I get values with no data to display on the axis?

Vegar — Wed, 30 Nov 2016 05:06:15 GMT

On the dimension property of your chart you could check the "Show all values" checkbox .

Re: How do I get values with no data to display on the axis?

jonathandienst — Wed, 30 Nov 2016 06:22:49 GMT

If the values do not exist, or are missing (due to incomplete associations in your model), then there is nothing to display. No fiddling with the graph options will help.For example, you will not get C or E in a chart of Sum(Val) from:

LOAD * INLINE

[

Cat, Val

A, 20

B, 5

D, 3

];

But if you combine that with a dimension load that includes the missing values:

LOAD * INLINE

[

Cat

];

LOAD * INLINE

[

Cat, Val

A, 20

B, 5

D, 3

];

Now you can display a table or chart of Sum(Val) that includes the formerly missing values. Just uncheck the Suppress Zero Values option.