Discussion Board for collaboration related to Creating Analytics for QlikView.
i have a Problem with two Formulas, how can I combinate the two following Formulas:
if (Währung <> 'EUR', EffektwertSumme*Kurs)
SUM(IF(Kreditorabkürzung = '3', 0, [EffektivwertSumme]))
Do you have any solution, how I can combinate this to formulas.
Go to Solution.
Depends what outcome you want, you've not provided enough informaton. However as an exmaple you could do the following:
SUM(IF(Kreditorabkürzung = '3' ,0, if(Währung <> 'EUR' ,EffektwertSumme*Kurs,EffektwertSumme)))
View solution in original post