week value subtract with selected week

veerendrakatika — Wed, 25 Nov 2020 16:16:04 GMT

I have one scenario like I have one week list box which I always selected one value. I have one Pivot table in which is some thing like as below

Listbox:

Pivot table:

Dim1	Dim2	Expr1

		w1
1	AAA	95
2	BB	100
3	CC	2
4	DD	1

If I select another week in the same listbox, week should be appear beside of default selected week and the values should be populated as dynamically.the selected week should be subtract with default selected week. result as below

Dim1	Dim2	Expr1

		w1	w2
1	AAA	95	95
2	BB	100	98
3	CC	2	26
4	DD	1	78

please let me know your suggestions for better approach.

note: w2 values are dummy values and also I don't have sample data.

topic week value subtract with selected week in QlikView

week value subtract with selected week