topic Re: Sort columns by sort in another column in QlikView

Sort columns by sort in another column

Woojtek_96 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Thanks for all help

Re: Sort columns by sort in another column

juliensaintmaxent3113 — Thu, 25 Jul 2019 13:45:40 GMT

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

Re: Sort columns by sort in another column

Ezirraffner — Thu, 25 Jul 2019 13:57:47 GMT

Hello,

I believe you need to sort the data before concatenation.

Re: Sort columns by sort in another column

Woojtek_96 — Fri, 26 Jul 2019 07:48:06 GMT

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