topic Date in QlikView

Date

Tue, 21 Jun 2011 23:12:25 GMT

Hi Everyone,

I have a question. My CalendarDate format is MM/DD/YYYY.

If the value in my variable(vStartDate) is in Julian Date format I can write in this way to compare

Sum({< CalendarDate = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} SalesAmount).

But what if its vice versa. The Calendar Date is in Julian Format and the variable is in MM/DD?YYYY format.

Please help,

Thanks,

Regards,

Bikash

Re: Date

johnw — Tue, 21 Jun 2011 23:29:54 GMT

By Julian date, I assume you mean the underlying QlikView numeric, the number of days since 12/30/1899? If the variable is still a date, just a formatted one, I believe this:

Sum({< CalendarDate = {">=$(=num(vStartDate))<=$(=num(vEndDate))"} >} SalesAmount)

If it's not even a date, and is just a text field, I believe this:

Sum({< CalendarDate = {">=$(=date#(vStartDate,'MM/DD/YYYY'))<=$(=date#(vEndDate,'MM/DD/YYYY'))"} >} SalesAmount)