Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date

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

Tags (2)
1 Reply
MVP
MVP

Re: Date

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)