Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

How can I combinate two Formulas

Hello together,

i have a Problem with two Formulas, how can I combinate the two following Formulas:

1.

if (Währung <> 'EUR', EffektwertSumme*Kurs)

2.

SUM(IF(Kreditorabkürzung = '3', 0, [EffektivwertSumme]))

Do you have any solution, how I can combinate this to formulas.

Thank you.

Greets

Nikolaus80

1 Solution

Accepted Solutions
RedSky001
Contributor III

Re: How can I combinate two Formulas

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

1 Reply
RedSky001
Contributor III

Re: How can I combinate two Formulas

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