Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mail2bsk
New Contributor

Hide row in pivot table

Hi

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

DeptIncomeforecastHeader 4
Dept 1810
Sub_Dept 134
      Patient 110
      Patient 220
      Patient 304Hide
Sub Dept 211
      Patient 411Hide
Sub Dept 345
     Patient 523
     Patient 622

Thanks

4 Replies
Khan_Mohammed
Honored Contributor II

Re: Hide row in pivot table

Use Conditional Expression for your Income...

what is the expression you using?

Is this for Qlikview or Qlik Sense?

mail2bsk
New Contributor

Re: Hide row in pivot table

qliksenes

agigliotti
Honored Contributor II

Re: Hide row in pivot table

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

Khan_Mohammed
Honored Contributor II

Re: Hide row in pivot table

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.    

Untitled.png

Community Browser