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: 
Anonymous
Not applicable

PIVOT TABLE Front end expression required

Hi All,

 

       Part        No      YearPart Desc.Supplier CodePlant CodeRelease Date28-Mar4-Apr11-Apr18-Apr25-Apr2-May9-May16-May23-May
A2016XYZAAAAAA13/28/2016 T S
4/4/2016 T1
4/11/2016
4/18/2016
4/25/2016
5/2/2016
5/9/2016
5/16/2016
5/23/2016 S1

above is pivot table where in forecast date has been dragged to the top so that each forecast date acts as a column

Suppose all the cells are filled with values.

Part number A has been selected in the application

Now i want to bring value from cell S of release date 28/03/2016 and forecast date 23 may to the cell T of release date 28/03/2016 and forecast date 4 april

Similary i want to bring value from cell S1 to T1.

The logic should work dynamically in case release week is selected from 3/28 to 9/5

In that case

bring value from cell  of release date 28/03/2016 and forecast date 9  may to the cell of release date 28/03/2016 and forecast date 4 april

Regards,

Jatin

2 Replies
Anonymous
Not applicable
Author

What is your intention of doing this ?

Anonymous
Not applicable
Author

Once i get the required value in the target cell, i will doing subtraction of that cells value and the new broughtin value and get the difference