topic Re: help !! needed in Arbitrary date range selection in QlikView

help !! needed in Arbitrary date range selection

fashid — Fri, 13 Feb 2015 07:32:51 GMT

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

Re: help !! needed in Arbitrary date range selection

renjithpl — Fri, 13 Feb 2015 08:49:58 GMT

Please give more information so that people can answer.

Re: help !! needed in Arbitrary date range selection

fashid — Fri, 13 Feb 2015 08:54:16 GMT

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

Re: help !! needed in Arbitrary date range selection

Anonymous — Fri, 13 Feb 2015 09:03:41 GMT

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'

Re: help !! needed in Arbitrary date range selection

fashid — Fri, 13 Feb 2015 09:26:53 GMT

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

Re: help !! needed in Arbitrary date range selection

Anonymous — Fri, 13 Feb 2015 09:37:43 GMT

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

Re: help !! needed in Arbitrary date range selection

Anonymous — Fri, 13 Feb 2015 10:16:40 GMT

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

Re: help !! needed in Arbitrary date range selection

fashid — Fri, 13 Feb 2015 10:24:51 GMT

hi,

I have already tried triggers please check my qvw application

Regards,

Nadeem

Re: help !! needed in Arbitrary date range selection

fashid — Fri, 13 Feb 2015 10:40:09 GMT

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

Re: help !! needed in Arbitrary date range selection

Anonymous — Fri, 13 Feb 2015 10:49:58 GMT

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

Re: help !! needed in Arbitrary date range selection

fashid — Fri, 13 Feb 2015 11:12:06 GMT

Greeshma Thanks a million

Re: help !! needed in Arbitrary date range selection

fashid — Fri, 13 Feb 2015 11:15:36 GMT

One small question why do we need the & sign