topic Restricting Dimensions in QlikView https://community.qlik.com/t5/QlikView/Restricting-Dimensions/m-p/389592#M1152467 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I feel there is going to be a very obvious answer to my requirement.</P><P></P><P>I have a pivot-table with years across the top; if I select a year from a listbox I want the pivot table to only show that year and years after the selected year.&nbsp; Is it possible?&nbsp; if so, how would i do that?</P><P></P><P>Many thanks in advance.</P><P>C</P></BODY></HTML> Tue, 23 Apr 2013 10:38:05 GMT 2013-04-23T10:38:05Z Restricting Dimensions https://community.qlik.com/t5/QlikView/Restricting-Dimensions/m-p/389592#M1152467 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I feel there is going to be a very obvious answer to my requirement.</P><P></P><P>I have a pivot-table with years across the top; if I select a year from a listbox I want the pivot table to only show that year and years after the selected year.&nbsp; Is it possible?&nbsp; if so, how would i do that?</P><P></P><P>Many thanks in advance.</P><P>C</P></BODY></HTML> Tue, 23 Apr 2013 10:38:05 GMT https://community.qlik.com/t5/QlikView/Restricting-Dimensions/m-p/389592#M1152467 2013-04-23T10:38:05Z Re: Restricting Dimensions https://community.qlik.com/t5/QlikView/Restricting-Dimensions/m-p/389593#M1152468 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try this expression,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum({&lt;Year = {"&gt;=$(=max(Year))"}&gt;}Sales)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 23 Apr 2013 10:41:51 GMT https://community.qlik.com/t5/QlikView/Restricting-Dimensions/m-p/389593#M1152468 kaushiknsolanki 2013-04-23T10:41:51Z