topic Re: Date in the wrong order in App Development

Date in the wrong order

LiquidSword — Tue, 07 May 2024 22:42:28 GMT

After using AutoML to predict weather, I inputted the predicted results and actual temperature table into Qlik Sense. The two are connected by date.

Formula of date for predicted weater:

Date#('202303' & num([automl_row_index]+1,'00'), 'yyyymmdd'), 'yyyy/mm/dd')

Formula of date for actual weater:

Date( Date#( Year & Num(Month(Date#(Month, 'MMM')),'00') & num(Day,'00') ,'yyyymmddd'), 'yyyy/mm/dd')

Yet, the dates are sorted like this in the filter pane:

it is orderd by day instead of month and then day

Aasir — Wed, 08 May 2024 00:49:59 GMT

Just checking whether you have fixed the sort order in the sheet

Vegar — Wed, 08 May 2024 03:31:18 GMT

Your formating is wrong.

Please use upper case when formating dates (and lower case when formating time)

'm' = minutes

'M' = month

I also notice that you are using 'ddd' when the correct seems to be 'dd' (or 'DD')

Try this adjustment:

Date( Date#( Year & Num(Month(Date#(Month, 'MMM')),'00') & num(Day,'00') ,'YYYYMMDD'), 'YYYY/MM/DD')

You can also try this:

Date( MakeDate( Year , Month(Date#(Month, 'MMM')) , Day) , 'YYYY/MM/DD')