topic Continuous Dates except weekends? in QlikView

Continuous Dates except weekends?

Fri, 25 Oct 2013 13:17:48 GMT

Hello,

I have some data where some days are missing, so I want to show it as with "Continuous X-axis". The problem is that it then shows ALL dates, even weekends (Saturday, Sunday), which I don't want. There are never any data on weekends, so the charts looks very strange.

Is there any way to come around this?

I'd rather not generate null-data on missing dates.

Re: Continuous Dates except weekends?

Jason_Michaelides — Fri, 25 Oct 2013 13:23:55 GMT

You could add a field to the data table during the load that determines if the date is a weekday or not. Look at using NetworkDays()

Hope this helps,

Jason

Re: Continuous Dates except weekends?

Fri, 25 Oct 2013 13:28:36 GMT

Well, I don’t know if that matters? The weekends are not even IN my Date dimension to start with. It’s just something that the Chart generates when showing the Date field as Continuous.

Mathias Olausson

NASDAQ OMX

Direct: +46 8 405 6912

Re: Continuous Dates except weekends?

swuehl — Fri, 25 Oct 2013 13:52:27 GMT

A continuous x-axis is continuous between min and max of the scale, so no weekend gaps possible.

I think you need to consider discrete dimension values, probably by generating missing values in the script.

Re: Continuous Dates except weekends?

Gysbert_Wassenaar — Fri, 25 Oct 2013 15:50:06 GMT

You could try a calculated dimension with a continuous axis. Something like aggr(rank(-MyDate),MyDate)