topic Re: Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/643664#M235832 <HTML><HEAD></HEAD><BODY><P>If you want the expression to reflect selections by the user, you don't need to do anything, that's QV default behaviour.</P><P>So remove the part ', and max(I_MONTH)' [it's not correct anyway].</P><P></P><P>=SUM( IF( I_DAY &gt;25 , [Amount]))</P><P></P><P>or maybe</P><P></P><P>=SUM({&lt;I_DAY = {"&gt;25"}&gt;} [Amount])</P></BODY></HTML> Sun, 08 Jun 2014 14:33:49 GMT swuehl 2014-06-08T14:33:49Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/643663#M235831 <HTML><HEAD></HEAD><BODY><P>SUM( IF(I_DAY &gt; 25, and&nbsp; max(I_MONTH),&nbsp; [Amount]))</P><P></P><P> I have above expression in my pivot table which is not working. My expected result is to sum amount where I_DAY should be more than&nbsp; 25 th and I_MONTH should be I_Month selected by the user. Pls help me </P></BODY></HTML> Sun, 08 Jun 2014 14:12:19 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/643663#M235831 upaliwije 2014-06-08T14:12:19Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/643664#M235832 <HTML><HEAD></HEAD><BODY><P>If you want the expression to reflect selections by the user, you don't need to do anything, that's QV default behaviour.</P><P>So remove the part ', and max(I_MONTH)' [it's not correct anyway].</P><P></P><P>=SUM( IF( I_DAY &gt;25 , [Amount]))</P><P></P><P>or maybe</P><P></P><P>=SUM({&lt;I_DAY = {"&gt;25"}&gt;} [Amount])</P></BODY></HTML> Sun, 08 Jun 2014 14:33:49 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/643664#M235832 swuehl 2014-06-08T14:33:49Z