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

Thanks

Henry

Tags (1)
1 Solution

Accepted Solutions
MVP

## 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
MVP

## 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

MVP

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

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 )