topic Re: set analysis (date) in QlikView https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/659648#M1062135 <HTML><HEAD></HEAD><BODY><P><BR />tnx!</P><P>but i found a solution with a variable and its worked!!</P><P></P><P><span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P></BODY></HTML> Sun, 05 Oct 2014 07:31:46 GMT adiarnon 2014-10-05T07:31:46Z set analysis (date) https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/659646#M1062133 <HTML><HEAD></HEAD><BODY><P>what wrong in my expression-</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year_Month</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"(Year_Month&lt;year(Today())&amp;num(month(today())))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">BudgetCurrentBook_UNIT</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">tnx adi</SPAN></P></BODY></HTML> Sun, 05 Oct 2014 06:10:47 GMT https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/659646#M1062133 adiarnon 2014-10-05T06:10:47Z Re: set analysis (date) https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/659647#M1062134 <HTML><HEAD></HEAD><BODY><P>Do you want to calculate sum when Year_Month is less than today's Year &amp; Month? Then try this</P><P></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">({&lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Year_Month</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">={</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">"&lt;$(=year(Today())&amp;num(month(today())))"</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">}&gt;}</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">BudgetCurrentBook_UNIT</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</SPAN></P></BODY></HTML> Sun, 05 Oct 2014 06:26:01 GMT https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/659647#M1062134 anbu1984 2014-10-05T06:26:01Z Re: set analysis (date) https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/659648#M1062135 <HTML><HEAD></HEAD><BODY><P><BR />tnx!</P><P>but i found a solution with a variable and its worked!!</P><P></P><P><span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P></BODY></HTML> Sun, 05 Oct 2014 07:31:46 GMT https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/659648#M1062135 adiarnon 2014-10-05T07:31:46Z