topic Re: Re: Re: hi all, in QlikView

hi all,

Fri, 20 Nov 2020 18:02:30 GMT

My Requirement is

I want to set date prompt in qlikview.

From Date and To Date.I can achieved it using calendar object.That's perfectly working.

However if i select my startDate (From Date), it has to automatically trigger the next 15 days or 20 days period in End date.

Is it possible , Please help on this

Thanks,

Thirumalai

Re: hi all,

rajat2392 — Thu, 08 May 2014 05:00:50 GMT

Hi Thirumalai,

You can set a trigger on OnSelect of your Start Date field. Go to Document Properties>>Triggers Tab>>Field Triggers>>OnSelect

In OnSelect add an action to select in another field that is your End Date field, set a expression for value as

$(=Start_Date_Field)+15

Re: hi all,

Thu, 08 May 2014 05:17:44 GMT

No it's not working.I dont know wat am missing.Actually End date is not a field.It's a variable as VEndDate.

Can u please help me!

Thanks in advance

Re: hi all,

tresB — Thu, 08 May 2014 05:20:12 GMT

Could you share your sample app?

Re: Re: hi all,

Thu, 08 May 2014 05:24:16 GMT

! !

Re: hi all,

rajat2392 — Thu, 08 May 2014 05:25:00 GMT

Hi Thiru,

If it is a variable then simply in trigger OnSelect, instead selecting value in field, set the End Date variable as same.

If it still doesn't work, then please share your sample app.

Regards

Rajat

Re: Re: Re: hi all,

tresB — Thu, 08 May 2014 05:30:50 GMT

Select in From Date and see the To Date gets automatically selected +15 days.

Re: Re: Re: hi all,

rajat2392 — Thu, 08 May 2014 05:40:11 GMT

Hi Thiru,

Please check the app, set the OnInput of VMinDate, not VMaxDate

Regards

Rajat

Re: Re: Re: hi all,

Thu, 08 May 2014 05:45:05 GMT

But yet in the report it is not reflecting:(

Re: Re: Re: hi all,

Thu, 08 May 2014 10:15:43 GMT

Can u please help me on this.according to the input of Dates,the report has to change.

Re: hi all,

rajat2392 — Thu, 08 May 2014 10:31:48 GMT

It is not possible as much as I know to have change on the report based on the selection.

According to me after selection only you should create a report. But I am not so sure, so can't say.