Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=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)
=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)
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.
You need to apply the same condition to the Total Horas measure too.
I'm sorry but what do you mean? Please, check the screenshot.
Thank you.
Regards.
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.
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.
Tried that swuehl.
It does nothing
Please post a Qlik Sense app that demonstrates the problem.
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.