Hide the data for those ObjectIDs in a pivot table that have totals value 0 in a particular column.
HI Devs,
I have a pivot table in Qlik Sense as below. I wish to hide those Obj IDs in the table that have the total value for the 'Calculation ' field as 0. (Totals is the subtotal field i got when i added data to the pivot table)
Obj ID
MONTHYEAR
Measure1
Measure2
Calculation
10001
Totals
0
-900
0
Jan-19
0
-300
0
Feb-19
0
-400
0
Mar-19
0
-100
0
Apr-19
0
-100
0
10002
Totals
41
0
40
19-Feb
0
0
40
19-Mar
0
0
40
19-Apr
40
0
40
Here I would like to see only the values for Obj ID 10002.
