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.
Thanks.
AJ
