topic Re: Direct Discovery: Expression Failed in QlikView https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580131#M682767 <HTML><HEAD></HEAD><BODY><P>It should work </P></BODY></HTML> Thu, 13 Feb 2014 11:39:08 GMT sujeetsingh 2014-02-13T11:39:08Z Direct Discovery: Expression Failed https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580129#M682763 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using direct discovery for my fact table.&nbsp; using aggregate function and if condition that time failed the expression.</P><P></P><P>Ex:</P><P>Case 1&nbsp; : Sum(Amount)&nbsp; -- <SPAN style="color: #008000;"><STRONG>Working</STRONG></SPAN></P><P></P><P>Case 2&nbsp; : if(REGION='ALL',Amount,0)&nbsp; -- <SPAN style="color: #008000;"><STRONG>Working</STRONG></SPAN></P><P></P><P><STRONG>Case 3&nbsp; : Sum(if(REGION='ALL',Amount,0) ) -</STRONG>- <SPAN style="color: #ff0000;"><STRONG>Failed</STRONG></SPAN></P><P></P><P>How to solve the problem in case 3.</P><P></P><P>Thanks,</P><P>Muni.</P></BODY></HTML> Thu, 13 Feb 2014 10:54:54 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580129#M682763 muniyandi 2014-02-13T10:54:54Z Re: Direct Discover: Expression Failling https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580130#M682765 <HTML><HEAD></HEAD><BODY><P>Hi Experts, </P><P></P><P>pls , help for me.</P></BODY></HTML> Thu, 13 Feb 2014 11:25:44 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580130#M682765 muniyandi 2014-02-13T11:25:44Z Re: Direct Discovery: Expression Failed https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580131#M682767 <HTML><HEAD></HEAD><BODY><P>It should work </P></BODY></HTML> Thu, 13 Feb 2014 11:39:08 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580131#M682767 sujeetsingh 2014-02-13T11:39:08Z Re: Direct Discovery: Expression Failed https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580132#M682769 <HTML><HEAD></HEAD><BODY><P>Hi Sujeet,</P><P></P><P>just try out in direct discovery method, it's not working.</P></BODY></HTML> Thu, 13 Feb 2014 12:29:08 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-Expression-Failed/m-p/580132#M682769 muniyandi 2014-02-13T12:29:08Z