Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sakthi266
Contributor III
Contributor III

Multi Horizontal Dimension In Qlikview

Hi Team, 

        I need to show multi horizontal dimension in Qlikview pivot table which is shown below and i have the data which is attached.

 

I need to show high level dimension which i am unable to get it(ie. Interest, Dividends, Gain/Loses/Others

 

 How to show thisInterest Dividends Gain/Loses Others
EntityAccount NameInterest-1Interest-2 Dividends-1Dividends-2 Long-TermShort-Term Others
AA110003000 400600 50004000 600
 A216002000 7004990 72805710 7080
A Total 26005000 11005590 122809710 7680
BB110003000 400600 50004000 600
 B216002000 7004990 72805710 7080
B Total 26005000 11005590 122809710 7680
Grand Total 520010000 220011180 2456019420 15360
Labels (1)
  • Other

0 Replies