PIVOT TABLE Front end expression required

Anonymous — Thu, 20 Oct 2016 14:43:20 GMT

Hi All,

Part No

Year

Part Desc.

Supplier Code

Plant Code

Release Date

28-Mar

4-Apr

11-Apr

18-Apr

25-Apr

2-May

9-May

16-May

23-May

2016

XYZ

AAA

AAA1

3/28/2016

4/4/2016

4/11/2016

4/18/2016

4/25/2016

5/2/2016

5/9/2016

5/16/2016

5/23/2016

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

Re: PIVOT TABLE Front end expression required

Anonymous — Thu, 20 Oct 2016 14:53:02 GMT

What is your intention of doing this ?

Re: PIVOT TABLE Front end expression required

Anonymous — Thu, 20 Oct 2016 14:57:23 GMT

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

topic PIVOT TABLE Front end expression required in QlikView

PIVOT TABLE Front end expression required

Re: PIVOT TABLE Front end expression required

Re: PIVOT TABLE Front end expression required