Discussion Board for collaboration related to Creating Analytics for QlikView.
I want to calculate a field in a diagram:
(sum(Price1)+sum(price2)) / sum(cost)
It doesn't work right: Do u have any idea how to get multiplication and division first, then addition and subtraction?
Go to Solution.
Do you mean this:
=Sum((Price1 + Price2)/Cost)
Although I would do this rather - it will handle nulls properly:
What you provide the expression will work. And it works and starts from Left - Right. Ref image attacched