Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Calendar select

!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.

1 Solution

Accepted Solutions

Re: Calendar select

Try this as Trigger:

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

View solution in original post

15 Replies

Re: Calendar select

Try this as Trigger:

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

View solution in original post

Not applicable

Re: Calendar select

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

Checking it now

Re: Calendar select

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)

Not applicable

Re: Calendar select

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

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

Not applicable

Re: Calendar select

Sorry.  Wrong attachment.  Please refer this one.

Re: Calendar select

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

Capture.PNG

Not applicable

Re: Calendar select

Sorry.  Here is the right one.