topic Re: Sorting issue in QlikView

Sorting issue

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

Hi Team,

I am trying to sort values like below expression in sort:

Match(TYPE,'AD','FS','Pl','DB','APP','Total')

In future new values adding into TYPE filed like below. But in future also I want order first five always should be on top('AD','FS','Pl','DB','APP') and others should be last .

TYPE

APP

Total

Re: Sorting issue

Anil_Babu_Samineni — Mon, 20 Nov 2017 06:29:53 GMT

May be this?

Match(Only({1} TYPE),'AD','FS','Pl','DB','APP','Total')

Re: Sorting issue

its_anandrjs — Mon, 20 Nov 2017 06:36:57 GMT

Add another inline table table in data model

Load * inline

[

TYPE,TSortOrder

AD,1

FS,2

PI,3

DB,4

APP,5

SO,6

BO,7

BI,8

SX,9

Total,10

];

And in sort properties un check all and select sort by expression and write

=TSortOrder

=Only({1} TSortOrder)

Re: Sorting issue

Chanty4u — Mon, 20 Nov 2017 07:14:17 GMT

try this in both sort tab and dimesion tab

for more check this

order not workin

pick(match(TYPE,'AD','FS','Pl','DB','APP','Total'),1,2,3,4,5,6)