topic Re: Filtering rows in QlikView https://community.qlik.com/t5/QlikView/Filtering-rows/m-p/463064#M484114 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can assign a Variable and then include that variable in your set analysis expression .</P></BODY></HTML> Wed, 12 Jun 2013 04:03:31 GMT sujeetsingh 2013-06-12T04:03:31Z Filtering rows https://community.qlik.com/t5/QlikView/Filtering-rows/m-p/463063#M484113 <HTML><HEAD></HEAD><BODY><P>I want to filter bunch of rows in a straight table based on&nbsp; 'no of offset days'&nbsp; and show sales amount for that particular date. </P><P></P><P>So a user can select 10 (or 20 from a drop down) and table should ONLY SHOW RECORDS&nbsp; where sales_data = sales_date - 10 and sales_amount should show sales for that particular date for that record. </P><P></P><P>Something like Sum($&lt;sales_date={=$(sales_date)-$(vOffset)}&gt;Sales)</P><P></P><P>Any help will be appreciated. </P><P></P><P>Thanks. </P></BODY></HTML> Tue, 11 Jun 2013 22:12:27 GMT https://community.qlik.com/t5/QlikView/Filtering-rows/m-p/463063#M484113 2013-06-11T22:12:27Z Re: Filtering rows https://community.qlik.com/t5/QlikView/Filtering-rows/m-p/463064#M484114 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can assign a Variable and then include that variable in your set analysis expression .</P></BODY></HTML> Wed, 12 Jun 2013 04:03:31 GMT https://community.qlik.com/t5/QlikView/Filtering-rows/m-p/463064#M484114 sujeetsingh 2013-06-12T04:03:31Z