Discussion board where members can get started with QlikView.
I need the branches to be sorted as like below.
I need this to be done in the form of an expression but not in the front end.
SortingMap:MAPPING LOAD * INLINE [txt, numRA, 1EH, 2K7, 3K9, 4EM, 5AS, 6TA, 7MY, 8];
NOCONCATENATELOADBRANCH, PREMIUM, Dual(BRANCH, ApplyMap('SortingMap', BRANCH, 100000)) AS BranchTempFROM [D:\CUSTOMER SORTING.xlsx] (ooxml, embedded labels, table is Sheet1);
DROP FIELD BRANCH; RENAME FIELD BranchTemp TO BRANCH;
View solution in original post
You just have to add the BRANCH field as a dimension in a chart and make sure it is numerically ordered.
As an expression, but not on front end? what do you mean? Not sure I completely understand
It likes, I need this to be achieved not in the script level. May be as a calculated dimension etc
This is fine. If this is to be achieved in front end,how it will b done?