topic Disregard selections in QlikView https://community.qlik.com/t5/QlikView/Disregard-selections/m-p/965851#M952196 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using calculated dimension, which is used to show [As of Date] for Monthly Pull or [As of Date] = latest date. Now my requirement is report should Dates based on the expression, but should not be filtered based on date selection.</P><P></P><P>Now my report is showing based on dates</P><P>11/23/2015,10/30/2015, 9/30/2015 and 8/31/2015.</P><P>If I select any date other than the above mentioned dates, it is not showing any data. If I select any of the above mentioned dates, it is only showing that dates.</P><P></P><P>My requirement is, report should not effect based on filtered dates.</P><P></P><P>Monthly Pull:</P><P>10/30/2015, 9/30/2015, 8/31/2015.</P><P>Latest Date - 11/23/2015</P><P></P><P>Calculation Used:</P><P>=Aggr(Only({&lt;[Pull Type] = {'M'}&gt; + &lt;[As of Date] = {"$(vmaxDate)"}&gt;} [As of Date]),[As of Date] )</P><P></P><P>Thanks in advance!</P><P></P><P>Cheers!</P></BODY></HTML> Mon, 23 Nov 2015 16:31:14 GMT varunreddy 2015-11-23T16:31:14Z Disregard selections https://community.qlik.com/t5/QlikView/Disregard-selections/m-p/965851#M952196 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using calculated dimension, which is used to show [As of Date] for Monthly Pull or [As of Date] = latest date. Now my requirement is report should Dates based on the expression, but should not be filtered based on date selection.</P><P></P><P>Now my report is showing based on dates</P><P>11/23/2015,10/30/2015, 9/30/2015 and 8/31/2015.</P><P>If I select any date other than the above mentioned dates, it is not showing any data. If I select any of the above mentioned dates, it is only showing that dates.</P><P></P><P>My requirement is, report should not effect based on filtered dates.</P><P></P><P>Monthly Pull:</P><P>10/30/2015, 9/30/2015, 8/31/2015.</P><P>Latest Date - 11/23/2015</P><P></P><P>Calculation Used:</P><P>=Aggr(Only({&lt;[Pull Type] = {'M'}&gt; + &lt;[As of Date] = {"$(vmaxDate)"}&gt;} [As of Date]),[As of Date] )</P><P></P><P>Thanks in advance!</P><P></P><P>Cheers!</P></BODY></HTML> Mon, 23 Nov 2015 16:31:14 GMT https://community.qlik.com/t5/QlikView/Disregard-selections/m-p/965851#M952196 varunreddy 2015-11-23T16:31:14Z