Straight Table Issue

[azmeerrehan]

I  have a straight table showing  the in two rows as attached.  THe output required is BELOW

A                   B     C                    D       E

70076746      754    GS4465X       -         18

The Expression for E is below

Aggr((sum({< LinkType = {'Production'},  Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'} >}  available_qty)

-

sum({< LinkType = {'Production'},  Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'},treatment_code-={'ZZZ'}>}  sum_orders)),A, B)

Please note that Available Qty and Sum_Orders is coming in from 2 different data sets with different Dates

[petter]

Can you share the content of the variable vMax_Prod_Order_Date?

Why do you use an Aggr()-function to calculate - wouldn't a Sum(TOTAL <A,B> ..... ) do the trick?

Are you able to create a sample QlikView application with some data for us - it is hard to see exactly what needs to be done in you short description?

[azmeerrehan]

The content of the variable "vMax_Prod_Order_Date"

=max({<LinkType = {'Production'}, Production_Key={'Orders'},  AgroCoreZone=, Sales_DM_Concat=, Sales_DM_Concat_NK=, [CU Desc]=>} Date)

[Anil_Babu_Samineni]

The trick may equal sign before your variable. So, add that.. and, where you add this variable i meant with in the script or overview?

[sunny_talwar]

Did you even get to see the solution provided here?

Straight Table Issue