Calender with the help of varaibles help ?????

[amit_saini]

Hi Folks,

I'm having two variables named as vStartDate and vEndDate ,these two variables I'm calling in many expressions inside a pivot table , so that whenever a user set some value against Period From and Period To , pivot table will change according to the date range selection.

Period From: vStartDate

Period To : vEndDate

Mentioned below is an expression example named Available time where I'm using both these two variables:

Available Time: =sum(aggr(

sum( {<PRI_CALENDAR_END={">=$(vStartDate)"}, PRI_CALENDAR_START={"<=$(vEndDate)"}>}

Interval( if( PRI_CALENDAR_END > vEndDate, vEndDate, PRI_CALENDAR_END ) - if( PRI_CALENDAR_START < vStartDate, vStartDate, PRI_CALENDAR_START ) )

), SLINIENR, SMASCHGRPNR, SMASCHNR, SMASCHTYPBEZ) )

Like Available time there are some 9-10 calculated pivot table expression where I'm using both these two variables.

Requirement:   I want to create a simple calender with the help of these two variables (vStartDate & vEndDate) , something like below:

Kindly help me how to reach to this kind of solution.

Thanks,

AS

[amit_saini]

Folks please help me on this.

Thanks,

AS

[SunilChauhan]

http://community.qlik.com/message/416415#416415

http://community.qlik.com/thread/58223

see above hope this helps

[hic]

I would not use variables for that type of user interactions. Variables are not user-friendly.

Instead, I would create a calendar in the script, e.g.

     Let vStartDate = 41000;

     Let vEndDate = 42000;

     Calendar:

     Load *,

            Month(Date) as Month,

            Year(Date) as Year;

     Load Date(RecNo()+$(vStartDate)-1) as Date

            Autogenerate vEndDate - vStartDate + 1;

and then let the user make the selection in your calendar fields. You can then use Max(Date) and Min(Date) in your expressions to dynamically find the selected range.

HIC

[amit_saini]

Hi Henric,

Thanks for your suggestion , I strongly agree with you but I have to work further on this application created by someone else. The only option available  for me to play around with these two  variables in order to create user friendly calender as mentioned in my above post.

Thanks,

AS

[amit_saini]

Henric,

Also here instead of one single Date filed as you mentioned in your solution I'm having around 9-10 Date fields , the question is how to link all of them together to vStartDate and vEndDate variable.

Please suggest any solution on this.

Thanks,

AS

[tresesco]

May be like attached?

[amit_saini]

Tresesco,

This Calender I have already created by using variables , main concern is how to create Year, Month ,Day kind of options from these variables . See below

In general the way we are creating is Year(Date) as Year and same for Month and Day, but here how play with varibles for such solution.

[tresesco]

Amit,

It's bit complex in the front-end. But possible, see my attachment. You might have to work on it further.

[amit_saini]

Tresesco,

Here in your mentioned example selection depends upon variables, I want it other way user should be able to select any year , month and day here in current scenario depending upon variables value we are getting Year and Month.

I'm sorry I'm not sure whether this is possible or not through Front end . But Thanks for your suggestion.

Thanks,
AS