Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

inline

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
2 Replies
marcus_sommer

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

krishna_2644
Specialist III
Specialist III

Along with @Marcus Dual() function inline load, U can try the below option too.5.PNG