Create Dimension Date with julien Date

[SoukainaQLik]

Hello,

Im very new to qliksense and i need your help.

I have a fact table that contain a Julian date field, the format is like this: 121298 wich is 25/10/2021;

I Need te create table in qlisense that contains dates from 2009 Until now with theses fields:

- julian date

- Date foat DD/MM/YYYY

- Year

- Month

-DAY

please tell me how can i create this table in qliksense??

thank you so much.

[Lisa_P]

See this article:

https://community.qlik.com/t5/QlikView-Documents/Julian-calendar/ta-p/1664195