Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Expression for Unit Price * Qty

HI All,

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).

Please advice.

Thanks

Henry

Tags (1)
1 Solution

Accepted Solutions

Re: Expression for Unit Price * Qty

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

5 Replies

Re: Expression for Unit Price * Qty

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

Re: Expression for Unit Price * Qty

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)

chauhans85
Esteemed Contributor

Re: Expression for Unit Price * Qty

only([unit price]) * only(qty)

Not applicable

Re: Expression for Unit Price * Qty

yes it worked, my bad wrong exp that I used

Thanks anyway.

Not applicable

Re: Expression for Unit Price * Qty

hi ,

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 )

Community Browser