topic Issue with Set Analysis Not Ignoring Current Selections in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Set-Analysis-Not-Ignoring-Current-Selections/m-p/488654#M483715 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've been having some trouble with a set analysis not ignoring select date ranges. My goal is to rank a selected company's sales for last month against all over companies with the following statement:</P><P></P><P>=aggr(rank (sum({1&lt;&nbsp; [Date] = {"=InMonth([Date], Today(),-1)"}&gt;}[Sales])),[Company])</P><P></P><P>It's properly ranking the sales for the selected company against all other companies, unless I select a date range exlcuding last month (May of 2013). I thought that the "1" at the beginning would ignore the date selections, but it doesn't.</P><P></P><P>I've provided a sample QV document, the error occures if I select either 4/1/2013 or 6/1/2013 since it falls outside the date range and I love the company's rank.</P><P></P><P>Any help would be appreciated. Thanks!</P></BODY></HTML> Wed, 19 Jun 2013 17:29:33 GMT 2013-06-19T17:29:33Z Issue with Set Analysis Not Ignoring Current Selections https://community.qlik.com/t5/QlikView/Issue-with-Set-Analysis-Not-Ignoring-Current-Selections/m-p/488654#M483715 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've been having some trouble with a set analysis not ignoring select date ranges. My goal is to rank a selected company's sales for last month against all over companies with the following statement:</P><P></P><P>=aggr(rank (sum({1&lt;&nbsp; [Date] = {"=InMonth([Date], Today(),-1)"}&gt;}[Sales])),[Company])</P><P></P><P>It's properly ranking the sales for the selected company against all other companies, unless I select a date range exlcuding last month (May of 2013). I thought that the "1" at the beginning would ignore the date selections, but it doesn't.</P><P></P><P>I've provided a sample QV document, the error occures if I select either 4/1/2013 or 6/1/2013 since it falls outside the date range and I love the company's rank.</P><P></P><P>Any help would be appreciated. Thanks!</P></BODY></HTML> Wed, 19 Jun 2013 17:29:33 GMT https://community.qlik.com/t5/QlikView/Issue-with-Set-Analysis-Not-Ignoring-Current-Selections/m-p/488654#M483715 2013-06-19T17:29:33Z