Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use Conditional Expression for your Income...
what is the expression you using?
Is this for Qlikview or Qlik Sense?
qliksenes
you can only hide a row with all measures equal to zero unchecking "Include zero values" under "Data handling" section.
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.