Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Can't get a sum-total when using multi-dimension in pivot table

Hi,

I have following data and I am trying to plot a simple pivot table which will give me the sum-total for Row4.

I am using Row1, Row2 and Row3 as my Dimension. (these 3 fields has to be in Dimension only)

Issue is I am not getting the sub-total at the bottom for Row4 even when I do Presentation->Row1->check Partial Sums.

Tried to do the same thing with Row2 and Row3 as well.


Load * inline
[
Row1, Row2, Row3, Row4
A, Test, Apple, 100
A, Test1, Banana, 200
A, Test2, Orange, 300
];

 

What I want:

Capture.PNG

 

Need the same in Pivot chart only, can't move to Straight chart

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

If you have Row1, Row2, Row3 as dimensions and Sum(Row4) as a measure, it should look like this when expanded.

row4.PNG

 

View solution in original post

1 Reply
Highlighted
Employee
Employee

If you have Row1, Row2, Row3 as dimensions and Sum(Row4) as a measure, it should look like this when expanded.

row4.PNG

 

View solution in original post