Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
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.
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