topic Selecting a date range in a chart in QlikView

Selecting a date range in a chart

richard_chilvers — Mon, 14 Nov 2011 14:39:37 GMT

I'm not new to QV and this seems like a simple requirement, but I'm struggling !

I would like to chart data based on Date1 within a range of dates AND Date2 within a range of different dates.

I thought using Slider objects would be elegant, but because the date range is long, and I need to pinpoint to the day, its rather cumbersome. Instead, I have used variables for the dates and built the selection into the expressions.

Surely there's a better way?

Plus .... I have Out of Memory problems, even though there is not alot of data, which may be for this reason?

Any ideas would be appreciated.

Re: Selecting a date range in a chart

tabletuner — Mon, 14 Nov 2011 14:52:31 GMT

The slider objects seem elegant to me as well.

I think you can use Date as dimension. And use the following expressions:

Range 1: sum(if(Date>=$(Date1Start) AND Date <= $(Date1End), Sales)

Range 2: sum(if(Date>=$(Date2Start) AND Date <= $(Date2End), Sales)

Does this cause performance problems as well?

Re: Selecting a date range in a chart

richard_chilvers — Mon, 14 Nov 2011 16:01:51 GMT

The slider solution fixes the memory problem. Do you know of any way I can label the start and end date of the slider ? This would perhaps make it easier for the user.

Using data range expessions within a Dimension causes the memory problem also.

Re: Selecting a date range in a chart

tabletuner — Tue, 15 Nov 2011 13:06:35 GMT

Maybe you can use a text box and fix the position at the start and end of the slider and dont forget about the layer settings...

Regards,

Tjeerd