Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Qlikview Developer

A customer has a set of date values in different formats. Some dates are in Julian date format; some dates are text strings. How can a developer ensure the data is loaded in a consistent format? <a href="https://www.credosystemz.com/training-in-chennai/best-amazon-web-services-training-in-chennai/">awstraininginvelachery</a>

Labels (4)
1 Reply
Highlighted
Valued Contributor II

Re: Qlikview Developer

the julian date can be processed by: .

Date(MakeDate(1900 +(left(text(Julian_Date),1)* 100) +
mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) )

 

more information in this link : Julian calendar

Regards,
Taoufiq ZARRA