Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

amit_saini
Honored Contributor III

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

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

11 Replies
amit_saini
Honored Contributor III

Re: Calender with the help of varaibles help ?????

Folks please help me on this.

Thanks,

AS

Highlighted
chauhans85
Esteemed Contributor

Re: Calender with the help of varaibles help ?????

Employee
Employee

Re: Calender with the help of varaibles help ?????

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
Honored Contributor III

Re: Calender with the help of varaibles help ?????

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
Honored Contributor III

Re: Calender with the help of varaibles help ?????

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

MVP
MVP

Re: Re: Calender with the help of varaibles help ?????

May be like attached?

amit_saini
Honored Contributor III

Re: Calender with the help of varaibles help ?????

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.

MVP
MVP

Re: Re: Calender with the help of varaibles help ?????

Amit,

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

amit_saini
Honored Contributor III

Re: Calender with the help of varaibles help ?????

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

Community Browser