topic Re: Hide zero lines in straight table in App Development

Hide zero lines in straight table

Phan_Anh_Son — Tue, 23 Jul 2024 01:40:59 GMT

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

Re: Hide zero lines in straight table

marksouzacosta — Tue, 23 Jul 2024 02:06:26 GMT

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.

Re: Hide zero lines in straight table

anat — Tue, 23 Jul 2024 02:27:15 GMT

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