Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
chenna229
Contributor
Contributor

pivot

 
Labels (1)
1 Reply
saran7de
Master
Master

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