topic Re: The expression simple doesn't work !!! in QlikView https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337819#M412507 <HTML><HEAD></HEAD><BODY><P>if you have a date [Date] field maybe</P><P></P><P><STRONG>=Sum(</STRONG></P><P><STRONG>{<SPAN style="font-size: 10pt;">1&lt;[Date]={"&gt;=$(=Date(Date#('$(vMesAnoPeriodoInicial)', 'MMM YYYY')))"} &gt;} </SPAN></STRONG></P><P><STRONG>VPWMC.VALTOTAL</STRONG><SPAN style="font-size: 10pt;"><STRONG>)</STRONG></SPAN></P></BODY></HTML> Fri, 28 Apr 2017 19:48:07 GMT maxgro 2017-04-28T19:48:07Z The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337817#M412505 <HTML><HEAD></HEAD><BODY><P>Hi, fellows.</P><P></P><P>I have this expression:</P><P><BR /><STRONG>=Sum({1&lt;[Mês Ano_WMC] = {"&gt;= $(vMesAnoPeriodoInicial)"} &gt;} VPWMC.VALTOTAL)</STRONG></P><P></P><P>The field <SPAN style="font-size: 13.3333px;">[Mês Ano_WMC]</SPAN> means the Month Year of a date, such as apr 2017. </P><P></P><P>The content of the variable <SPAN style="font-size: 13.3333px;">vMesAnoPeriodoInicial is, at this time apr 2016.</SPAN></P><P></P><P>The field <SPAN style="font-size: 13.3333px;">VPWMC.VALTOTAL</SPAN> means the sale's value of a specif order.</P><P></P><P>I have sales after apr 2016. When I execute the same sum by other ways, I reach the right result. But, the result of the expression above is zero. </P><P></P><P>Does someone know what is happening?</P><P></P><P>In time, I'm in Brazil.</P><P></P><P>Thanks a lot !!!</P><P></P><P>Giovane</P></BODY></HTML> Fri, 28 Apr 2017 13:20:28 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337817#M412505 Giovane 2017-04-28T13:20:28Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337818#M412506 <HTML><HEAD></HEAD><BODY><P>Expression seems works. Can you desribe the variable</P></BODY></HTML> Fri, 28 Apr 2017 19:11:43 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337818#M412506 Anil_Babu_Samineni 2017-04-28T19:11:43Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337819#M412507 <HTML><HEAD></HEAD><BODY><P>if you have a date [Date] field maybe</P><P></P><P><STRONG>=Sum(</STRONG></P><P><STRONG>{<SPAN style="font-size: 10pt;">1&lt;[Date]={"&gt;=$(=Date(Date#('$(vMesAnoPeriodoInicial)', 'MMM YYYY')))"} &gt;} </SPAN></STRONG></P><P><STRONG>VPWMC.VALTOTAL</STRONG><SPAN style="font-size: 10pt;"><STRONG>)</STRONG></SPAN></P></BODY></HTML> Fri, 28 Apr 2017 19:48:07 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337819#M412507 maxgro 2017-04-28T19:48:07Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337820#M412508 <HTML><HEAD></HEAD><BODY><P>Joining both tips, I built the simple model bellow. First, we have the script. Second, the table as the result of the load statement. And third, three expressions that act over the data model. The second one, using IF statement, means the right result. But, first, and third expressions, that use set analysis, make no sense. Can you help me now about what is happening in the first an third expressions?</P><P></P><P></P><P><IMG alt="SetAnalysis.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162391_SetAnalysis.jpg" style="height: 349px; width: 620px;" /></P></BODY></HTML> Fri, 05 May 2017 20:20:15 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337820#M412508 Giovane 2017-05-05T20:20:15Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337821#M412509 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>Sum({1&lt;DATA={'&gt;=$(vDataPeriodoinicial)'}&gt;} VPWMC.VALTOTAL)</P></BODY></HTML> Sat, 06 May 2017 07:03:41 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337821#M412509 tresB 2017-05-06T07:03:41Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337822#M412510 <HTML><HEAD></HEAD><BODY><P>Or May be change LET to SET ??</P></BODY></HTML> Mon, 08 May 2017 05:32:50 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337822#M412510 Anil_Babu_Samineni 2017-05-08T05:32:50Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337823#M412511 <HTML><HEAD></HEAD><BODY><P>None of the tips you have done seem to work to solve my issue. I'm concluding that the combination between date, variables, and set analysis syntax, simple don't work. </P></BODY></HTML> Mon, 08 May 2017 14:13:03 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337823#M412511 Giovane 2017-05-08T14:13:03Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337824#M412512 <HTML><HEAD></HEAD><BODY><P>Try this: Sum({&lt;DATA={"&gt;='$(vDataPeriodoinicial)'"}&gt;} VPWMC.VALTOTAL)</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 08 May 2017 14:22:30 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337824#M412512 marcus_sommer 2017-05-08T14:22:30Z Re: The expression simple doesn't work !!! https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337825#M412513 <HTML><HEAD></HEAD><BODY><P>Would you able to share sample application?</P></BODY></HTML> Mon, 08 May 2017 14:26:40 GMT https://community.qlik.com/t5/QlikView/The-expression-simple-doesn-t-work/m-p/1337825#M412513 Anil_Babu_Samineni 2017-05-08T14:26:40Z