topic Re: Reset Calendar Object values in QlikView

Reset Calendar Object values

Wed, 07 Oct 2015 09:35:48 GMT

Hi All,

I have created two Calendar object with "OrderCreateDate" field, so user can able to select a date range then he/she can see between two dates how may orders are there.

I created Variable, vStartDate and vEndDate and I used triggers, Variable Event Trigger".

Now it is working. user can able to select the date range.

But my issue is when I clear the selection date range should be clear( I used "Action" -- > "Clear All") but it is not clear still it is showing previous selection.

Please help me

hanks.

Re: Reset Calendar Object values

parthakk — Wed, 07 Oct 2015 10:32:08 GMT

Hi,

Clear button shall not clear the date selected using calendar object as you used variable. The alternative option is you can reset the variable to min and max date of "OrderCreateDate".

on clear button add two more action as set variable

Variable: vStartDate

Value: min(OrderCreateDate)

Variable:vEndDate

Value: max(OrderCreateDate)

Thanks,

Partha Kulkarni

Re: Reset Calendar Object values

SreeniJD — Wed, 07 Oct 2015 10:42:48 GMT

Create a button object and in the properties select the variable and set null value. This will sure work!

Happy to Help

Sreeni

Re: Reset Calendar Object values

SreeniJD — Wed, 07 Oct 2015 11:21:42 GMT

I think this is a duplicate post. Already there was answer provided in your previous post.. Let me know if you are still facing the issue

Re: Reset Calendar Object values

Tue, 13 Oct 2015 16:26:52 GMT

Hi,

Please find the Attached, i want to reset the Calendar objects.

Thanks

Re: Reset Calendar Object values

SreeniJD — Tue, 13 Oct 2015 16:29:45 GMT

Right now, I dont have licensed version of QV to open your example..

However as I suggested, please create a button object and have the logic in the button to clear the calendar objects value

Sreeni