Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Woojtek_96
Contributor III
Contributor III

Sort columns by sort in another column

Hi all,

I want to sort values in Dest, Food and Price in way how's Dep_date are presenting. Now for example I have:

2019-09-10, 2018-10-14, 2018-12-13 with Dest ACE FNC TFS but in a correct order it should be ACE TFS FNC, is possible to sort it that like it refers to Dates in Dep_date column? All values are made with concat function and i just need to replace strings to the correct order which will match with the dates.

mnc.PNG

Thanks for all help

1 Solution

Accepted Solutions
Woojtek_96
Contributor III
Contributor III
Author

I made it by adding sort_weight to concat function. Thank you very much for guide

View solution in original post

3 Replies
juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

Hello,

do you try to modify the sort in the parameters of the chart.

In the menu sort you can set the sort of each field with an expression.

Bye

Ezir
Creator II
Creator II

Hello,

 

I believe you need to sort the data before concatenation.

 

 

Woojtek_96
Contributor III
Contributor III
Author

I made it by adding sort_weight to concat function. Thank you very much for guide