topic Re: Sorting in Asc or Desc in Expression? in QlikView

Sorting in Asc or Desc in Expression?

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

Is it possible to sort a formula in expression in Asc or Desc order in QlikView without using the sort option provided in General Tab?

as i need to calculate further based on this sorting.

i want to do this at front end.. and not at scripting level.

Re: Sorting in Asc or Desc in Expression?

Anil_Babu_Samineni — Mon, 23 Oct 2017 01:18:16 GMT

Yes, by help of aggregation like

Aggr(sum(sales), (fieldname, (NUMERIC), (ASCENDING)))

Re: Sorting in Asc or Desc in Expression?

devarasu07 — Mon, 23 Oct 2017 02:44:42 GMT

Hi,

Yes, this feature included in Qlikview 12+ and Sense 3.2+

you have write something like this,

=Aggr(sum(TotalNetPrice)/sum(TOTAL TotalNetPrice), (ArticleNo, (=Sum({<ArticleNo>}TotalNetPrice), DESC)))

The sortable Aggr function is finally here!

mock

ABC Analysis in Qlikview

Hope this helps to you

Regards,

Deva

Re: Sorting in Asc or Desc in Expression?

Anonymous — Sun, 29 Oct 2017 15:27:04 GMT

Thank you, but version of my Qlik View is 11.2..

Any idea how we can achieve in this version?

Re: Sorting in Asc or Desc in Expression?

sunny_talwar — Sun, 29 Oct 2017 21:36:06 GMT

Front end sorting won't be possible in QV 11.2... the only possible way would be to sort the data in correct manner in the script... and then use Aggr() without sort-able functionality....

Re: Sorting in Asc or Desc in Expression?

BalaBhaskar_Qlik — Fri, 31 Aug 2018 12:18:52 GMT

Did you resolved the sorting issue, post it.