topic Custom Report in QlikView https://community.qlik.com/t5/QlikView/Custom-Report/m-p/600493#M1110079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement for Custom Report functionality in QV. I have created a custom report, but I want to limit my year variable to show only latest 2 years of data, however other sections of the dashboard needs all years. Can I restrict that in Custom Report.</P><P>Attached is tyhe sample QVW</P><P>Any help would be appreciated.</P><P>Simky</P></BODY></HTML> Wed, 05 Mar 2014 01:16:42 GMT 2014-03-05T01:16:42Z Custom Report https://community.qlik.com/t5/QlikView/Custom-Report/m-p/600493#M1110079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement for Custom Report functionality in QV. I have created a custom report, but I want to limit my year variable to show only latest 2 years of data, however other sections of the dashboard needs all years. Can I restrict that in Custom Report.</P><P>Attached is tyhe sample QVW</P><P>Any help would be appreciated.</P><P>Simky</P></BODY></HTML> Wed, 05 Mar 2014 01:16:42 GMT https://community.qlik.com/t5/QlikView/Custom-Report/m-p/600493#M1110079 2014-03-05T01:16:42Z Re: Custom Report https://community.qlik.com/t5/QlikView/Custom-Report/m-p/600494#M1110084 <HTML><HEAD></HEAD><BODY><P>you can do that</P><P></P><P>Variable1=max({1}Year)&amp;chr(39)&amp;','&amp;chr(39)&amp;max({1}Year-1)</P><P></P><P>Sum({&lt;Year={'$(Variable1)'}&gt;}Sales)</P><P></P><P><IMG alt="Custome report.jpg" class="jive-image" src="/legacyfs/online/54279_Custome report.jpg" style="width: 620px; height: 246px;" /></P></BODY></HTML> Wed, 05 Mar 2014 01:47:45 GMT https://community.qlik.com/t5/QlikView/Custom-Report/m-p/600494#M1110084 chiru_thota 2014-03-05T01:47:45Z Re: Custom Report https://community.qlik.com/t5/QlikView/Custom-Report/m-p/600495#M1110093 <HTML><HEAD></HEAD><BODY><P>You need to build ad-Hoc reporting </P><P></P><P>PFA Sample</P><P></P><P>Vikas</P></BODY></HTML> Wed, 05 Mar 2014 03:55:06 GMT https://community.qlik.com/t5/QlikView/Custom-Report/m-p/600495#M1110093 vikasmahajan 2014-03-05T03:55:06Z