Sorting data (Date) in permanent filter

[surtex]

Hey Member,

I have added an permanent filter on my worksheet in Qlik Sense:

Anybody knows a opportunity to sort this data like: 01.2022, 02.2022, 03.2022,... without adding a seperate filter on my worksheet. I think it must sorting in the data editor!?

Thanks for helping 🙂 

[salonicdk28]

Hi,

You need to first evaluates an expression as a date like below and then after loading  your data then you will be able to see the sorting automatically in filter pane

Date#(Date,'MM.YYYY') as NewDate;

Thanks,

Saloni