Qlik Community

Qlik Scalability

Highlighted
thisisnita
Contributor

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
Contributor

Re: Qlik data vizualization for Pivot

any thought please

ritukushwaha20
Visitor

Re: Qlik data vizualization for Pivot

Properties of chart - > Presentation -> subtotal on top

It should work.