Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
brijeshvma
Partner - Creator
Partner - Creator

Getting Line wise different with Total and remaining Difference

Hi All,

I need urgent help from scripting side

       

CustomerIdDelivery DateOrder QtyTotal Order QtyTotal Delivered QtyDelivered Line Wise Item QtyPending Qty
100120-09-14490475340
100115-10-152009047532000
100115-11-152009047532000
100115-12-152009047532000
100115-01-1620090475314951
100116-01-161009047530100

I have data something like above first five table and and want output for last 2 column..

its like i have Totao order quantity and 4th column and line wise order qty .. and as well i have against the order how much total i have

delivered ( 904 - 753 = Remaining Pending qty 151) ... but i want to show data like last 2 column .  it means date wise first first order of 4 qty fulfil then second order qty and so on .. but once its reached the total of total delivered qty its show in Pending qty column

Kindly help me to resolve this..

As well I am attaching a sample excel file with required data in Yellow column.

6 Replies
brijeshvma
Partner - Creator
Partner - Creator
Author

Can any one give me idea to resolve it

Anonymous
Not applicable

could you  change the yellow columns into expression in you excel file please...

brijeshvma
Partner - Creator
Partner - Creator
Author

Hi Robin,

Which expression ?

As i created dummy data .. what client looking for .. I currently need logic to make the data as yellow column.

eliran
Creator III
Creator III

Hi Brijesh,

You're asking the community to help you find out the logic behind your customer's excel spread sheet.

I suggest you ask *him* that question, we can help you with calculations and methods to work it out afterwards.

BR,

Eliran.

brijeshvma
Partner - Creator
Partner - Creator
Author

Hi Eliran ,

What i understand with Requirement ... let me try to explain.. Say for Customer 1001

Delivery DateOrder QtyTotal Order QtyTotal Delivered QtyDelivered Line Wise Item QtyPending Qty
20-09-14490475340
15-10-152009047532000
15-11-152009047532000
15-12-152009047532000
15-01-1620090475314951
16-01-161009047530100

We have a Line wise order Qty : 4, 200,200,200,200,100 ( Total of This is 904) .. And i have Against the order 904 .. total delivered qty i.e 753 .  Means my pending qty is 151 to fulfill 904 order.

So,

Order Qty    Total Delivered Qty      Exp                          Delivered Line Wise Item Qty                Pending Qty

    4                        753                 ( 4 < 753 ) (753 - 4 = 749 )                      4                         0 

    200                    753               ( 200< 749 ) (749 - 200 =549)                 200                0  ( For 200 Order QTy)

    200                   753                 (200<549) ( 549 -200 = 349)                  200                0 ( for 200 order qty)

   200                    753                 (200<349)(349-200 = 149 )                   200                 0 ( for 200 qty )

  200                    753           (200 > 149 )   ( it should consider 0)            149               51 ( 200-149 =51 Pending qty)

100                       753              (100>0 )      ( it should consider 0)            0                  100 ( Pending entire 100 qty)

Anonymous
Not applicable

sorry, but for we can not know how much ist delivered per line (Date , CustomerID) ...

I think the community is the wrong place for clarifying the customer needs... that is your task

We can assist you realizing your clearly defined needs in QlikView.