Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
elmelavi
Contributor III
Contributor III
‎2022-08-16 05:58 AM

General Question

Hay All,

 

Can SomeOne Tell Me How can I write an Set Analisys 

Expression That Take The Max Data Between Two Dimmension

For Example:

Attached Data

 

I Need To Calculate The Minimum Data By LoadID And Month

And The Requeir  Result Will Be

Date Month LoadID MinDate
08/01/2022 1 5678 08/01/2022
09/01/2022 1 5678 08/01/2022
10/01/2022 1 5678 08/01/2022
11/01/2022 1 5678 08/01/2022
12/01/2022 1 5678 08/01/2022
13/01/2022 1 5678 08/01/2022
14/01/2022 1 5678 08/01/2022
15/01/2022 1 5678 08/01/2022
16/01/2022 1 5678 08/01/2022
17/01/2022 1 5678 08/01/2022
18/01/2022 1 5678 08/01/2022
19/01/2022 1 5678 08/01/2022
20/01/2022 1 5678 08/01/2022
21/01/2022 1 5678 08/01/2022
22/01/2022 1 5678 08/01/2022
23/01/2022 1 5678 08/01/2022
24/01/2022 1 5678 08/01/2022
25/01/2022 1 5678 08/01/2022
26/01/2022 1 5678 08/01/2022
27/01/2022 1 5678 08/01/2022
28/01/2022 1 5678 08/01/2022
29/01/2022 1 5678 08/01/2022
30/01/2022 1 5678 08/01/2022
31/01/2022 1 5678 08/01/2022
13/02/2022 2 5678 13/02/2022
14/02/2022 2 5678 13/02/2022
15/02/2022 2 5678 13/02/2022
16/02/2022 2 5678 13/02/2022
17/02/2022 2 5678 13/02/2022
18/02/2022 2 5678 13/02/2022
19/02/2022 2 5678 13/02/2022
20/02/2022 2 5678 13/02/2022
21/02/2022 2 5678 13/02/2022
22/02/2022 2 5678 13/02/2022
23/02/2022 2 5678 13/02/2022
24/02/2022 2 5678 13/02/2022
25/02/2022 2 5678 13/02/2022
26/02/2022 2 5678 13/02/2022
27/02/2022 2 5678 13/02/2022
28/02/2022 2 5678 13/02/2022
09/03/2022 3 5678 09/03/2022
10/03/2022 3 5678 09/03/2022
11/03/2022 3 5678 09/03/2022
12/03/2022 3 5678 09/03/2022
13/03/2022 3 5678 09/03/2022
14/03/2022 3 5678 09/03/2022
15/03/2022 3 5678 09/03/2022
16/03/2022 3 5678 09/03/2022
17/03/2022 3 5678 09/03/2022
18/03/2022 3 5678 09/03/2022
19/03/2022 3 5678 09/03/2022
20/03/2022 3 5678 09/03/2022
21/03/2022 3 5678 09/03/2022
22/03/2022 3 5678 09/03/2022
23/03/2022 3 5678 09/03/2022
24/03/2022 3 5678 09/03/2022
25/03/2022 3 5678 09/03/2022
26/03/2022 3 5678 09/03/2022
27/03/2022 3 5678 09/03/2022
28/03/2022 3 5678 09/03/2022
29/03/2022 3 5678 09/03/2022
30/03/2022 3 5678 09/03/2022
31/03/2022 3 5678 09/03/2022
06/04/2022 4 5678 06/04/2022
07/04/2022 4 5678 06/04/2022
08/04/2022 4 5678 06/04/2022
09/04/2022 4 5678 06/04/2022
10/04/2022 4 5678 06/04/2022
11/04/2022 4 5678 06/04/2022
12/04/2022 4 5678 06/04/2022
13/04/2022 4 5678 06/04/2022
14/04/2022 4 5678 06/04/2022
15/04/2022 4 5678 06/04/2022
16/04/2022 4 5678 06/04/2022
17/04/2022 4 5678 06/04/2022
18/04/2022 4 5678 06/04/2022
19/04/2022 4 5678 06/04/2022
20/04/2022 4 5678 06/04/2022
21/04/2022 4 5678 06/04/2022
22/04/2022 4 5678 06/04/2022
23/04/2022 4 5678 06/04/2022
24/04/2022 4 5678 06/04/2022
25/04/2022 4 5678 06/04/2022
26/04/2022 4 5678 06/04/2022
27/04/2022 4 5678 06/04/2022
28/04/2022 4 5678 06/04/2022
29/04/2022 4 5678 06/04/2022
30/04/2022 4 5678 06/04/2022
01/05/2022 5 5678 01/05/2022
02/05/2022 5 5678 01/05/2022
03/05/2022 5 5678 01/05/2022
04/05/2022 5 5678 01/05/2022
05/05/2022 5 5678 01/05/2022
06/05/2022 5 5678 01/05/2022
07/05/2022 5 5678 01/05/2022
08/05/2022 5 5678 01/05/2022
09/05/2022 5 5678 01/05/2022
10/05/2022 5 5678 01/05/2022
11/05/2022 5 5678 01/05/2022
12/05/2022 5 5678 01/05/2022
13/05/2022 5 5678 01/05/2022
14/05/2022 5 5678 01/05/2022
15/05/2022 5 5678 01/05/2022
16/05/2022 5 5678 01/05/2022
17/05/2022 5 5678 01/05/2022
18/05/2022 5 5678 01/05/2022
19/05/2022 5 5678 01/05/2022
20/05/2022 5 5678 01/05/2022
21/05/2022 5 5678 01/05/2022
22/05/2022 5 5678 01/05/2022
23/05/2022 5 5678 01/05/2022
24/05/2022 5 5678 01/05/2022
25/05/2022 5 5678 01/05/2022
26/05/2022 5 5678 01/05/2022
27/05/2022 5 5678 01/05/2022
28/05/2022 5 5678 01/05/2022
29/05/2022 5 5678 01/05/2022
30/05/2022 5 5678 01/05/2022
31/05/2022 5 5678 01/05/2022
02/06/2022 6 5678 02/06/2022
03/06/2022 6 5678 02/06/2022
04/06/2022 6 5678 02/06/2022
05/06/2022 6 5678 02/06/2022
06/06/2022 6 5678 02/06/2022
07/06/2022 6 5678 02/06/2022
08/06/2022 6 5678 02/06/2022
09/06/2022 6 5678 02/06/2022
10/06/2022 6 5678 02/06/2022
11/06/2022 6 5678 02/06/2022
12/06/2022 6 5678 02/06/2022
13/06/2022 6 5678 02/06/2022
14/06/2022 6 5678 02/06/2022
15/06/2022 6 5678 02/06/2022
16/06/2022 6 5678 02/06/2022
17/06/2022 6 5678 02/06/2022
18/06/2022 6 5678 02/06/2022
19/06/2022 6 5678 02/06/2022
12/01/2022 1 1234 12/01/2022
13/01/2022 1 1234 12/01/2022
14/01/2022 1 1234 12/01/2022
15/01/2022 1 1234 12/01/2022
16/01/2022 1 1234 12/01/2022
17/01/2022 1 1234 12/01/2022
18/01/2022 1 1234 12/01/2022
19/01/2022 1 1234 12/01/2022
20/01/2022 1 1234 12/01/2022
21/01/2022 1 1234 12/01/2022
22/01/2022 1 1234 12/01/2022
23/01/2022 1 1234 12/01/2022
24/01/2022 1 1234 12/01/2022
25/01/2022 1 1234 12/01/2022
26/01/2022 1 1234 12/01/2022
27/01/2022 1 1234 12/01/2022
28/01/2022 1 1234 12/01/2022
29/01/2022 1 1234 12/01/2022
30/01/2022 1 1234 12/01/2022
31/01/2022 1 1234 12/01/2022
20/02/2022 2 1234 20/02/2022
21/02/2022 2 1234 20/02/2022
22/02/2022 2 1234 20/02/2022
23/02/2022 2 1234 20/02/2022
24/02/2022 2 1234 20/02/2022
25/02/2022 2 1234 20/02/2022
26/02/2022 2 1234 20/02/2022
27/02/2022 2 1234 20/02/2022
28/02/2022 2 1234 20/02/2022
18/03/2022 3 1234 18/03/2022
19/03/2022 3 1234 18/03/2022
20/03/2022 3 1234 18/03/2022
21/03/2022 3 1234 18/03/2022
22/03/2022 3 1234 18/03/2022
23/03/2022 3 1234 18/03/2022
24/03/2022 3 1234 18/03/2022
25/03/2022 3 1234 18/03/2022
26/03/2022 3 1234 18/03/2022
27/03/2022 3 1234 18/03/2022
28/03/2022 3 1234 18/03/2022
29/03/2022 3 1234 18/03/2022
30/03/2022 3 1234 18/03/2022
31/03/2022 3 1234 18/03/2022
17/04/2022 4 1234 17/04/2022
18/04/2022 4 1234 17/04/2022
19/04/2022 4 1234 17/04/2022
20/04/2022 4 1234 17/04/2022
21/04/2022 4 1234 17/04/2022
22/04/2022 4 1234 17/04/2022
23/04/2022 4 1234 17/04/2022
24/04/2022 4 1234 17/04/2022
25/04/2022 4 1234 17/04/2022
26/04/2022 4 1234 17/04/2022
27/04/2022 4 1234 17/04/2022
28/04/2022 4 1234 17/04/2022
29/04/2022 4 1234 17/04/2022
30/04/2022 4 1234 17/04/2022
10/05/2022 5 1234 10/05/2022
11/05/2022 5 1234 10/05/2022
12/05/2022 5 1234 10/05/2022
13/05/2022 5 1234 10/05/2022
14/05/2022 5 1234 10/05/2022
15/05/2022 5 1234 10/05/2022
16/05/2022 5 1234 10/05/2022
17/05/2022 5 1234 10/05/2022
18/05/2022 5 1234 10/05/2022
19/05/2022 5 1234 10/05/2022
20/05/2022 5 1234 10/05/2022
21/05/2022 5 1234 10/05/2022
22/05/2022 5 1234 10/05/2022
23/05/2022 5 1234 10/05/2022
24/05/2022 5 1234 10/05/2022
25/05/2022 5 1234 10/05/2022
26/05/2022 5 1234 10/05/2022
27/05/2022 5 1234 10/05/2022
28/05/2022 5 1234 10/05/2022
29/05/2022 5 1234 10/05/2022
30/05/2022 5 1234 10/05/2022
31/05/2022 5 1234 10/05/2022
10/06/2022 6 1234 10/06/2022
11/06/2022 6 1234 10/06/2022
12/06/2022 6 1234 10/06/2022
13/06/2022 6 1234 10/06/2022
14/06/2022 6 1234 10/06/2022
15/06/2022 6 1234 10/06/2022
16/06/2022 6 1234 10/06/2022
17/06/2022 6 1234 10/06/2022
18/06/2022 6 1234 10/06/2022
19/06/2022 6 1234 10/06/2022

 

THE MIN DATE WILL BE BY LOADID AND MONTH

 

Labels (1)
Labels
Preview file
15 KB
477 Views
0 Likes
2 Replies
marcus_sommer
MVP
MVP
‎2022-08-16 10:09 AM

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:

min(Date)

- Marcus

464 Views
elmelavi
Contributor III
Contributor III
‎2022-11-15 05:03 AM
Author

In response to marcus_sommer

thanks it work

434 Views
0 Likes