topic Re: How to make this If as a Set? in QlikView

How to make this If as a Set?

Wed, 04 Sep 2013 11:04:18 GMT

I´m trying do change this If expression to a set expression but can´t make it to work. Can someone help me?

If(A3 = 653, sum(Utfall_Belopp * _Flagga_Drift * _Flagga_TransUtbetald),
if(A3 = 651 and Konto = 7921 or A3 = 651 and Konto = 8597 or A3 = 651 and Konto = 7931, sum(Utfall_Belopp * _Flagga_Drift * _Flagga_TransUtbetald)))

Re: How to make this If as a Set?

Wed, 04 Sep 2013 11:12:41 GMT

Try with:

Sum({<A3 ={653}>+<A3 ={651}, Konto={7921}>+<A3 ={651}, Konto={8597}>+<A3 ={651}, Konto={7931}>}Utfall_Belopp * _Flagga_Drift * _Flagga_TransUtbetald)

Re: How to make this If as a Set?

Wed, 04 Sep 2013 11:18:14 GMT

Thanks! Did't know about the >+< operator. Nice to learn new things!

Re: Re: How to make this If as a Set?

Wed, 04 Sep 2013 11:26:05 GMT

Yes, the + operator stands for union of both sets of records(rows that belong to any of the unioned sets). There also is:

- for Exclusion

* for Intersection

/ for Symmetric Difference

Take a look: