topic Re: Dynamically Change Start date and End date in QlikView

Dynamically Change Start date and End date

Fri, 04 Apr 2014 19:42:21 GMT

Hello,

I have a requirement. I have two sets for Dates and a baseLine Type. If the user selected Base line type as 'Average 12 months' and a start date and End Date, then my Baseline Start Date and Baseline End Date should automatically change.

Below example:

Start Date : 2/1/2104

End Date: 3/1/2014

Baseline Type: Average 12 months

Baseline Start Date: start date minus 12 months

Baseline End Date: Start Date

Any help?

Thanks is adance

Re: Dynamically Change Start date and End date

whiteline — Sat, 05 Apr 2014 18:44:36 GMT

Hi.

If you want just subtract 12 months use AddMonths function.

Re: Dynamically Change Start date and End date

Sat, 05 Apr 2014 20:41:19 GMT

Padmaja,

for me it looks like you may need use variables to store Baseline Start and Baseline End dates.

You may set those variables using event triggers (menu Settings/Document Properties/Triggers).

There are many possible actions to add. Set Variable is in External group. When you choose it, you have to define your variable and define expression, which calculates value for your variable.

Let us know if you need more help.

regards

Darek

Re: Dynamically Change Start date and End date

Tue, 08 Apr 2014 16:55:47 GMT

Thanks Darek. Yes, I can create variables and use triggers...but the issue is I have more than one baseline type like 'Average of 3 months'...

whenever, the user selects a baseline type,Start Date and End Date the Baseline Start Date and Baseline End Date has to change (depending on 3 months or 12 months or previous week).

I have to use Baseline Start Date in different calculations in my charts.

Thanks

Re: Dynamically Change Start date and End date

Tue, 08 Apr 2014 19:07:42 GMT

Padmaja,

you may use all expressions dynamically, according to "baseline type" selected by user.

There may be expressions (or expression parts) used to calculate your KPI's, variables or searching values in other fields to trigger selection.

Do you think some example will help you?

regards

Darek

Re: Dynamically Change Start date and End date

Tue, 08 Apr 2014 20:50:39 GMT

Darek,

Yes, example would really help me.

My question is when i set trigger for a variable to calculate 12 or 3 months..which expression should i define and how do i tie it back to the baseline type selection by user.

Thanks

Re: Re: Dynamically Change Start date and End date

Tue, 08 Apr 2014 22:51:13 GMT

Let me know if you like it.

regards

Darek

Re: Dynamically Change Start date and End date

Tue, 08 Apr 2014 23:40:21 GMT

Thanks Darek. It worked. This is what I was looking for.

Re: Re: Dynamically Change Start date and End date

Fadi_Chammas — Fri, 01 Dec 2023 12:30:08 GMT

can I please have the qvf file for this?