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

[#2]

Hey Sunny that actuallt worked better got some issues with the previous response. Can you explain to me what your expression is doing?

[sunny_talwar]

I am just using your exact expression which you had under Turnover. This was aggregated expression vs. price*volume which was unaggregated. But the issue was that since you have an aggregation within an aggregation, you need to use Aggr() function.

You can check this link out for more on Aggr() function

https://www.analyticsvidhya.com/blog/2014/02/aggr/