topic Showing all values/dates on x axis in chart in QlikView

Showing all values/dates on x axis in chart

Mon, 22 Feb 2010 13:04:44 GMT

Hi,

how can I force QlikView to show all date values regardless of the current selection?

I included a dummy expression (=1) which is invisible to show all possible dates on the axis. When I now select a certain a product category where there is no sales yet associated (eg. future dates) it limits the values shown on the axis to dates where there is associated sales data.

The dates are kept in a seperate calendar table, show all values does not do the trick here.

I was thinking about doing something with set analysis, but I'm not sure how to use this in the dimesion.

This is the chart w/o any selection made (the purple line is calculated based on the calendar table and another table)

When making a selection it limits the shown dates to the ones that have sales data associated.

Showing all values/dates on x axis in chart

kji — Mon, 22 Feb 2010 13:52:56 GMT

I think that if you select "Show All Values" for your dimension on the Dimensions tab, and on the presentation tab make sure "Suppress Zero-Values" is unchecked, you will get what you want.

Showing all values/dates on x axis in chart

Mon, 22 Feb 2010 14:12:20 GMT

Hi Lukas,

try Set Analysis: SUM ({< time dimension = >} Value)

No filter on that dimension will have an effect.

Hope this helps,

Matthias

Showing all values/dates on x axis in chart

Mon, 22 Feb 2010 14:49:48 GMT

Hi Matthias,

I KNEW there must be an easy solution, but I just couldn't get my head around it (maybe because it's Monday...) 😉

All I added was {1} to my expression...

Thanks!

Lukas