Hide zero lines in straight table

[Phan_Anh_Son]

Hi expert

I have a table with null data in a column , so I need a pivot table without this null values

Input table

output table

I`m working in qlilkview 11 so I put in chart properties the selection of Suppress zero-value but still appear the null value . Is there any formula in the Dimensions to hide this null values .

Thanks in advance

[marksouzacosta]

Hi @Phan_Anh_Son,

What is making your chart to show these zero values is the Avg Budget per Employee measure. Since it is not zero, it governs the whole row. What you can do is to make this measure conditioned to the Actual Measure with Set Analysis.

So, replace the Avg Budget per Employee Measure with something like this:

Sum({<Employee = {"=Sum([Actual])>0"}>} [AVG_BUDGET])

The Set Expression in the case above will return the collection of Employees with Sum of Actuals greater than zero.

[anat]

If (sum(actual) >0, sum(actual))