topic Re: Invalid Expression in QlikView https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/1440303#M432219 <HTML><HEAD></HEAD><BODY><P>Can you share full script here?</P></BODY></HTML> Thu, 21 Dec 2017 01:07:40 GMT Anil_Babu_Samineni 2017-12-21T01:07:40Z Invalid Expression https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/1440301#M432217 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Invalid expression</SPAN></P><P><SPAN style="font-size: 13.3333px;">F42119:</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD *,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">((Num(If(Match(LineType,'B','BF','BN','BX','CD','CM','CN','EC','F','FN','N','IA','IC','J','JN','K','L','LC','M','N','N1','N2','N3','N4','NA','NK','NS','P','R','SI','SM','T','T1'),0,UnitCostUSD))*OrderCostQty))+ExtendedCostUSD as ExtendedCostUSDADJ,</SPAN></P><P><SPAN style="font-size: 13.3333px;">(ExtendedUSD-sum((Num(If(Match(LineType,'B','BF','BN','BX','CD','CM','CN','EC','F','FN','N','IA','IC','J','JN','K','L','LC','M','N','N1','N2','N3','N4','NA','NK','NS','P','R','SI','SM','T','T1'),0,UnitCostUSD))*OrderCostQty)+ExtendedCostUSD))/ExtendedUSD as MarginUSD</SPAN></P><P><SPAN style="font-size: 13.3333px;">RESIDENT F42119Temp2</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">i got this error, anyone knows why? i'm driving crazy..</SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks!<BR /></SPAN></P></BODY></HTML> Wed, 20 Dec 2017 16:28:28 GMT https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/1440301#M432217 qlikviewaf 2017-12-20T16:28:28Z Re: Invalid Expression https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/1440302#M432218 <HTML><HEAD></HEAD><BODY><P>Hi Antonio</P><P> <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN style="text-decoration: underline;">sum</SPAN>((Num(If(Match</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Group By ......</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Helvetica',sans-serif; color: black; background: white;">You could share a sample of data.</SPAN></SPAN></P></BODY></HTML> Wed, 20 Dec 2017 16:31:56 GMT https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/1440302#M432218 el_aprendiz111 2017-12-20T16:31:56Z Re: Invalid Expression https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/1440303#M432219 <HTML><HEAD></HEAD><BODY><P>Can you share full script here?</P></BODY></HTML> Thu, 21 Dec 2017 01:07:40 GMT https://community.qlik.com/t5/QlikView/Invalid-Expression/m-p/1440303#M432219 Anil_Babu_Samineni 2017-12-21T01:07:40Z