topic ytd , how can i do this ? in QlikView

topic ytd , how can i do this ? in QlikView https://community.qlik.com/t5/QlikView/ytd-how-can-i-do-this/m-p/344455#M572732 <HTML><HEAD></HEAD><BODY><P>hai     </P><P>i have 3 feilds: 1 - year 2 - month 3 - sum kg</P><P>i want to calculate the ytd for the "sum kg".</P><P>i uesed : </P><P><SPAN style="color: #0000ff; font-size: 8pt;">  </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 1;"></SPAN></SPAN></P><P>SUM<SPAN style="font-size: 8pt;">({<</SPAN><SPAN style="color: #800000; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">={'$(vMaxYear)'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">month</SPAN><SPAN style="font-size: 8pt;">={'<=$(vmaxMonth)'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">=>}{$<</SPAN><SPAN style="color: #800000; font-size: 8pt;">_Flag</SPAN><SPAN style="font-size: 8pt;">={Inv,InvAdel}>}</SPAN><SPAN style="color: #800000; font-size: 8pt;">sum kg</SPAN></P><SPAN style="font-size: 8pt;">) </SPAN><P></P><P></P><P>but it's show me only the current month.</P><P>how can i do it?</P><P></P><P>thanks'</P><P>yarin.</P></BODY></HTML> Wed, 11 Jul 2012 04:52:46 GMT Anonymous 2012-07-11T04:52:46Z ytd , how can i do this ? https://community.qlik.com/t5/QlikView/ytd-how-can-i-do-this/m-p/344455#M572732 <HTML><HEAD></HEAD><BODY><P>hai     </P><P>i have 3 feilds: 1 - year 2 - month 3 - sum kg</P><P>i want to calculate the ytd for the "sum kg".</P><P>i uesed : </P><P><SPAN style="color: #0000ff; font-size: 8pt;">  </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 1;"></SPAN></SPAN></P><P>SUM<SPAN style="font-size: 8pt;">({<</SPAN><SPAN style="color: #800000; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">={'$(vMaxYear)'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">month</SPAN><SPAN style="font-size: 8pt;">={'<=$(vmaxMonth)'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">=>}{$<</SPAN><SPAN style="color: #800000; font-size: 8pt;">_Flag</SPAN><SPAN style="font-size: 8pt;">={Inv,InvAdel}>}</SPAN><SPAN style="color: #800000; font-size: 8pt;">sum kg</SPAN></P><SPAN style="font-size: 8pt;">) </SPAN><P></P><P></P><P>but it's show me only the current month.</P><P>how can i do it?</P><P></P><P>thanks'</P><P>yarin.</P></BODY></HTML> Wed, 11 Jul 2012 04:52:46 GMT https://community.qlik.com/t5/QlikView/ytd-how-can-i-do-this/m-p/344455#M572732 Anonymous 2012-07-11T04:52:46Z