Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum(If(Turnover*0,25 < 60, 60, Turnover * 0,25))
Hey Gysbert tried that but it jsut gives me 0 on every row.
If you look at the pic I attached you'll see
Screenshots are bloody useless. Please post something with data that can be used to reproduce the issue.
Is turnover a field or expression here? or may be it is an expression label?
Updated with a qvw i just copied your expression
May be this?
Sum(Aggr(If(sum(price*volume)*0.0025 < 60, 60, sum(price*volume) * 0.0025), orderId, longName, buySell))
Yeah that worked! thanks man!
Problem was I used label of the expression instead of the expression it represented!
Cheers!