Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial sums pivot table

Hello everyone,

I have a pivot table like this showing people going from one telco operator to another one.

RECEIVERS/GIVERS
ORANGEVODAFONESFRTotals outgoing
ORANGE      -538
VODAFONE2-46
SFR56-11
Totals incoming711725

When I have the same operator, I have a '-' in my table which is normal but i would like to show instead of the ' - ', the balance : Incoming - Outgoing.

I would like to have this :

RECEIVERS/GIVERS
ORANGEVODAFONESFRTotals outgoing
ORANGE     - 1538
VODAFONE2               546
SFR56       -411
Totals incoming711725

How can I do that please ?

For information, in my database I have something like this :

ID RECEIVERSGIVERS
1ORANGESFR
2ORANGEVODAPHONE
3VODAFONESFR

..

Thanks for you help

0 Replies