Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need to calculate the rate for each client to show it on bar chart. My formula is as below:
=If([Load]='TTL', [Avg weight]*1000*(100-[Lost items %])/([weighted mean]*[FCR])/10)
Qlik shows the correctness of formula, but no results are shown on bar chart.
All names in formula are taken from data.
what is wrong with the above formula?
Where exactly are you using this expression? I mean what kind of object? May be you need to add a Sum() or some kind of aggregation somewhere
=Sum(
If([Load]='TTL', [Avg weight]*1000*(100-[Lost items %])/([weighted mean]*[FCR])/10)
)
Where exactly are you using this expression? I mean what kind of object? May be you need to add a Sum() or some kind of aggregation somewhere
=Sum(
If([Load]='TTL', [Avg weight]*1000*(100-[Lost items %])/([weighted mean]*[FCR])/10)
)
Could you explain whatthe sum does in this example?
If there are multiple values per dimension/s... it adds up the value before displaying the output....