topic Sort A Dimension in QlikView

Sort A Dimension

Mon, 28 Feb 2011 03:08:50 GMT

Hi All,

How would i sort a dimension by myself for instance..

Data : A, B, C, D, E, F,G, H, I, J, K, L

but i want to sort as i wish :

J, A, K, E, G, B

how would i do tat?

Sort A Dimension

Mon, 28 Feb 2011 04:24:45 GMT

Hi All, How would i sort a dimension by myself for instance.. Data : A, B, C, D, E, F,G, H, I, J, K, L but i want to sort as i wish : J, A, K, E, G, B how would i sort that in Pivot Table properties.

Sort A Dimension

Anonymous — Mon, 28 Feb 2011 04:59:58 GMT

I would probably create a new field in the script for the dimension values, using Dual() and giving each value a numerical underlying value and then just sort the dimension Numerically to achieve the custom sorting.

Sort A Dimension

Mon, 28 Feb 2011 07:35:28 GMT

HI Johannes;

can you give me script example on Dual data type sorting

Sort A Dimension

Mon, 28 Feb 2011 08:11:34 GMT

You can do this by giving numeric header to all the dimesion inthe script. just as 1. A , 2. K , 3. V.

other way is creating new filed in script for all of your dimesion available. and you can then sort them accordinglyy i n front end.

Sort A Dimension

Tue, 01 Mar 2011 09:55:53 GMT

HI,

i want to sort [TXT30] as [Account Group Name dimension ] dimension. when should i give numeric header to that dimension.

and how to do that?

my account group dimension consist of

eg:

cash, account receivable,inventory,prepaid expenses,account payable, expenses payable...etc

how to sort them

1-inventory

2-account receivable

3-cash

4-expenses payable

5-prepaid expenses

6-account payable...etc

this is my current script :

[GLT0]: // G/L account master record transaction figures
Load
[RRCTY] as [Record Type_RRCTY],
[RVERS] as [Version_RVERS],
[RYEAR] as [Fiscal Year_RYEAR],
[DRCRK] as [Debit/Credit Ind._DRCRK],
[RACCT] as KEY,
[RBUSA] as [Business Area_RBUSA],
[TSL01] as [Transaction currency_TSL01],
[TSL02] as [Transaction currency_TSL02],
[TSL03] as [Transaction currency_TSL03],
[TSL04] as [Transaction currency_TSL04],
[TSL05] as [Transaction currency_TSL05],
[TSL06] as [Transaction currency_TSL06],
[TSL07] as [Transaction currency_TSL07],
[TSL08] as [Transaction currency_TSL08],
[TSL09] as [Transaction currency_TSL09],
[TSL10] as [Transaction currency_TSL10],
[TSL11] as [Transaction currency_TSL11],
[TSL12] as [Transaction currency_TSL12],
[TSL13] as [Transaction currency_TSL13],
[TSL14] as [Transaction currency_TSL14],
[TSL15] as [Transaction currency_TSL15],
[TSL16] as [Transaction currency_TSL16];
SQL Select RRCTY RVERS RYEAR DRCRK RACCT TSL01 TSL02 TSL03 TSL04 TSL05 TSL06 TSL07 TSL08 TSL09 TSL10 TSL11 TSL12 TSL13 TSL14 TSL15 TSL16 RBUSA from GLT0
WHERE RYEAR = 2011 AND BUKRS = 6700
;
//STORE * FROM [GLT0] INTO GLT0.QVD;

LEFT JOIN (GLT0)
LOAD
[SAKNR] as KEY,
[TXT20] as [Short Text_TXT20],
[TXT50] as [G/L Acct Long Text_TXT50];
SQL Select SAKNR TXT50 TXT20 from SKAT
where SPRAS ='EN' and KTOPL ='FLDA'
;

LEFT JOIN
LOAD
[KTOKS] AS [G/L Account Group],
[SAKNR] as KEY;
SQL Select KTOKS SAKNR from SKA1
WHERE KTOPL ='FLDA'
;

LEFT JOIN
LOAD
[KTOKS] AS [G/L Account Group],
[TXT30] as [Account Group Name];
SQL Select KTOKS TXT30 from T077Z
WHERE KTOPL ='FLDA' AND SPRAS ='EN'
;

store GLT0 into GLT0.qvd;

Sort A Dimension

Fri, 04 Mar 2011 09:21:22 GMT

anyone??