topic Re: Calender object - Creat variable Stardate in QlikView

Calender object - Creat variable Stardate

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

How can i have Always (if i every time start the application) a startdate with value 01-01-2016 and enddate the date of today in the underneath objects ?

Thanks in advanced!

Re: Calender object - Creat variable Stardate

sunny_talwar — Sun, 01 May 2016 19:17:17 GMT

Always means when you open the application? May be set on open trigger for those two dates when the application opens?

Re: Calender object - Creat variable Stardate

Sun, 01 May 2016 19:20:48 GMT

Hello Sunny,

Yes if i every time open the application, the startdate in the (red markered object) must Always shown as 01-01-2016 and the Enddate (red markered object) as the date of today for example 01-05-2016.

How can i fix this problem? any code?

Re: Calender object - Creat variable Stardate

trdandamudi — Sun, 01 May 2016 21:01:05 GMT

May be as attached:

Re: Calender object - Creat variable Stardate

sunny_talwar — Sun, 01 May 2016 21:13:07 GMT

Please find attached one way to do it with three triggers

1) Select in Field on Date

='>=' & Date(MakeDate(2016, 04, 01)) & '<=' & Date(MakeDate(2016, 04, 30))

2) Set Variable vStartDate

=Date(MakeDate(2016, 04, 01))

3) Set Variable vEndDate

=Date(MakeDate(2016, 04, 30))

Note: The set of trigger is very static and wouldn't change. Is there a more dynamic requirement to select last month? If that is the case, you can always use

1) ='>=' & Date(MonthStart(Max(Date), -1)) & '<=' & Date(MontEnd(Max(Date), -1))

2) Date(MonthStart(Max(Date), -1))

3) Date(MontEnd(Max(Date), -1))

So, in the end it all depends on what the exact requirement is

Best,

Sunny