Skip to main content

Scalability

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
thisisnita
Creator
Creator

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
thisisnita
Creator
Creator
Author

any thought please

ritukushwaha20
Explorer
Explorer

Properties of chart - > Presentation -> subtotal on top

It should work.