topic Re: Hide zero in table Qlik Sense in App Development

Hide zero in table Qlik Sense

jmialoundama — Sat, 16 Nov 2024 19:06:02 GMT

Hi,

I don't want to display the lines when :

BALANCE M YTD = 0 AND BALANCE M-1 YTD = 0 AND BALANCE M PERIOD = 0 AND BALANCE M-1 PERIOD = 0

How can i do it in table Qlik Sense ?

Thanks in advance 🙂

Re: Hide zero in table Qlik Sense

nisha_rai — Tue, 18 Feb 2020 10:01:36 GMT

Hi ,

Unchecked the include zero values.

Re: Hide zero in table Qlik Sense

jmialoundama — Tue, 18 Feb 2020 10:08:14 GMT

Thanks NISHA ! 🙂

I was looking for this option but I did not find it in the parameters of the Qlik table

That's perfect, thank you very much !

Re: Hide zero in table Qlik Sense

jmialoundama — Thu, 20 Feb 2020 13:55:37 GMT

Hi,

I have an other problem.

When my result is less than zero checking the box "Include zero values" does not hide my line which contains "-0"

Re: Hide zero in table Qlik Sense

nisha_rai — Thu, 20 Feb 2020 15:33:03 GMT

Hi,

Can you share the sample data . so that i can provide you the exact solution

Re: Hide zero in table Qlik Sense

jmialoundama — Thu, 20 Feb 2020 15:46:32 GMT

Here is my table:

Here are the formulas I have :

BALANCE M PERIOD : =Sum({<VERSION={'YTD'}>}[BAL_BALANCE_M] +[BAL_BALANCE_PYC_M]);

BALANCE M PERIOD : =Sum({<VERSION={'MONTH'}>}[BAL_BALANCE_M] +[BAL_BALANCE_PYC_M])-Sum({<VERSION={'MONTH'}>}[BAL_BALANCE_PYC_M]);

BALANCE M-1 PERIOD : =Sum({<VERSION={'MONTH'}>}[BAL_BALANCE_M_1] +[BAL_BALANCE_PYC_M_1])-(SUM({<VERSION={'MONTH'}>}[BAL_BALANCE_PYC_M_1]));

Re: Hide zero in table Qlik Sense

nisha_rai — Mon, 24 Feb 2020 07:16:47 GMT

Hi ,

Because that is not the exactly 0, may be the amount is -0.222/-0.0222* something, that including zero value check box only work when value is exactly 0.

Re: Hide zero in table Qlik Sense

jmialoundama — Mon, 24 Feb 2020 13:04:36 GMT

Hi,

Finlay i use function ROUND to resolv my problem

ROUND([my_measure],0.01).