topic Re: Order by in QlikView

Order by

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

How can I order by expression :

Column(5)/(column(3)+column(4))

Re: Order by

Anil_Babu_Samineni — Fri, 03 Nov 2017 07:06:04 GMT

Try to paste while expression under sort tab of section called enable expression then see

Re: Order by

devarasu07 — Fri, 03 Nov 2017 07:08:38 GMT

Hi,

Given details are not much clear, would be able to provide with mock data in excel format , current output & expected output ?

FYI, if you wish to do custom sort based on calculated measure you do it via below way (this feature will work Qlik 12+ version & Qliksense 3.2+)

The sortable Aggr function is finally here!

PS: we can do it via chart sort property (write that expression then apply sort order) and also back end script method.

Thanks,

Deva

Re: Order by

denis115 — Fri, 03 Nov 2017 07:13:58 GMT

There I can sort only by dimensions

Re: Order by

denis115 — Fri, 03 Nov 2017 07:15:45 GMT

I think its not what I need

Re: Order by

Anil_Babu_Samineni — Fri, 03 Nov 2017 07:32:54 GMT

Yes, that's what my intention are you able to see the expression in the right preview? If so, please enable that and paste those expression which is column()

Re: Order by

denis115 — Fri, 03 Nov 2017 07:34:24 GMT

I'vejust sorted by full expresion

instead of this

//Column(5)/(column(3)+column(4) I just joined all expresion in one and that worked!
sum ( {<DATAE={"$(=Max(DATAE))"}>}[73_Ост.Конец Сумма])/((Sum ([73_Расход Стоим.]))+(Sum ([73_Пересорт Сумма])))

Re: Order by

Anil_Babu_Samineni — Fri, 03 Nov 2017 08:09:30 GMT

Great, that is what my explanation covers. Good