topic Re: Error in expression but working, how? in QlikView

Error in expression but working, how?

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

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

Re: Error in expression but working, how?

Chanty4u — Thu, 05 Oct 2017 09:40:12 GMT

yes it should work ,

which version you are using qlikview?

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

Re: Error in expression but working, how?

shanky1907 — Thu, 05 Oct 2017 09:53:19 GMT

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.

Re: Error in expression but working, how?

Anonymous — Thu, 05 Oct 2017 11:04:30 GMT

Thanks for the help

Re: Error in expression but working, how?

Anonymous — Thu, 05 Oct 2017 11:04:53 GMT

Thanks for your help!