Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

helen_pip
Contributor II

Sum(IF(and function

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

2 Replies
manisha_uit
Contributor

Re: Sum(IF(and function

Hi,

You can try using Set Analysis something like

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

Thanks

Manisha

Re: Sum(IF(and function

Hi

Try like this

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

or

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


Hope it helps

Community Browser