Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

show all values in x-axis

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.

7 Replies

Re: show all values in x-axis

uncheck the box suppress zero values

Re: show all values in x-axis

Go to Dimension Tab and Untick Suppress  When Value is NULL


untitled.bmp

Not applicable

Re: show all values in x-axis

show all values in x-axis.pngHi,

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

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

Not applicable

Re: Re: show all values in x-axis

@@

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 ?

Not applicable

Re: show all values in x-axis

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

Not applicable

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

I mean something like this (see attachement)

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

Hi,

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

Hope this helps

Thanks & Regards

Community Browser