topic Re: Formula in QlikView

Formula

francisvandergr — Fri, 16 May 2014 13:20:34 GMT

I have this formula and this one is working

=avg ( {$-1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)

I wanna have my selection but noy the Relaties.Markets with contains "ADM"or "XX" in it.

Now i want something extra. It is the same as above but only for the field BetalingsgedragBetaaldJaNee={Betaald}

so i wanna combine

=avg ( {$-1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)

and

=avg ( {$<Betalingsgedrag.BetaaldJaNee = {Betaald}>}Betalingsgedrag.Betalingstermijn)

into 1 formula .

Is this possible ?

MarcoWedel — Fri, 16 May 2014 13:35:33 GMT

=avg ( {$<Betalingsgedrag.BetaaldJaNee = {Betaald}>-1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)

Anonymous — Fri, 16 May 2014 13:36:35 GMT

You can try

=avg ({$<Betalingsgedrag.BetaaldJaNee = P(Betaald)> - 1<Relaties.Market = {"ADM*","XX*"}>}Betalingsgedrag.Betalingstermijn)