Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sakthi266
Contributor III
Contributor III

Qlikview Pivot Table Issue

Hi team, 

           Please refer below the data which is in Qlikview need to show the Pivot table in multiple dimension as mentioned below

EntityAccount NameTypeDateAmount1Amount2Amount3Amount4
AA1I-101-10-2021500   
AA1I-201-10-20211500   
AA1D-101-10-2021 200  
AA1D-201-10-2021 300  
AA1ST01-10-2021  2000 
AA1LT01-10-2021  2500 
AA1Oth01-10-2021   300
AA1I-101-10-2021500   
AA1I-201-10-20211500   
AA1D-101-10-2021 200  
AA1D-201-10-2021 300  
AA1ST01-10-2021  2000 
AA1LT01-10-2021  2500 
AA1Oth01-10-2021   300
AA2I-101-10-2021100   
AA2I-201-10-20211700   
AA2D-101-10-2021 250  
AA2D-201-10-2021 350  
AA2ST01-10-2021  250 
AA2LT01-10-2021  1640 
AA2Oth01-10-2021   500
AA2I-101-10-20211500   
AA2I-201-10-2021300   
AA2D-101-10-2021 450  
AA2D-201-10-2021 4640  
AA2ST01-10-2021  5460 
AA2LT01-10-2021  5640 
AA2Oth01-10-2021   6580
BB1I-101-10-2021500   
BB1I-201-10-20211500   
BB1D-101-10-2021 200  
BB1D-201-10-2021 300  
BB1ST01-10-2021  2000 
BB1LT01-10-2021  2500 
BB1Oth01-10-2021   300
BB1I-101-10-2021500   
BB1I-201-10-20211500   
BB1D-101-10-2021 200  
BB1D-201-10-2021 300  
BB1ST01-10-2021  2000 
BB1LT01-10-2021  2500 
BB1Oth01-10-2021   300
BB2I-101-10-2021100   
BB2I-201-10-20211700   
BB2D-101-10-2021 250  
BB2D-201-10-2021 350  
BB2ST01-10-2021  250 
BB2LT01-10-2021  1640 
BB2Oth01-10-2021   500
BB2I-101-10-20211500   
BB2I-201-10-2021300   
BB2D-101-10-2021 450  
BB2D-201-10-2021 4640  
BB2ST01-10-2021  5460 
BB2LT01-10-2021  5640 
BB2Oth01-10-2021   6580

 

 

Also attached in Excel as well

 

Thanks and Regards, 
Sakthivel.S

 

Labels (2)
0 Replies