https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-aggr-not-working-Please-help-with-set/m-p/2060192#M1223265 <P>Hi All ,</P> <P>What should be set expression to achieve below result :</P> <P><STRONG>Source :</STRONG></P> <TABLE width="195"> <TBODY> <TR> <TD width="45">Client</TD> <TD width="37">target</TD> <TD width="32">profit</TD> <TD width="81">date_of_sale</TD> </TR> <TR> <TD>C1</TD> <TD>100</TD> <TD>20</TD> <TD>17/03/23</TD> </TR> <TR> <TD>C1</TD> <TD>200</TD> <TD>50</TD> <TD>22/03/23</TD> </TR> <TR> <TD>C1</TD> <TD>150</TD> <TD>60</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C2</TD> <TD>50</TD> <TD>10</TD> <TD>12/3/2023</TD> </TR> <TR> <TD>C2</TD> <TD>40</TD> <TD>15</TD> <TD>2/2/2023</TD> </TR> <TR> <TD>C3</TD> <TD>30</TD> <TD>5</TD> <TD>1/2/2023</TD> </TR> <TR> <TD>C3</TD> <TD>70</TD> <TD>30</TD> <TD>12/12/2022</TD> </TR> </TBODY> </TABLE> <P><STRONG>output1&nbsp;</STRONG></P> <TABLE width="323"> <TBODY> <TR> <TD width="45">Client</TD> <TD width="37">target</TD> <TD width="32">proft</TD> <TD width="81">date_of_sale</TD> <TD width="64"><FONT color="#FF0000">d1</FONT></TD> <TD width="64">d2</TD> </TR> <TR> <TD>C1</TD> <TD>100</TD> <TD>20</TD> <TD>17/03/23</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C1</TD> <TD>200</TD> <TD>50</TD> <TD>22/03/23</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C1</TD> <TD>150</TD> <TD>60</TD> <TD>10/2/2023</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C2</TD> <TD>50</TD> <TD>10</TD> <TD>12/3/2023</TD> <TD>12/3/2023</TD> <TD>2/2/2023</TD> </TR> <TR> <TD>C2</TD> <TD>40</TD> <TD>15</TD> <TD>2/2/2023</TD> <TD>12/3/2023</TD> <TD>2/2/2023</TD> </TR> <TR> <TD>C3</TD> <TD>30</TD> <TD>5</TD> <TD>1/2/2023</TD> <TD>1/2/2023</TD> <TD>12/12/2022</TD> </TR> <TR> <TD>C3</TD> <TD>70</TD> <TD>30</TD> <TD>12/12/2022</TD> <TD>1/2/2023</TD> <TD>12/12/2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I tried this expression , which didn't work -&nbsp;<FONT color="#FF0000"><STRONG>Aggr(max(TOTAL &lt;target,proft&gt; date_of_sale),Client) for d1</STRONG></FONT></P> <P><FONT color="#0000FF"><STRONG>I tried populating max of date from each client . Hence i tried ignoring dimension target,profit to get max of date aggregated over client .</STRONG></FONT></P> <P><STRONG>Output2&nbsp;</STRONG></P> <TABLE width="636"> <TBODY> <TR> <TD width="64">Client</TD> <TD width="64">max_date</TD> <TD width="64">min_date</TD> <TD width="113">max_date_target</TD> <TD width="111">min_date_target</TD> <TD width="111">max_date_profit</TD> <TD width="109">min_date_profit</TD> </TR> <TR> <TD>C1</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> <TD>200</TD> <TD>150</TD> <TD>50</TD> <TD>60</TD> </TR> <TR> <TD>C2</TD> <TD>12/3/2023</TD> <TD>2/2/2023</TD> <TD>50</TD> <TD>40</TD> <TD>10</TD> <TD>15</TD> </TR> <TR> <TD>C3</TD> <TD>1/2/2023</TD> <TD>12/12/2022</TD> <TD>30</TD> <TD>70</TD> <TD>5</TD> <TD>30</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you All&nbsp;</P> Thu, 13 Apr 2023 16:47:33 GMT prahlad_infy 2023-04-13T16:47:33Z https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-aggr-not-working-Please-help-with-set/m-p/2060192#M1223265 <P>Hi All ,</P> <P>What should be set expression to achieve below result :</P> <P><STRONG>Source :</STRONG></P> <TABLE width="195"> <TBODY> <TR> <TD width="45">Client</TD> <TD width="37">target</TD> <TD width="32">profit</TD> <TD width="81">date_of_sale</TD> </TR> <TR> <TD>C1</TD> <TD>100</TD> <TD>20</TD> <TD>17/03/23</TD> </TR> <TR> <TD>C1</TD> <TD>200</TD> <TD>50</TD> <TD>22/03/23</TD> </TR> <TR> <TD>C1</TD> <TD>150</TD> <TD>60</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C2</TD> <TD>50</TD> <TD>10</TD> <TD>12/3/2023</TD> </TR> <TR> <TD>C2</TD> <TD>40</TD> <TD>15</TD> <TD>2/2/2023</TD> </TR> <TR> <TD>C3</TD> <TD>30</TD> <TD>5</TD> <TD>1/2/2023</TD> </TR> <TR> <TD>C3</TD> <TD>70</TD> <TD>30</TD> <TD>12/12/2022</TD> </TR> </TBODY> </TABLE> <P><STRONG>output1&nbsp;</STRONG></P> <TABLE width="323"> <TBODY> <TR> <TD width="45">Client</TD> <TD width="37">target</TD> <TD width="32">proft</TD> <TD width="81">date_of_sale</TD> <TD width="64"><FONT color="#FF0000">d1</FONT></TD> <TD width="64">d2</TD> </TR> <TR> <TD>C1</TD> <TD>100</TD> <TD>20</TD> <TD>17/03/23</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C1</TD> <TD>200</TD> <TD>50</TD> <TD>22/03/23</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C1</TD> <TD>150</TD> <TD>60</TD> <TD>10/2/2023</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> </TR> <TR> <TD>C2</TD> <TD>50</TD> <TD>10</TD> <TD>12/3/2023</TD> <TD>12/3/2023</TD> <TD>2/2/2023</TD> </TR> <TR> <TD>C2</TD> <TD>40</TD> <TD>15</TD> <TD>2/2/2023</TD> <TD>12/3/2023</TD> <TD>2/2/2023</TD> </TR> <TR> <TD>C3</TD> <TD>30</TD> <TD>5</TD> <TD>1/2/2023</TD> <TD>1/2/2023</TD> <TD>12/12/2022</TD> </TR> <TR> <TD>C3</TD> <TD>70</TD> <TD>30</TD> <TD>12/12/2022</TD> <TD>1/2/2023</TD> <TD>12/12/2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I tried this expression , which didn't work -&nbsp;<FONT color="#FF0000"><STRONG>Aggr(max(TOTAL &lt;target,proft&gt; date_of_sale),Client) for d1</STRONG></FONT></P> <P><FONT color="#0000FF"><STRONG>I tried populating max of date from each client . Hence i tried ignoring dimension target,profit to get max of date aggregated over client .</STRONG></FONT></P> <P><STRONG>Output2&nbsp;</STRONG></P> <TABLE width="636"> <TBODY> <TR> <TD width="64">Client</TD> <TD width="64">max_date</TD> <TD width="64">min_date</TD> <TD width="113">max_date_target</TD> <TD width="111">min_date_target</TD> <TD width="111">max_date_profit</TD> <TD width="109">min_date_profit</TD> </TR> <TR> <TD>C1</TD> <TD>22/03/23</TD> <TD>10/2/2023</TD> <TD>200</TD> <TD>150</TD> <TD>50</TD> <TD>60</TD> </TR> <TR> <TD>C2</TD> <TD>12/3/2023</TD> <TD>2/2/2023</TD> <TD>50</TD> <TD>40</TD> <TD>10</TD> <TD>15</TD> </TR> <TR> <TD>C3</TD> <TD>1/2/2023</TD> <TD>12/12/2022</TD> <TD>30</TD> <TD>70</TD> <TD>5</TD> <TD>30</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you All&nbsp;</P> Thu, 13 Apr 2023 16:47:33 GMT https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-aggr-not-working-Please-help-with-set/m-p/2060192#M1223265 prahlad_infy 2023-04-13T16:47:33Z