Hi @SRI8273
You can use:
load
ID,
Date(Date#(Replace(Date,'-','@'),'DD@MM@YYYY'),'DD/MM/YYYY') AS Date,
SalesA
Inline [
ID,Date,SalesA
1 , 1@1@2022,100
2 , 2@1-2022, 100
3 , 3@1@2022, 200
4 , 4@1@2022, 100
5 , 5@1@2022, 100
]
;
Replace is used to ensure that all values have the same format and that values such as 2@1-2022 will be seen as 2@1@2022.
Date# is used to tell Qlik what format you will be providing the date in.
Date is used to tell Qlik how you want it to format the date.
I assume that your format was DD@MM@YYYY, but if it was actually MM@DD@YYYY then you can just replace the format in green above. Hope this helps.
