Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:How to load this Data?

Hi all,

I have data like below format how to load this type of data?

can anyone explain in detail.

Chanty

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

6 Replies
sunny_talwar

Have you tried using gysbert's sample here?

multi_header_pivot_import.qvw

Chanty4u
MVP
MVP
Author

yes.still am unable to achieve this

antoniotiman
Master III
Master III

Hi Chanty,

may be :

LOAD F1 as Product,
Qu as Open_Qu,
Ra as Open_Ra,
Val as Open_Val,
Qu1 as InValue_Qu,
Ra1 as InValue_Ra,
Val1 as InValue_Val,
Qu2 as OutValue_Qu,
Ra2  as OutValue_Ra,
Val2 as OutValue_Val,
gvalue
FROM
"https://community.qlik.com/servlet/JiveServlet/download/1155194-252646/sreg.xlsx"
(ooxml, embedded labels, header is 1 lines, table is
Sheet1);

Regards,

Antonio

Chanty4u
MVP
MVP
Author

Hi,

Thanks for your reply.

Can you share that sample Qvw ?

antoniotiman
Master III
Master III

See Attachment.

Regards,

Antonio

settu_periasamy
Master III
Master III

Hi suresh,

find attached using multi_header_pivot_import.qvw

Capture.JPG