topic Expression not working - Sum Total in QlikView

Expression not working - Sum Total

ashmitp869 — Mon, 31 May 2021 03:01:19 GMT

Hi all,

I am not getting the expression value : Please kindly assist :

dimension : PCTYPE with values Carer,Spiritual

if(PCTYPE='Carer',Sum({$<Phase_Start_Carer={0}>} Measure)/Sum(Total{$<Phase_Start_Family_Carer={0}>} Measure),
if(PCTYPE='Spiritual',Sum({$<Phase_Start_Spiritual={0}>} Measure)/Sum(Total{$<Phase_Start_Spiritual={0}>} Measure))

Re: Expression not working - Sum Total

kaushiknsolanki — Mon, 31 May 2021 05:59:28 GMT

Hi,

I see that you are missing the last parenthesis.

Try this.