Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik data vizualization for Pivot

!@@Hi Team,

we have a below requirement

RegionChannel17-Jul17-Jun
SouthChannel1018
WestChannel2125
EastChannel3137
NorthEastChannel4186
NorthChannel5193
Total6239

Total is nothing but Sum of Jul-17 and Jun-17 aggregate.

The requirement is to show the Total somewhat like below

RegionChannel17-Jul18-Jun
Total6239
SouthChannel1018
WestChannel2125
EastChannel3137
NorthEastChannel4186
NorthChannel519

3

Please note, we tried using partialsum, that failed when there are null values or missing valus, whole data becomes null in that case. Could you please see if that is feasible.

2 Replies
Anonymous
Not applicable
Author

any thought please

Anonymous
Not applicable
Author

Properties of chart - > Presentation -> subtotal on top

It should work.