topic Re: General Question in App Development https://community.qlik.com/t5/App-Development/General-Question/m-p/2004534#M83155 <P>thanks it work</P> Tue, 15 Nov 2022 10:03:11 GMT elmelavi 2022-11-15T10:03:11Z General Question https://community.qlik.com/t5/App-Development/General-Question/m-p/1969053#M79938 <P>Hay All,</P> <P>&nbsp;</P> <P>Can SomeOne Tell Me How can I write an Set Analisys&nbsp;</P> <P>Expression That Take The Max Data Between Two Dimmension</P> <P>For Example:</P> <P>Attached Data</P> <P>&nbsp;</P> <P>I Need To Calculate The Minimum Data By LoadID And Month</P> <P>And The Requeir&nbsp; Result Will Be</P> <TABLE width="302"> <TBODY> <TR> <TD width="79">Date</TD> <TD width="72">Month</TD> <TD width="72">LoadID</TD> <TD width="79">MinDate</TD> </TR> <TR> <TD>08/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>09/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>10/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>11/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>12/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>13/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>14/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>15/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>16/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>17/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>18/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>19/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>20/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>21/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>22/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>23/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>24/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>25/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>26/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>27/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>28/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>29/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>30/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>31/01/2022</TD> <TD>1</TD> <TD>5678</TD> <TD>08/01/2022</TD> </TR> <TR> <TD>13/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>14/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>15/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>16/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>17/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>18/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>19/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>20/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>21/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>22/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>23/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>24/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>25/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>26/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>27/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>28/02/2022</TD> <TD>2</TD> <TD>5678</TD> <TD>13/02/2022</TD> </TR> <TR> <TD>09/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>10/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>11/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>12/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>13/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>14/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>15/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>16/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>17/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>18/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>19/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>20/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>21/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>22/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>23/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>24/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>25/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>26/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>27/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>28/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>29/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>30/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>31/03/2022</TD> <TD>3</TD> <TD>5678</TD> <TD>09/03/2022</TD> </TR> <TR> <TD>06/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>07/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>08/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>09/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>10/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>11/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>12/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>13/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>14/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>15/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>16/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>17/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>18/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>19/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>20/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>21/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>22/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>23/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>24/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>25/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>26/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>27/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>28/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>29/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>30/04/2022</TD> <TD>4</TD> <TD>5678</TD> <TD>06/04/2022</TD> </TR> <TR> <TD>01/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>02/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>03/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>04/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>05/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>06/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>07/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>08/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>09/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>10/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>11/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>12/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>13/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>14/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>15/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>16/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>17/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>18/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>19/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>20/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>21/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>22/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>23/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>24/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>25/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>26/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>27/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>28/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>29/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>30/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>31/05/2022</TD> <TD>5</TD> <TD>5678</TD> <TD>01/05/2022</TD> </TR> <TR> <TD>02/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>03/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>04/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>05/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>06/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>07/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>08/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>09/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>10/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>11/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>12/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>13/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>14/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>15/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>16/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>17/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>18/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>19/06/2022</TD> <TD>6</TD> <TD>5678</TD> <TD>02/06/2022</TD> </TR> <TR> <TD>12/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>13/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>14/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>15/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>16/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>17/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>18/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>19/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>20/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>21/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>22/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>23/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>24/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>25/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>26/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>27/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>28/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>29/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>30/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>31/01/2022</TD> <TD>1</TD> <TD>1234</TD> <TD>12/01/2022</TD> </TR> <TR> <TD>20/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>21/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>22/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>23/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>24/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>25/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>26/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>27/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>28/02/2022</TD> <TD>2</TD> <TD>1234</TD> <TD>20/02/2022</TD> </TR> <TR> <TD>18/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>19/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>20/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>21/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>22/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>23/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>24/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>25/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>26/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>27/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>28/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>29/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>30/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>31/03/2022</TD> <TD>3</TD> <TD>1234</TD> <TD>18/03/2022</TD> </TR> <TR> <TD>17/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>18/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>19/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>20/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>21/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>22/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>23/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>24/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>25/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>26/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>27/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>28/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>29/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>30/04/2022</TD> <TD>4</TD> <TD>1234</TD> <TD>17/04/2022</TD> </TR> <TR> <TD>10/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>11/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>12/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>13/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>14/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>15/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>16/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>17/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>18/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>19/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>20/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>21/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>22/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>23/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>24/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>25/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>26/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>27/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>28/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>29/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>30/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>31/05/2022</TD> <TD>5</TD> <TD>1234</TD> <TD>10/05/2022</TD> </TR> <TR> <TD>10/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>11/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>12/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>13/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>14/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>15/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>16/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>17/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>18/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> <TR> <TD>19/06/2022</TD> <TD>6</TD> <TD>1234</TD> <TD>10/06/2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>THE MIN DATE WILL BE BY LOADID AND MONTH</P> <P>&nbsp;</P> Tue, 16 Aug 2022 09:58:34 GMT https://community.qlik.com/t5/App-Development/General-Question/m-p/1969053#M79938 elmelavi 2022-08-16T09:58:34Z Re: General Question https://community.qlik.com/t5/App-Development/General-Question/m-p/1969219#M79958 <P>There is no set analysis needed else it's just related to the aggregation. By a chart with Month and LoadID as dimension you may use:</P> <P>min(Date)</P> <P>- Marcus</P> Tue, 16 Aug 2022 14:09:12 GMT https://community.qlik.com/t5/App-Development/General-Question/m-p/1969219#M79958 marcus_sommer 2022-08-16T14:09:12Z Re: General Question https://community.qlik.com/t5/App-Development/General-Question/m-p/2004534#M83155 <P>thanks it work</P> Tue, 15 Nov 2022 10:03:11 GMT https://community.qlik.com/t5/App-Development/General-Question/m-p/2004534#M83155 elmelavi 2022-11-15T10:03:11Z