topic Re: YTD in QlikView https://community.qlik.com/t5/QlikView/YTD/m-p/1118667#M920190 <HTML><HEAD></HEAD><BODY><P>Try like this </P><P></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;YEAR={"&gt;=$(=YearStart(Today()))&lt;=$(=Today())"}&gt;}SAL)</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Wed, 11 May 2016 06:38:06 GMT avinashelite 2016-05-11T06:38:06Z YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1118664#M920187 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have source file like this,</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="263"><TBODY><TR><TD height="17" width="64">ID</TD><TD width="64">NAMES</TD><TD width="64">SAL</TD><TD width="71">YEAR</TD></TR><TR><TD align="right" height="17">111</TD><TD>RAJ</TD><TD align="right">10000</TD><TD align="right" class="xl64">10/10/2001</TD></TR><TR><TD align="right" height="17">222</TD><TD>RAJA</TD><TD align="right">20000</TD><TD align="right" class="xl64">2/20/2002</TD></TR><TR><TD align="right" height="17">333</TD><TD>SRI</TD><TD align="right">30000</TD><TD align="right" class="xl64">11/25/2003</TD></TR><TR><TD align="right" height="17">444</TD><TD>NANDU</TD><TD align="right">60000</TD><TD align="right" class="xl64">3/30/2004</TD></TR><TR><TD align="right" height="17">555</TD><TD>SAI</TD><TD align="right">70000</TD><TD align="right" class="xl64"><P>5/5/2016</P></TD></TR></TBODY></TABLE><P>I am tryingto acheive YTD but i am not getting .</P><P></P><P>Dimension :- Year</P><P></P><P>Expression:- sum({&lt;YEAR={"&gt;=$(=YearStart(=Today()))&lt;=(=Today())"}&gt;}SAL)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1118664#M920187 qlikview979 2020-11-25T16:16:04Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1118665#M920188 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;YEAR={"&gt;=$(=YearStart(Today()))&lt;=$(=Today())"}&gt;}SAL)</SPAN></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">or</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-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum({&lt;YEAR={"&gt;=$(=YearStart(max(YEAR)))&lt;=$(=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">max(YEAR)</SPAN>)"}&gt;}SAL)</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> Wed, 11 May 2016 06:33:13 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1118665#M920188 Kushal_Chawda 2016-05-11T06:33:13Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1118666#M920189 <HTML><HEAD></HEAD><BODY><P>Hi Kushal,</P><P></P><P>Thanks,I got It.</P><P></P><P></P><P>Regards,<BR />Mahesh</P></BODY></HTML> Wed, 11 May 2016 06:37:58 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1118666#M920189 qlikview979 2016-05-11T06:37:58Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1118667#M920190 <HTML><HEAD></HEAD><BODY><P>Try like this </P><P></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;YEAR={"&gt;=$(=YearStart(Today()))&lt;=$(=Today())"}&gt;}SAL)</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Wed, 11 May 2016 06:38:06 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1118667#M920190 avinashelite 2016-05-11T06:38:06Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1118668#M920191 <HTML><HEAD></HEAD><BODY><P>Not a problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 11 May 2016 06:40:59 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1118668#M920191 Kushal_Chawda 2016-05-11T06:40:59Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1118669#M920192 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks, Avinash</P><P></P><P></P><P>Regards,<BR />Mahesh</P></BODY></HTML> Wed, 11 May 2016 06:52:51 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1118669#M920192 qlikview979 2016-05-11T06:52:51Z Re: YTD https://community.qlik.com/t5/QlikView/YTD/m-p/1118670#M920193 <HTML><HEAD></HEAD><BODY><P>np problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 11 May 2016 08:26:19 GMT https://community.qlik.com/t5/QlikView/YTD/m-p/1118670#M920193 avinashelite 2016-05-11T08:26:19Z