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

row into colomns


LOAD Date(Date,'DD/MM/YYY') As Date,
Dimension,
TxnType,
WOS as Distribution,
[Seller HQFlag] AS [Outlet Type]
// Region,
// ModelCode
FROM

(
qvd);
//Left Join

Meess_Temp1:
LOAD
Date(Date,'DD/MM/YYY') As Date,
Dimension,
TxnType,
WOS as Distribution,
[Outlet Type]

// Region,
// ModelCode
FROM

(
qvd);

i have input like below i attached .i want to get

Out letType  D-2  Wk-1  Wk-2

Distribution  4.9   4.8      4.7

like this i want output.

the implementation must be done in scripting side ony.

plz help me


1 Reply
robert_mika
Master III
Master III

Try Cross Table or generic load.

Your Word file can not be opened..