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

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