topic Re: Customer sorting in QlikView

Customer sorting

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

Hi members,

I need the branches to be sorted as like below.

1 RA

2 EH

3 K7

4 K9

5 EM

6 AS

7 TA

8 MY

I need this to be done in the form of an expression but not in the front end.

Thanks

Neville

Re: Customer sorting

sunny_talwar — Thu, 03 Oct 2019 17:40:52 GMT

As an expression, but not on front end? what do you mean? Not sure I completely understand

Re: Customer sorting

nevilledhamsiri — Thu, 03 Oct 2019 18:10:11 GMT

Yes,

It likes, I need this to be achieved not in the script level. May be as a calculated dimension etc

Re: Customer sorting

JGMDataAnalysis — Thu, 03 Oct 2019 18:34:54 GMT

SortingMap:
MAPPING LOAD *
INLINE [
txt, num
RA, 1
EH, 2
K7, 3
K9, 4
EM, 5
AS, 6
TA, 7
MY, 8
];

NOCONCATENATE
LOAD
BRANCH,
PREMIUM,
Dual(BRANCH, ApplyMap('SortingMap', BRANCH, 100000)) AS BranchTemp
FROM [D:\CUSTOMER SORTING.xlsx] (ooxml, embedded labels, table is Sheet1);

DROP FIELD BRANCH; RENAME FIELD BranchTemp TO BRANCH;

Re: Customer sorting

nevilledhamsiri — Sat, 05 Oct 2019 16:32:16 GMT

Thanks JGMD

This is fine. If this is to be achieved in front end,how it will b done?

Thanks

Neville

Re: Customer sorting

JGMDataAnalysis — Sat, 05 Oct 2019 20:06:42 GMT

You just have to add the BRANCH field as a dimension in a chart and make sure it is numerically ordered.