Qliksense do not include zero values igore one column has value

[zhaohaifeng]

Hi All,

Now we have the requirement for lights, we set background color for different conditions.

The lights depend on % measure, and the light value was blank, so for below case , for AC, the values all was 0/null, but we have the lights measure, so the include zero values in add-ones/data handling not works. how can we not show AC region in this case? Thanks. also attached the qvf.

[PriyankaShivhare]

Hope this helps..!

please find attached qvf

Thanks,

Priyanka