Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
veerendrakatika
Contributor III
Contributor III

week value subtract with selected week

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:

w1

w2

w3

w4

w5

w6

w7

  Pivot table:

Dim1Dim2Expr1
w1
1AAA95
2BB100
3CC2
4DD1

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

 

 

Dim1Dim2Expr1
w1w2
1AAA9595
2BB10098
3CC226
4DD178

please let me know your suggestions for better approach.

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

0 Replies