Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Sort Filter by combined value

Hello good day
I would like to sort desc the filter by year, but it doesn't sort:

Q1 2020

Q2 2020

Q3 2020

Q4 2020

Q1 2019

QtrCuota.PNG

Regards.

 

Labels (1)
3 Replies
Fernando_Fabregas

Hi Ronald. 

In order options, choose "By expression", Descending, and put this formula: 

Right(YourField,4) & Left(YourField,2)

Regards !

Ronald
Contributor III
Contributor III
Author

Sorry don´t work

Fernando_Fabregas

You are right, I don't know why sorting strings not always works fine...

Try this:

    Right(YourField,4) & Mid(YourField,2,1)

In this way you'll sort numbers and it works well for me.