topic Re: Re: Default Date in Calendar Object in QlikView

Default Date in Calendar Object

Thu, 05 Dec 2013 13:16:36 GMT

HI,

I have a Calender object. I need to show the default date the the last day of the month. Based on the value in the calendar object, I need to derive date difference for two fields in input sheet.

Attached is the one what I have done so far.

I have created a variable as vDate = Date(month(now())). Assigned this variable to the calender object max value.

But the date initial date difference is some DateNum field with decimal places. (See the Date Diff1 and Date Diff2).

When I change the date in the calendar object, then values changes in the date diff fields. This time it gives actual days of date difference with decimal places.

My requirement is to get only the days in difference not with the decimal places. And also the initial date difference which shows a DateNum field, it should also show the actual days in difference.

Thank you.

Re: Default Date in Calendar Object

angelaecheverri — Thu, 05 Dec 2013 13:30:13 GMT

Try use Ceil in this way you dont have decimals....

Ceil(Date($(vDate)))-Ceil(Date(BATCH_DATE))

Re: Default Date in Calendar Object

Thu, 05 Dec 2013 13:36:06 GMT

Date - Date, shouldn't it give an integer?

I can use, Ceil / Floor, But if I delete the decimal value in the variable once by going through variable setting, then I dont get the decimal for any other date selection.

Re: Re: Default Date in Calendar Object

MayilVahanan — Thu, 05 Dec 2013 15:42:53 GMT

PFA

Are you need this?

Re: Re: Default Date in Calendar Object

angelaecheverri — Thu, 05 Dec 2013 23:58:07 GMT

What is PFA?

Re: Re: Default Date in Calendar Object

MayilVahanan — Fri, 06 Dec 2013 05:00:09 GMT

PFA -> Please Find Attachment