topic Re: Sort order issue in QlikView

Sort order issue

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

Hi,

I have a issue with sort order.I have tried all sorting items but not working.

Please find the attached spreadsheet for detail and required output.

Thanks..

nareshthavidishetty — Tue, 21 Aug 2018 08:46:28 GMT

Here is the attachment.

Thanks..

manoranjan_d — Tue, 21 Aug 2018 09:03:15 GMT

use dual function to solve

manoranjan_d — Tue, 21 Aug 2018 09:14:29 GMT

LOAD [Actual data],

RecNo() as num

FROM

xxx

create list box and in the sort tab select the expression and give

Dual([Actual data],num)

manoranjan_d — Tue, 21 Aug 2018 09:15:42 GMT

select descending or Asc as per your requirement also

jyothish8807 — Tue, 21 Aug 2018 09:23:27 GMT

Hi,

Create a calculated dimension:

=if(Data ='NIL',text(Data),Data)

Then sort in Test -- A to Z

Br,

jyothish8807 — Tue, 21 Aug 2018 09:24:30 GMT

Br,