Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chenna229
Contributor
Contributor

pivot

 
Labels (1)
1 Reply
Saravanan_Desingh

Try this,

tab1:
LOAD SNO, 
     [INVOICE NO], 
     [GENERATED DATE], 
     MONTH, 
     AMOUNT
FROM
[..\Mis_Test_Srini (1).xlsx]
(ooxml, embedded labels, header is 1 lines, table is Task1);

Dim: INVOICE NO & MONTH

Exp: Sum(AMOUNT)

commQV15.PNG