topic Show all values, including Nulls, on the x-axis in QlikView

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

Fri, 27 Jan 2012 10:12:00 GMT

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

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

jagan — Fri, 27 Jan 2012 14:21:24 GMT

Hi,

Can you attach the sample qlikview file.

Regards,

Jagan.

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

SunilChauhan — Fri, 27 Jan 2012 14:27:27 GMT

dimension remove all supress null value and check show all

and also in presentation tab uncheck supress zero value

hope this helps