https://community.qlik.com/t5/QlikView/Use-Calculated-Dimension-to-restrict-the-date/m-p/1667850#M728448 <P>Hi,</P><P>maybe use something like this</P><P>=Aggr(If(Rank(Date)&lt;=2,Date),Date)</P> Tue, 21 Jan 2020 17:02:13 GMT StarinieriG 2020-01-21T17:02:13Z https://community.qlik.com/t5/QlikView/Use-Calculated-Dimension-to-restrict-the-date/m-p/1667770#M728447 <P>Hi All,</P><P>My Data is&nbsp;</P><TABLE><TBODY><TR><TD>Value</TD><TD>Date</TD><TD>Regon</TD></TR><TR><TD>1</TD><TD>8/31/2018</TD><TD>N</TD></TR><TR><TD>1</TD><TD>9/30/2018</TD><TD>S</TD></TR><TR><TD>1</TD><TD>10/31/2018</TD><TD>N</TD></TR><TR><TD>0</TD><TD>11/30/2018</TD><TD>S</TD></TR><TR><TD>1</TD><TD>12/31/2018</TD><TD>N</TD></TR><TR><TD>0</TD><TD>1/31/2019</TD><TD>S</TD></TR><TR><TD>1</TD><TD>2/28/2019</TD><TD>N</TD></TR><TR><TD>0</TD><TD>3/31/2019</TD><TD>S</TD></TR><TR><TD>1</TD><TD>4/30/2019</TD><TD>N</TD></TR><TR><TD>0</TD><TD>5/31/2019</TD><TD>S</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected output in pivot table. My requirement is to restrict the Date&nbsp; for last 2 dates using the <U><STRONG>calculated dimension&nbsp;</STRONG></U> . Please suggest</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>&nbsp;</TD><TD>Region</TD><TD>N</TD><TD>S</TD></TR><TR><TD>&nbsp;</TD><TD>Date</TD><TD>4/30/2019</TD><TD>5/31/2019</TD><TD>4/30/2019</TD><TD>5/31/2019</TD></TR><TR><TD>Value</TD><TD>&nbsp;</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance.</P> Sat, 16 Nov 2024 19:15:53 GMT https://community.qlik.com/t5/QlikView/Use-Calculated-Dimension-to-restrict-the-date/m-p/1667770#M728447 priya945 2024-11-16T19:15:53Z https://community.qlik.com/t5/QlikView/Use-Calculated-Dimension-to-restrict-the-date/m-p/1667850#M728448 <P>Hi,</P><P>maybe use something like this</P><P>=Aggr(If(Rank(Date)&lt;=2,Date),Date)</P> Tue, 21 Jan 2020 17:02:13 GMT https://community.qlik.com/t5/QlikView/Use-Calculated-Dimension-to-restrict-the-date/m-p/1667850#M728448 StarinieriG 2020-01-21T17:02:13Z