Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

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
Highlighted
Contributor II

Re: PIVOT TABLE Front end expression required

What is your intention of doing this ?

Highlighted
New Contributor III

Re: PIVOT TABLE Front end expression required

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