topic Calculatio in QlikView

Calculatio

kev6brown — Wed, 25 Nov 2020 16:16:04 GMT

If i break the following calculation in 6 seperate calculations they work find however in the form below (as i need it to be) it has an error - Garbage after expression:','

What am I doing wrong?

if(GetSelectedCount(CalDay)>0,(Count ({<WardCode={'Grattan'}>}Distinct(BedDaysPatientID)))*2
-
if(GetSelectedCount(CalDay)>0,Count ({<WardCode={'Grattan'},Leave={'Y'}>}Distinct(BedDaysPatientID))))
/
if(GetSelectedCount(CalDay)>0,(Sum({<WardCode={'Grattan'}>}Data))*Count(CalDay))
,
if(GetSelectedCount(CalMonth)>0,(Count({<WardCode={'Grattan'}>}(BedDaysPatientID)))*2)
-
if(GetSelectedCount(CalMonth)>0,(Count({<WardCode={'Grattan'},Leave={'Y'}>}(BedDaysPatientID)))*2)
/
if(GetSelectedCount(CalMonth)>0,(Sum({<CalDay={1},WardCode={'Grattan'}>}Data))*Count(CalDay))

Re: Calculatio

lockematthewp — Mon, 08 Jul 2019 14:38:51 GMT

It looks like you need to remove one of the closing brackets before the comma. All of your parenthesis are closed before the comma but after the comma is your else statement.

Re: Calculatio

neelamsaroha157 — Mon, 08 Jul 2019 14:40:19 GMT

You may Try this - (check brackets)

if(GetSelectedCount(CalDay)>0,

(Count ({<WardCode={'Grattan'}>}Distinct BedDaysPatientID)*2
-
Count ({<WardCode={'Grattan'},Leave={'Y'}>}Distinct BedDaysPatientID))
/
Sum({<WardCode={'Grattan'}>}Data))*Count(CalDay)
,
if(GetSelectedCount(CalMonth)>0,

(Count({<WardCode={'Grattan'}>}BedDaysPatientID)*2
-
Count({<WardCode={'Grattan'},Leave={'Y'}>} BedDaysPatientID)*2)
/
Sum({<CalDay={1},WardCode={'Grattan'}>}Data))*Count(CalDay)