Dynamic Grouping of Dates triggered by User Input through Calendar Object

Anonymous — Wed, 02 Jan 2013 21:49:17 GMT

Hi all im hoping if anyone can help,

I have the following expression that gives me the field of 'T_Numbers' where my Sched_Date's fall into.

'T'& ((CEIL(CEIL((WEEKSTART(TODAY())-1) - SchedDate)/7))) AS T_Number

At the moment the expression takes todays date then minus the one which gives the date starting from a Sunday.

What I require now is for the date not to start from a Sunday anymore but it now needs to be dynamic where the date is entered through a Calendar object by a user this then takes the date and the T_Numbers should grouped accordingly.

E.g if the user enters 01/01/2013 then:

T0 - should contain 01/01/2013

02/01/2013

03/01/2013

04/01/2013

05/01/2013

06/01/2013

07/01/2013

T-1 - all the dates listed one week from the date entered
etc
etc

Is there a way of storing the date entered by the user from the calendar object into a variable and then using that variable to work out the T_Number field

Hope it this makes sense any help would be much appreciated

QVW file is attached.

topic Dynamic Grouping of Dates triggered by User Input through Calendar Object in QlikView

Dynamic Grouping of Dates triggered by User Input through Calendar Object