Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, I'm new to Qlik and would like some help. I have this expression that checks if the result of a calculation is equal to or greater than 100 and if it is greater than 100 I should remove 0.01. It turns out that he never gets to take that 0.01 away and always presents me as if I had given 100, even if it's greater than 100.
= If ((Sum ([in_inf_hot_modificacao]) / count ([path]) * 100) + (Sum ([in_inf_cold_modificacao]) / count ([path]) * 100) + (Sum ([in_inf_frozen_modificacao]) / count ([ path]) * 100) = 100,
(Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100),
If ((Sum ([in_inf_hot_modificacao]) / count ([path]) * 100) + (Sum ( [in_inf_cold_modificacao]) / count (path) * 100) + (Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100)> 100,
(Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100) - 0,01))
shouldn't the subtraction be a decimal, not a comma? - .01?
Or confirm this results in > 100 in your chart/object
(Sum ([in_inf_hot_modificacao]) / count ([path]) * 100)
+
(Sum ( [in_inf_cold_modificacao]) / count (path) * 100)
+
(Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100)