topic Re: Help With Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Help-With-Set-Analysis/m-p/480534#M179579 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Try This <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum({1&lt;YourDate={'&gt;=$(=date(today() -28))'}&gt;}Data)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">.............<BR /></SPAN></P></BODY></HTML> Tue, 05 Nov 2013 12:16:31 GMT israrkhan 2013-11-05T12:16:31Z Help With Set Analysis https://community.qlik.com/t5/QlikView/Help-With-Set-Analysis/m-p/480532#M179577 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>I have an application that lists data in tables according to the selected weeks.</P><P>But I need one of the tables fixed, always with the data of the last four weeks. How can I make this selection with set analysis?</P><P>Thank you!</P></BODY></HTML> Tue, 05 Nov 2013 11:58:01 GMT https://community.qlik.com/t5/QlikView/Help-With-Set-Analysis/m-p/480532#M179577 2013-11-05T11:58:01Z Re: Help With Set Analysis https://community.qlik.com/t5/QlikView/Help-With-Set-Analysis/m-p/480533#M179578 <HTML><HEAD></HEAD><BODY><P>something like</P><P>sum({&lt;DateField={"&gt;=$(=date(WeekStart(today() -7*3)))"}&gt;}yourvalue)</P></BODY></HTML> Tue, 05 Nov 2013 12:03:44 GMT https://community.qlik.com/t5/QlikView/Help-With-Set-Analysis/m-p/480533#M179578 Clever_Anjos 2013-11-05T12:03:44Z Re: Help With Set Analysis https://community.qlik.com/t5/QlikView/Help-With-Set-Analysis/m-p/480534#M179579 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Try This <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum({1&lt;YourDate={'&gt;=$(=date(today() -28))'}&gt;}Data)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">.............<BR /></SPAN></P></BODY></HTML> Tue, 05 Nov 2013 12:16:31 GMT https://community.qlik.com/t5/QlikView/Help-With-Set-Analysis/m-p/480534#M179579 israrkhan 2013-11-05T12:16:31Z