Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Contributor II
Contributor II

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

View solution in original post

3 Replies
Highlighted

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

Highlighted
Creator II
Creator II

Hello,

 

I believe you need to sort the data before concatenation.

 

 

Highlighted
Contributor II
Contributor II

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

View solution in original post