Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fashid
Specialist
Specialist

help !! needed in Arbitrary date range selection

Hi,

I have been struggling to get my date range selections working but i dont understand where i am failing .

If any body could help me with my sample app or a hint where im doing it wrong .

I would grreatly appreciate it.

Thanks and Regards,

Nadeem

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

PFA. Let me know if this is what you are looking for. I made changes in the document triggers for the two variables.

Regards,

Greeshma

View solution in original post

11 Replies
renjithpl
Specialist
Specialist

Please give more information so that people can answer.

fashid
Specialist
Specialist
Author

Hi,

In My application i need a from date and to date for the users to select .

I have tried to create the same using this thread Selecting Arbitrary Date Ranges

But i am unable to get it to work .

I have attached the application that i am working on

Regards,

Nadeem

Anonymous
Not applicable

as far as I noticed is that your Standard date Format is M/D/YYYY

Your listbox work as Long as there is a  valid date Format that way (10 of february will be displayed corect while

23rd of feburary will not be correct)

so try to Change the date Format in Tab main to SET Dateformat='DD/MM/YYYY'

fashid
Specialist
Specialist
Author

Hi Rudolf,

Thanks for replying

Tried that but still does not work

If i select a group of dates in the CalendarDate field then the slider objects react and show correct range of dates

but not vice versa.

Regards,

Nadeem

Anonymous
Not applicable

what do you mean with vice versa?

you select a date in the calendar objects on the left and you want the listbox or the table to adjust?

that is not possible as you are using variables in the calendar objects

you might try variable Triggers for that, but i am not sure if that works

If you use ONE calendar and you define the field CalendarDate instead of variable and set Multiple Values

you can select a date range in the calendar object and changes the date in the listbox according to the Dates.

But that is not convenient for larger date ranges

Please try what fits best for you

Anonymous
Not applicable

Hi,

PFA. Let me know if this is what you are looking for. I made changes in the document triggers for the two variables.

Regards,

Greeshma

fashid
Specialist
Specialist
Author

hi,

I have already tried triggers please check my qvw application

Regards,

Nadeem

fashid
Specialist
Specialist
Author

Hi Greeshma,

Thanks a lot for helping me out.

I was struglling with this for quite some time now .

This is exactly what i was looking for .

I think it Was it not recognising the date in the variables inside the triggers .

Could you please explain what the issue was ????

Regards,

Nadeem

Anonymous
Not applicable

Hi Nadeem,

The issue was with the triggers on vstartdate and venddate.

Your trigger action was   '>= $(vstartdate) <= $(venddate)'

I changed this to '>=' & Date(vstartdate,'DD/MM/YYYY') & '<=' & Date(venddate,'DD/MM/YYYY')

Only >= and <= had to be given inside quotes. Also date format had to be changed to match the format as per CalendarDate.

Regards,

Greeshma