Hide row in pivot table

[mail2bsk]

Hi

Any hide how we can Hide row when income is zero and also hide when there is only 1 child record.

Dept	Income	forecast	Header 4
Dept 1	8	10
Sub_Dept 1	3	4
Patient 1	1	0
Patient 2	2	0
Patient 3	0	4	Hide
Sub Dept 2	1	1
Patient 4	1	1	Hide
Sub Dept 3	4	5
Patient 5	2	3
Patient 6	2	2

Thanks

[MK9885]

Use Conditional Expression for your Income...

what is the expression you using?

Is this for Qlikview or Qlik Sense?

[mail2bsk]

qliksenes

[agigliotti]

you can only hide a row with all measures equal to zero unchecking "Include zero values" under "Data handling" section.

[MK9885]

You exactly cannot hide a row in Qlik Sense but  the workaround I'd prefer is use Text color expression..

Ex: if(sum(Income)=0,white())

check this out in properties for measure.