topic expression is right ? in QlikView https://community.qlik.com/t5/QlikView/expression-is-right/m-p/33333#M5627 <HTML><HEAD></HEAD><BODY><P>(Sum (if("Date d'entrée") &lt; ('31/01')&nbsp; and GetFieldSelections(year))</P><P>and </P><P>(Sum ( if ([Date de sortie]) =&gt; ('01/01') and GetFieldSelections(year))))</P></BODY></HTML> Thu, 01 Mar 2018 08:54:48 GMT Anonymous 2018-03-01T08:54:48Z expression is right ? https://community.qlik.com/t5/QlikView/expression-is-right/m-p/33333#M5627 <HTML><HEAD></HEAD><BODY><P>(Sum (if("Date d'entrée") &lt; ('31/01')&nbsp; and GetFieldSelections(year))</P><P>and </P><P>(Sum ( if ([Date de sortie]) =&gt; ('01/01') and GetFieldSelections(year))))</P></BODY></HTML> Thu, 01 Mar 2018 08:54:48 GMT https://community.qlik.com/t5/QlikView/expression-is-right/m-p/33333#M5627 Anonymous 2018-03-01T08:54:48Z Re: expression is right ? https://community.qlik.com/t5/QlikView/expression-is-right/m-p/33334#M5628 <HTML><HEAD></HEAD><BODY><P>If these are date fields,</P><P></P><P>=Sum({&lt;<SPAN style="display: inline !important; float: none; background-color: transparent; color: #3d3d3d; font-family: 'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">[<SPAN style="display: inline !important; float: none; background-color: transparent; color: #3d3d3d; font-family: 'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">Date d'entrée</SPAN>]={"&lt;$(=MakeDate(GetFieldSelections(year),01,31))"},<SPAN style="display: inline !important; float: none; background-color: transparent; color: #3d3d3d; font-family: 'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">[Date de sortie]={<SPAN style="display: inline !important; float: none; background-color: transparent; color: #3d3d3d; font-family: 'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">"&gt;=$(=MakeDate(GetFieldSelections(year),01,31))"</SPAN>}</SPAN></SPAN>&gt;} SomeAmt)</P></BODY></HTML> Sun, 04 Mar 2018 15:34:51 GMT https://community.qlik.com/t5/QlikView/expression-is-right/m-p/33334#M5628 jwjackso 2018-03-04T15:34:51Z