Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to sort this table in sort by actual order. i did the load in qlick view this table but doe not short to actual order. i try to sort this table in default order. but in that function not work. please help the sort to inline mode. script details as follows. (bcod,month,year and branch is crosstable)
sagara
BCOD |
MONTH |
YEAR |
BRANCH |
DIR_PRM |
DBT_STL |
SAL_SALE |
INT_INC |
RNT_INC |
SND_INC |
EXC_COL |
RTN_STL |
TOT_COL |
ADM_EXP |
AGM_EXP |
CLM |
CLM_PRO |
COM |
FIN_EXP |
MGT_FEE |
OST_EXP |
RI_FEE |
RNT_ADV |
RIS_DPT |
SEL_EXP |
STF_EXP |
TAXES |
FIX_AST |
STF_LON |
REFUND |
RTN_CHQ |
EXC_PAY |
DIV_PAY |
LEASE |
TOT_PAY |
NET_INF_OUT |
You could sort within an inline-table load with rowno() separately or integrated with a dual-field:
table:
Load dual(FIELD, rowno()) as FIELD Inline [
FIELD
BCOD
MONTH
YEAR
BRANCH
DIR_PRM
DBT_STL
SAL_SALE
INT_INC
RNT_INC
SND_INC
EXC_COL
RTN_STL
TOT_COL
ADM_EXP
AGM_EXP
CLM
CLM_PRO
COM
FIN_EXP
MGT_FEE
OST_EXP
RI_FEE
RNT_ADV
RIS_DPT
SEL_EXP
STF_EXP
TAXES
FIX_AST
STF_LON
REFUND
RTN_CHQ
EXC_PAY
DIV_PAY
LEASE
TOT_PAY
NET_INF_OUT
];
- Marcus
Along with @Marcus Dual() function inline load, U can try the below option too.