If then else sum

[#1]

I want to make a if then else sum in Qlikview that calculates

If Turnover*0,25 < 60, Then 60, Else Turnover * 0,25.

Can anyone help?

Updated with Qvw. Meddelandet redigerades av: Niklas Söderqvist

[Gysbert_Wassenaar]

Sum(If(Turnover*0,25 < 60, 60, Turnover * 0,25))

[#3]

Hey Gysbert tried that but it jsut gives me 0 on every row.

[#4]

If you look at the pic I attached you'll see

[Gysbert_Wassenaar]

Screenshots are bloody useless. Please post something with data that can be used to reproduce the issue.

[sunny_talwar]

Is turnover a field or expression here? or may be it is an expression label?

[#7]

Updated with a qvw i just copied your expression

[Gysbert_Wassenaar · Accepted solution]

Replace the label Turnover with the expression that it represents:  Sum(If(price*volume*0.0025<60, 60, price*volume * 0.0025))

[sunny_talwar]

May be this?

Sum(Aggr(If(sum(price*volume)*0.0025 < 60, 60, sum(price*volume) * 0.0025), orderId, longName, buySell))

[#10]

Yeah that worked! thanks man!

Problem was I used label of the expression instead of the expression it represented!

Cheers!