Show all values, including Nulls, on the x-axis

[#1]

Hi All,

I have some data of survey responses where the options are:

Strongly Agree

Agree

Neither

Disagree

Strongly Disagree

If I display a question where all responders have only chosen Agree (for example), then the x-axis only shows Agree due to the nature of the filtering within the data.  I want the x-axis to display all possible values (i.e. all 5), but only have a bar for Agree.

The 'show all values' checkbox doesn't achieve this, nor does removing the 'suppress nulls' checkbox etc...

Think this may be similar to trying to display continuous dates... a real pain.

Any help is greatly appreciated!

Thanks

G

[jagan]

Hi,

Can you attach the sample qlikview file.

Regards,

Jagan.

[SunilChauhan]

dimension remove all supress null value and check show all

and also in presentation tab uncheck supress zero value

hope this helps