topic Re: Sum and show only values greater than # in App Development

Sum and show only values greater than #

patriciousa — Sun, 24 Jan 2016 08:24:29 GMT

Hi community.

I have this sum right now:

Sum({<Facturable={Y}>} Cantidad)/sum(Cantidad)

This sum is giving numbers like, 30%, 40%, 45%, etc.

What do I have to do to it to only show values that are greater or equal than 90%?

Thank you in advance.

Regards.

Re: Sum and show only values greater than #

Gysbert_Wassenaar — Sun, 24 Jan 2016 11:25:07 GMT

=If(Sum({<Facturable={Y}>} Cantidad)/sum(Cantidad)>=0.9,Sum({<Facturable={Y}>} Cantidad)/sum(Cantidad))

Or maybe:

Sum({<Facturable={Y}, MyDimension={"=Sum({<Facturable={Y}>} Cantidad)/sum(Cantidad)>=0.9"}>} Cantidad)/sum({< MyDimension={"=Sum({<Facturable={Y}>} Cantidad)/sum(Cantidad)>=0.9"}>}Cantidad)

Re: Sum and show only values greater than #

patriciousa — Sun, 24 Jan 2016 15:05:47 GMT

Thank you Gysbert. The first one worked like a charm. (The second one was doing nothing, keeping the same results).

However, I still have one little issue,

How do I delete the grey part where it has no numbers when put in a Table? I ticked to Show Nulls off but it still does.

Thank you again.

Regards.

Re: Sum and show only values greater than #

Gysbert_Wassenaar — Sun, 24 Jan 2016 16:29:29 GMT

You need to apply the same condition to the Total Horas measure too.

Re: Sum and show only values greater than #

patriciousa — Sun, 24 Jan 2016 23:00:26 GMT

I'm sorry but what do you mean? Please, check the screenshot.

Thank you.

Regards.

Re: Sum and show only values greater than #

patriciousa — Sun, 24 Jan 2016 23:12:46 GMT

If I apply the same syntaxis you gave for Total Horas I also get the grey pane. I want to make it dissapear, is it possible?.

Thank you again.

Regards.

Re: Sum and show only values greater than #

swuehl — Mon, 25 Jan 2016 11:08:21 GMT

You need to apply the same condition and you need to disable 'Show NULL values' on Add-Ons - Data processing tab of your chart properties.

Re: Sum and show only values greater than #

patriciousa — Mon, 25 Jan 2016 12:51:32 GMT

Tried that swuehl.

It does nothing

Re: Sum and show only values greater than #

Gysbert_Wassenaar — Mon, 25 Jan 2016 17:13:52 GMT

Please post a Qlik Sense app that demonstrates the problem.

Re: Sum and show only values greater than #

patriciousa — Tue, 26 Jan 2016 17:47:22 GMT

I don't know what I was doing wrong but applying the same expression to Total Horas fixed it after all.

Thank you very much.

Kind regards.

Re: Sum and show only values greater than #

berndjaegle — Thu, 16 Dec 2021 14:42:56 GMT

Thank you Swuehl for this important hint. 👍