Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
richard_chilvers
Valued Contributor

Selecting a date range in a chart

Hi

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.

3 Replies
tabletuner
Contributor III

Re: Selecting a date range in a chart

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?

richard_chilvers
Valued Contributor

Re: Selecting a date range in a chart

Hi

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.

tabletuner
Contributor III

Re: Selecting a date range in a chart

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