topic Re: Calender Object Issue in QlikView

Calender Object Issue

raju_salmon — Mon, 07 Dec 2015 06:09:15 GMT

I have created calendar object with the below process however i cannot able to select the dates in DATE field.

Created below variable:

vLowerLimit = Num(Min(DATE))

vUpperLimit = Num(Today())

vStartDate = ''

vEndDate = ''

Created Calender Object with variables vStartDate and vEndDate

MIN VALUE =vLowerLimit

MAXVALUE =vUpperLimit

Added triggers at document level for variables vStartDate and vEndDate for

Selectinfiled - Field (DATE) Search String ( ='>='&vStartDate&'<='&vEndDate)

Please find the sample attachment for reference. I cannot able to select particulate dates in Date field.

Re: Calender Object Issue

tresB — Mon, 07 Dec 2015 06:17:38 GMT

Add date() in your search string like:

='>='&Date(vStartDate)&'<='&Date(vEndDate)

Re: Calender Object Issue

raju_salmon — Mon, 07 Dec 2015 06:22:49 GMT

Thanks tresesco.

This is working, i need one more step to do.

When i select date on calendar object, the y are not unselected when i click clearall button. Do i need to add any action for clear all button?

Re: Calender Object Issue

Kushal_Chawda — Mon, 07 Dec 2015 06:35:59 GMT

Remove Variable event trigger & Create the button (here you can provide the trigger to select the DATE) to apply filter when dates from calender object gets selected i.e on clicking button Date range will be selected in DATE field

Re: Calender Object Issue

raju_salmon — Mon, 07 Dec 2015 06:42:19 GMT

Hi,

Thanks for response.

Since i need to create calendar object, i have made it based on tresesco response.

However i need to clear the calendar date selections when i click on clear all button. Can i do that with any way?

I mean i need to clear the value in StartDate and EndDate variable by clicking button.

Re: Calender Object Issue

Kushal_Chawda — Mon, 07 Dec 2015 06:48:50 GMT

You can create the button & Set the variable values to null on click.

See the attached