show all values in x-axis - Qlik Community

Report Inappropriate Content · ‎2014-03-21

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.

alexandros17 · ‎2014-03-21

uncheck the box suppress zero values

MK_QSL · ‎2014-03-21

Go to Dimension Tab and Untick Suppress When Value is NULL

Report Inappropriate Content · ‎2014-03-21

Hi,

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

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

Report Inappropriate Content · ‎2014-03-21

@@

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 ?

Report Inappropriate Content · ‎2014-03-21

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

Report Inappropriate Content · ‎2014-03-21

I mean something like this (see attachement)

its_anandrjs · ‎2014-03-21

Hi,

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

Hope this helps

Thanks & Regards