Expression does not work with one text field

[#1]

Hello All,

In the example, I have a text box with below expression. As you can see that I have comment out the ProcessingOfficeNm and the expression works fine, but if I remove the comment then the value is zero. Would someone please take a look at my Qlikview and tell me what cause this and how to fix it? Thank you for your help everyone.

='Baseline: ' &

num(Sum ({Baseline<SubjectNm={'NewBusinessEffDay'},

OwnerCd=Summary::OwnerCd,

UnderwritingCenterNm=Summary::UnderwritingCenterNm,

//ProcessingOfficeNm=Summary::ProcessingOfficeNm,

EmployeeName=Summary::EmployeeName,

ManagerName=Summary::ManagerName,

ReportingUnitCd=Summary::ReportingUnitCd>

}PolicyIssuanceCnt),' #,##0 ')

[vishsaggi · Accepted solution]

Bcoz there is no data in the ProcessingOfficeNm for Baseline SubjectNm = 'NewBusinessEffDay'

Hence the value 0.

Check that?

[#3]

Thank you!!