topic Re: show all values in x-axis in QlikView

show all values in x-axis

Fri, 21 Mar 2014 11:37:22 GMT

Hi,

Is it possible to always show all values in x-axis, even if data are missing? See attachment. 2013 P02 data are missing, but I want to show 2013 P02 in the chart.

Thank you for your answer.

Re: show all values in x-axis

alexandros17 — Fri, 21 Mar 2014 11:40:40 GMT

uncheck the box suppress zero values

Re: show all values in x-axis

MK_QSL — Fri, 21 Mar 2014 11:48:05 GMT

Go to Dimension Tab and Untick Suppress When Value is NULL

Re: show all values in x-axis

Fri, 21 Mar 2014 11:48:47 GMT

Hi,

Add one more expression, write =1 in new expression.

and then uncheck the Line option under the Display Options for this expression only

Re: Re: show all values in x-axis

Fri, 21 Mar 2014 12:13:53 GMT

Yes it works, but what if I want to show all periods in x-axis and I have data only from 2013 P05 (see attachment). I want to show also 2013 P04, 2013 P05 etc. Is it possible ?

Re: show all values in x-axis

Fri, 21 Mar 2014 12:36:10 GMT

My idea is to do something like this (see attachment). Is it possible?

Re: Re: Re: show all values in x-axis

Fri, 21 Mar 2014 12:50:32 GMT

I mean something like this (see attachement)

Re: Re: Re: show all values in x-axis

its_anandrjs — Fri, 21 Mar 2014 13:14:56 GMT

Hi,

Change background color as white for above values of the dimension will be good idea might be.

Hope this helps

Thanks & Regards