topic Re: Sum(IF(and function in QlikView

Sum(IF(and function

helen_pip — Tue, 11 Sep 2012 11:02:37 GMT

Hello

I am trying to write a Sum(If(And function and am getting a little stuck

My function currently reads as:

))

My error starts at the first comma

Does anyone know how I can achieve this?

Many Thanks

Helen

manisha_uit — Tue, 11 Sep 2012 11:46:50 GMT

Hi,

You can try using Set Analysis something like

=Count({$<Diagnosis={Cellulitis}, [Patient Admitted]={1}>}Your_field)

Thanks

Manisha

MayilVahanan — Tue, 11 Sep 2012 20:11:41 GMT

Try like this

Sum(IF(Diagnosis='Cellulitis' and [Patient Admitted?]=1),1,0))

=Count({$<Diagnosis={'Cellulitis'}, [Patient Admitted]={1}>}Your_field)

Hope it helps