topic Set Analysis Sum with if condition in QlikView

Set Analysis Sum with if condition

mario-sarkis — Wed, 05 Aug 2015 07:00:37 GMT

Hey

here is my question

How can i write this into a set analysis

if(Type='990' or Type ='sfb' or Type='sfd',Sum(Amount)/Count(trx),Sum(Amount)

how can i write this into a set analysis.

Thanks

mario-sarkis — Wed, 05 Aug 2015 08:03:07 GMT

Thanks it works like this

if(Type='990',Sum(Amount)/Count(trx),

if(Type ='sfb' ,Sum(Amount)/Count(trx),

if(Type ='sfd' ,Sum(Amount)/Count(trx),Sum(Amount)

sunny_talwar — Wed, 05 Aug 2015 08:05:48 GMT

Can be simplified like this:

If(Match(Type, '990', 'sfb', 'sfd'), Sum(Amount)/Count(trx), Sum(Amount))