Error in expression but working, how?

[Anonymous]

Hello everyone,

So i was trying to do an expression where the Business code(=Product line) is the one in which the engineer is working. With the engineer selected this expression calculates how many cases are in the Product Line that the engineer is working in. Nevertheless in the expression editor it is underlined with the red line (indicating there is an error?!) but it says expression OK and it is working. I can not find out why is underlined with red. Can you help me?

='Surveys: '& count({$<PROD_L3_BUSINESS_CODE=P(),TCE_RSLT_Engineer_NM=>} [TCE_RSLT_CASE_ID])

Thanks for you time and help,

Regards

Lluís

[Chanty4u · Accepted solution]

yes it should work ,

which version you are using  qlikview?

some versions it will work even if it show red line also.

[shanky1907]

Just because you are using the String 'Surveys:' in the calculation, it gives the redline underneath the expression. If the syntax of the rest calculation is good, it will give expression as OK.

[Anonymous]

Thanks for the help

[Anonymous]

Thanks for your help!