topic Expression does not work with one text field in QlikView https://community.qlik.com/t5/QlikView/Expression-does-not-work-with-one-text-field/m-p/1240822#M866215 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>In the example, I have a text box with below expression. As you can see that I have comment out the <STRONG style="color: #ff0000; font-size: 13.3333px;">ProcessingOfficeNm</STRONG><SPAN style="color: #000000;"> 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.</SPAN></P><P></P><P style="font-size: 13.3333px;">='Baseline: ' &amp;</P><P style="font-size: 13.3333px;">num(Sum ({Baseline&lt;SubjectNm={'NewBusinessEffDay'},</P><P style="font-size: 13.3333px;">OwnerCd=Summary::OwnerCd,</P><P style="font-size: 13.3333px;">UnderwritingCenterNm=Summary::UnderwritingCenterNm, </P><P style="font-size: 13.3333px;"><STRONG style="color: #ff0000;">//ProcessingOfficeNm=Summary::ProcessingOfficeNm, </STRONG></P><P style="font-size: 13.3333px;">EmployeeName=Summary::EmployeeName,</P><P style="font-size: 13.3333px;">ManagerName=Summary::ManagerName, </P><P style="font-size: 13.3333px;">ReportingUnitCd=Summary::ReportingUnitCd&gt;</P><P style="font-size: 13.3333px;">}PolicyIssuanceCnt),' #,##0 ')</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Expression does not work with one text field https://community.qlik.com/t5/QlikView/Expression-does-not-work-with-one-text-field/m-p/1240822#M866215 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>In the example, I have a text box with below expression. As you can see that I have comment out the <STRONG style="color: #ff0000; font-size: 13.3333px;">ProcessingOfficeNm</STRONG><SPAN style="color: #000000;"> 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.</SPAN></P><P></P><P style="font-size: 13.3333px;">='Baseline: ' &amp;</P><P style="font-size: 13.3333px;">num(Sum ({Baseline&lt;SubjectNm={'NewBusinessEffDay'},</P><P style="font-size: 13.3333px;">OwnerCd=Summary::OwnerCd,</P><P style="font-size: 13.3333px;">UnderwritingCenterNm=Summary::UnderwritingCenterNm, </P><P style="font-size: 13.3333px;"><STRONG style="color: #ff0000;">//ProcessingOfficeNm=Summary::ProcessingOfficeNm, </STRONG></P><P style="font-size: 13.3333px;">EmployeeName=Summary::EmployeeName,</P><P style="font-size: 13.3333px;">ManagerName=Summary::ManagerName, </P><P style="font-size: 13.3333px;">ReportingUnitCd=Summary::ReportingUnitCd&gt;</P><P style="font-size: 13.3333px;">}PolicyIssuanceCnt),' #,##0 ')</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-does-not-work-with-one-text-field/m-p/1240822#M866215 2020-11-25T16:16:04Z Re: Expression does not work with one text field https://community.qlik.com/t5/QlikView/Expression-does-not-work-with-one-text-field/m-p/1240823#M866216 <HTML><HEAD></HEAD><BODY><P>Bcoz there is no data in the ProcessingOfficeNm for Baseline SubjectNm = '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">NewBusinessEffDay'</SPAN></P><P>Hence the value 0. </P><P>Check that? </P></BODY></HTML> Fri, 09 Dec 2016 20:41:03 GMT https://community.qlik.com/t5/QlikView/Expression-does-not-work-with-one-text-field/m-p/1240823#M866216 vishsaggi 2016-12-09T20:41:03Z Re: Expression does not work with one text field https://community.qlik.com/t5/QlikView/Expression-does-not-work-with-one-text-field/m-p/1240824#M866217 <HTML><HEAD></HEAD><BODY><P>Thank you!!</P></BODY></HTML> Mon, 12 Dec 2016 17:52:30 GMT https://community.qlik.com/t5/QlikView/Expression-does-not-work-with-one-text-field/m-p/1240824#M866217 2016-12-12T17:52:30Z