topic Re: Using Greater than variable in set analysis in QlikView https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805484#M1020081 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Sum({$&lt; Year = {$(#vYear)}, Quarter = {"&gt;=$(#vQuarter)} , Month = {&lt;=$(#vMonth)}&gt;} sales)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Fri, 27 Mar 2015 09:55:04 GMT 2015-03-27T09:55:04Z Using Greater than variable in set analysis https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805483#M1020080 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Hi experts,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">how to use&nbsp; Greater than variable in set analysis??was it fine??</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Sum({$&lt; Year = {$(#vYear)}, Quarter = {$(#vQuarter)} , Month = {&gt;=$(#vMonth)}&gt;} sales)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">thanks</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Fri, 27 Mar 2015 09:50:06 GMT https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805483#M1020080 2015-03-27T09:50:06Z Re: Using Greater than variable in set analysis https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805484#M1020081 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Sum({$&lt; Year = {$(#vYear)}, Quarter = {"&gt;=$(#vQuarter)} , Month = {&lt;=$(#vMonth)}&gt;} sales)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Fri, 27 Mar 2015 09:55:04 GMT https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805484#M1020081 2015-03-27T09:55:04Z Re: Using Greater than variable in set analysis https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805485#M1020082 <HTML><HEAD></HEAD><BODY><P>What you want to achieve end result?</P></BODY></HTML> Fri, 27 Mar 2015 09:55:25 GMT https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805485#M1020082 MK_QSL 2015-03-27T09:55:25Z Re: Using Greater than variable in set analysis https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805486#M1020083 <HTML><HEAD></HEAD><BODY><P>Follow these </P><P></P><P><A href="https://community.qlik.com/thread/137354">Set analysis with greater/less than or equal to a variable</A></P><P></P><P><A href="https://community.qlik.com/thread/57793">Greater than or equal to a variable (set analysis)</A></P></BODY></HTML> Fri, 27 Mar 2015 09:55:37 GMT https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805486#M1020083 sujeetsingh 2015-03-27T09:55:37Z Re: Using Greater than variable in set analysis https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805487#M1020084 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>I want to achieve QTD sales information.</P></BODY></HTML> Fri, 27 Mar 2015 09:56:39 GMT https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805487#M1020084 2015-03-27T09:56:39Z Re: Using Greater than variable in set analysis https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805488#M1020085 <HTML><HEAD></HEAD><BODY><P>=SUM({&lt;Month = , Quarter =, Week = , Year= {'$(=max(Year))'}, Date = {"&gt;=$(=Date(QuarterStart(Max(Date))))&lt;=$(=Date(QuarterEnd(Max(Date))))"}&gt;}Sales)</P></BODY></HTML> Fri, 27 Mar 2015 10:05:34 GMT https://community.qlik.com/t5/QlikView/Using-Greater-than-variable-in-set-analysis/m-p/805488#M1020085 MK_QSL 2015-03-27T10:05:34Z