topic Choosing Calender Period from From and To values in QlikView

Choosing Calender Period from From and To values

Tue, 15 Sep 2009 23:23:28 GMT

Hi,

I am trying to create a calender object with 'From' and 'To' Dates, instead of choosing a range.

How do I write script to integrate the time period to reflect in charts for example?

Can anyone help?

Choosing Calender Period from From and To values

stephencredmond — Tue, 15 Sep 2009 23:39:05 GMT

Hi,

You would need to add the selected dates into a Set in your calculation. Something like:

Sum({< Sales_Date = {">$(=DateFrom)<$(=DateTo)"}>} Sales)

Stephen

Choosing Calender Period from From and To values

Wed, 16 Sep 2009 21:10:57 GMT

Hi Stephen,

Thanks for your reply.

I have got only one date field available to use. How do I use to create DateFrom and DateTo to be able to filter from just one field value?

Appreciate your help.

Choosing Calender Period from From and To values

stephencredmond — Wed, 16 Sep 2009 21:29:55 GMT

Hi,

You could use 2 variables and use 2 Calendar Controls (Slider/Calendar).

Stephen

Choosing Calender Period from From and To values

Wed, 14 Oct 2009 17:07:35 GMT

Hi,

Finding it difficult to implement the idea as QV Script. I have got one date field called 'startdate' and need to apply TO & FROM date range using this field to filter table data or chart data dynamically. Can you please explain me with a sample script? DK