topic Re: Straight Table Issue in QlikView

Straight Table Issue

azmeerrehan — Wed, 17 Jan 2018 22:10:10 GMT

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

Re: Straight Table Issue

petter — Wed, 17 Jan 2018 22:34:34 GMT

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?

Re: Straight Table Issue

azmeerrehan — Wed, 17 Jan 2018 22:50:19 GMT

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)

Re: Straight Table Issue

Anil_Babu_Samineni — Thu, 18 Jan 2018 00:54:52 GMT

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?

Re: Straight Table Issue

sunny_talwar — Thu, 18 Jan 2018 01:07:42 GMT

Did you even get to see the solution provided here?

Straight Table Issue