topic How to create expression for finding selection of weeks? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-expression-for-finding-selection-of-weeks/m-p/174364#M43219 <HTML><HEAD></HEAD><BODY><P><I></I></P><P></P><P></P><P>hello there,</P><P>I am planning to show the sum of sale amount for a table of weeks.</P><P>I have a table of week numbers . I want to find the sum amount for the selection of weeks I choose.</P><P>So I created 2 variables.</P><P>vminWeek= min(week_num)</P><P>vmaxWeek.= max(week_num)</P><P>How do I calculate the sum between these 2 weeks? Please help.</P><P></P><P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 18 Jan 2011 23:03:40 GMT 2011-01-18T23:03:40Z How to create expression for finding selection of weeks? https://community.qlik.com/t5/QlikView/How-to-create-expression-for-finding-selection-of-weeks/m-p/174364#M43219 <HTML><HEAD></HEAD><BODY><P><I></I></P><P></P><P></P><P>hello there,</P><P>I am planning to show the sum of sale amount for a table of weeks.</P><P>I have a table of week numbers . I want to find the sum amount for the selection of weeks I choose.</P><P>So I created 2 variables.</P><P>vminWeek= min(week_num)</P><P>vmaxWeek.= max(week_num)</P><P>How do I calculate the sum between these 2 weeks? Please help.</P><P></P><P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 18 Jan 2011 23:03:40 GMT https://community.qlik.com/t5/QlikView/How-to-create-expression-for-finding-selection-of-weeks/m-p/174364#M43219 2011-01-18T23:03:40Z How to create expression for finding selection of weeks? https://community.qlik.com/t5/QlikView/How-to-create-expression-for-finding-selection-of-weeks/m-p/174365#M43220 <HTML><HEAD></HEAD><BODY><P>Is this correct ?? sum({&lt;ad_wk_num = {'&gt;=$(=prev_wk)&lt;=$(=prev_wk)'}&gt;}sale_amt)</P></BODY></HTML> Tue, 18 Jan 2011 23:11:00 GMT https://community.qlik.com/t5/QlikView/How-to-create-expression-for-finding-selection-of-weeks/m-p/174365#M43220 2011-01-18T23:11:00Z