Fixing the X axis of a line chart

[j_fulcher]

Hi All,

I have a line chart with date along the x axis. Depending on user selection there may not always be data to display for every date but I would like it to display the full range of dates anyway. By default it seems that qlik will limit the range in the X axis to only values in which there is data to display. Is there a way to 'fix' the x axis to display the full range of values at all times?

Thanks in advance for any help 

[anseglko]

Try going to "Appearance" -> "X-axis" and disable the "Continuous: Auto"-setting (after that make sure the "Use continuous scale" is checked).

[j_fulcher]

Thanks for the suggestion, unfortunately this doesn't do the trick as the axis still changes when selections are made. Is there anything I can do in the expression box of the dimension to force it to show all values of the field, perhaps using an 'ALL' somewhere? the problem is I have no aggregation to put it in as my dimension is defined as:

=[Date]

[ChiragPradhan · Accepted solution]

Try this -

 Sum(Value) + 0 * Sum({1} Value)

Regards,

Chirag 

[j_fulcher]

Thanks Chirag, that has done exactly what I wanted!