Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Jsaintmaxent
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

View solution in original post