topic Re: Calendar select in QlikView

Calendar select

Wed, 27 Jan 2016 18:37:51 GMT

!Hi,

I am trying to choose a date in the calendar object using a variable and document trigger. Not sure what I am missing in the attached qlikview document but the value selected in the calendar is not getting reflected in the data. Please assist.

Thanks,

Sudha.

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 18:41:37 GMT

Try this as Trigger:

= '>=' & DayStart(vTestDt) & '<=' & DayEnd(vTestDt)

Re: Calendar select

Wed, 27 Jan 2016 18:57:46 GMT

Thanks Sunny. But I want it to work just with date too without the timestamp portion. The one you gave is working fine with timestamp. Can you please help me just for the date part without timestamp. Thanks!

The attached qlikview has the same example without timestamp.

Thanks,

Sudha.!

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:00:41 GMT

Checking it now

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:03:44 GMT

If you want to just use a date, you will have to create a field in your script which only has date (and doesn't include the time component). Something like this:

Date(Floor(TEST_EXPIRATION_DT)) as DATE_TEST

and now you can use select in field on DATE_TEST -> = '=' & DATE(vTestDt) or even this should work: =Date(vTestDt)

Re: Calendar select

Wed, 27 Jan 2016 19:15:58 GMT

I am doing the same but it does not work. Please have a look at the qlikview document that I had attached previously.

Thanks,

Sudha.

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:17:41 GMT

What is your date field in the attached qvw? TEST_EXPIRATION_DT is timestamp, I am looking for a field which is just date and doesn't include time

Re: Calendar select

Wed, 27 Jan 2016 19:20:10 GMT

Sorry. Wrong attachment. Please refer this one.

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:20:58 GMT

All your date fields are TimeStamp Fields and there is no way (that I know of) to trigger just date on those timestamp fields:

Re: Calendar select

Wed, 27 Jan 2016 19:21:42 GMT

Sorry. Here is the right one.

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:24:41 GMT

What's the difference between this file and the previous one you attached?

Re: Calendar select

Wed, 27 Jan 2016 19:27:26 GMT

Attaching it again. Hope you see the date and not the timestamp now.

Thanks,

Sudha.

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:30:39 GMT

I do

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:33:01 GMT

This seems to be working:

=Date(vTestDt,'MM/DD/YYYY')

Re: Calendar select

Wed, 27 Jan 2016 19:36:02 GMT

Thank you so much Sunny! It works now.

Re: Calendar select

sunny_talwar — Wed, 27 Jan 2016 19:36:37 GMT

Awesome