Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nadeemsmarty
Valued Contributor

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
greeshma_k
Contributor III

Re: help !! needed in Arbitrary date range selection

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

11 Replies
renjithpl
Valued Contributor

Re: help !! needed in Arbitrary date range selection

Please give more information so that people can answer.

nadeemsmarty
Valued Contributor

Re: help !! needed in Arbitrary date range selection

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

Partner
Partner

Re: help !! needed in Arbitrary date range selection

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'

nadeemsmarty
Valued Contributor

Re: help !! needed in Arbitrary date range selection

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

Partner
Partner

Re: help !! needed in Arbitrary date range selection

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

greeshma_k
Contributor III

Re: help !! needed in Arbitrary date range selection

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

nadeemsmarty
Valued Contributor

Re: help !! needed in Arbitrary date range selection

hi,

I have already tried triggers please check my qvw application

Regards,

Nadeem

nadeemsmarty
Valued Contributor

Re: help !! needed in Arbitrary date range selection

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

greeshma_k
Contributor III

Re: help !! needed in Arbitrary date range selection

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