Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
raju_salmon
Contributor II

Calender Object Issue

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.

1 Solution

Accepted Solutions
Highlighted

Re: Calender Object Issue

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

See the attached

View solution in original post

5 Replies
Highlighted
MVP
MVP

Re: Calender Object Issue

Add date() in your search string like:

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

Highlighted
raju_salmon
Contributor II

Re: Calender Object Issue

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?

Highlighted

Re: Calender Object Issue

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



Highlighted
raju_salmon
Contributor II

Re: Calender Object Issue

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.

Highlighted

Re: Calender Object Issue

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

See the attached

View solution in original post