Unique Values Based on ROW and Column

[Anonymous]

I'm looking to upload unique Values in which share the same ID and the price were unchanged from 1 week to another.

Example:

Data:

ID	Price	Group	UpdatedWeek
1	1b	34	23
1	2b	34	22
2	3b	33	23
2	3b	33	22
3	4b	36	23
3	5b	36	22
4	6b	21	23
4	6b	21	22
5	2b	28	23
5	4b	28	22

Expected:

ID	Price	Group	UpdatedWeek
1	1b	1	23
1	2b	2	22
3	4b	5	23
3	5b	6	22
5	2b	9	23
5	4b	10	22

For Qlik Sense

[Nicole-Smith · Accepted solution]

Your question posted twice.  I've answered on the other thread: Load Unique Value based on a specific Row and Column