Discussion board where members can get started with Qlik Sense.
Need help about how to create expression unit price * qty ? the formula should be calculate for each row.
So when I sum total sales will be correct not (sum of unit price).
Go to Solution.
Honestly I do not understand the problem, use a straight table (use a dimension) and add the following expression:
Sum([UNit Price] * qty)
Why doesn't it work?
Let me know
Can you post an example of your data?
sum([unit price] * qty) will work provided each data row has both unit price & qty values
otherwise try sum([unit price]) * sum(qty)
only([unit price]) * only(qty)
yes it worked, my bad wrong exp that I used
sum([unit price] * qty) (or) only([unit price]) * only(qty) both are correct answers Because it works on row bases ...but sum([unit price]) * sum(qty) gives different answer ....summation done on individual field (i.e Column wise )