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

[hjm35055]

Hi,

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

Thank you!

[dineshm030]

Can you provide the sample QVW?

[tresesco]

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

[hjm35055]

yes, that is unchecked.

[tresesco]

Could you post a sample qvw?

[Vegar]

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

[jonathandienst]

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

  A

  B

  C

  D

  E

];

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.