13 Replies Latest reply: Aug 27, 2015 12:39 PM by mahathi vucha

# total sum quantity

Hi all,

What should be the exact formula for the QUANTITY REDUCED.it should be the same total quantity both DELIVERY QTY and QTY REDUCED.

Teles

• ###### total sum quantity

Hi Teles,

You are using DISTINCT in your second expression and not in your first.

That is the reason why the are different.

If you just want to sum them you don't need it imo.

Dennis.

• ###### total sum quantity

Hi Dennis,

Thank you,

How about when i select the PO NUMBER 4600003085.the quantity reduced is not tally.

Teles

• ###### Re: total sum quantity

Why do you assume that both sums should be the same?

The data is different:

I can't understand why (see below) SUM(QUANTITY REDUCED) retruns 7 when there is only 3 in the selection.

Can you explain why this is?

• ###### Re: total sum quantity

Thats why im confusing.but the other PO NUMBER are tally.I am looking for the report in SAP thats why i assume that they are tally,you may select the  4600003111 they are tally based on the report in SAP.but when i select the 4600003085 the quantity in quantity reduced are not.I dont know why it appears that qty.but in list box of quantity reduced the qty are 1 and 2 only.

Teles

• ###### Re: total sum quantity

So the 1 and 2 in this example could stand for 3 and 4, right?
Then it would make ( a little) sence that the total is 7.

What is the value of DABMG in the original database? is it 1 and 2 or 3 and 4?

Maybe something like:

NUM(DABMG) AS [QUANTITY REDUCED],

and see what happens ...

• ###### Re: total sum quantity

Nah, that doesn't make sence either ....

Sorry.

• ###### Re: total sum quantity

Hi,

Good Day!

The problem are the same.

Any suggestion with my concern.I dont know what is the problem.I dont know if my script are wrong or in the formula in expressions.

The 4600003111 are correct in quantity in reduced qty and the delivery qty.

But the 4600003085 are not.i dont know why the qty in reduced qty it becomes to 7 but in the list box of

reduced qty are 1 and 2 qty only.

Thank you so much,

Teles

• ###### Re: total sum quantity

It doesn't make sence to me either.

My suggestion would be to take a look at your source (D:\Qlikview\SCInnova\DB\EKES.qvd)

See what happens when you try: SUM(DABMG) in that qvd document.

If this also shows this beheviar take a look at where EKES.qvd gets his information from ....

• ###### Re: total sum quantity

Hi,

My source are correct.Why is it when i choose the PO number 4600003111,4600005585 is tally based on the report of SAP. The DELIVERY QUANTITY has no problem about the quantity

But when the other PO number are not,like the 4600003085,4600006447 are not tally the QUANTITY REDUCED.

I dont know what to do.or my script and the fomula in expressions are not correct?

This should be my report... How many delivery quantity or inbound quantity should be and how many the goods reciepts quantity in plant.

INBOUND QUANTITY - GR QUANTITY = PICKING QUANTITY

Any suggestions is highly appreciated.

Thanks,

Teles

• ###### Re: total sum quantity

As far as I can see there is nothing wrong with your expression or with your script.

What happens when you try: SUM(DABMG) in  D:\Qlikview\SCInnova\DB\EKES.qvd ?

Does it return the same strange results?

• ###### Re: total sum quantity

Good Day Experts.....

Hi Dennis,

The results are the same.

Hi BlacKRocKS,

I understand your instructions that you replied before with my concern.I confusing with the MATNR field name in EKES table.how could it be link to LIPS table.What is the Material number of quantity reduced in LIPS table?

Thank you for Tirelessly answering my questions,

Teles

• ###### Re: total sum quantity

Hi,

Please try to understand and follow my instructions that i replied against your other post for this same problem:

http://community.qlik.com/message/136845#136845

Cheers.

• ###### Re: total sum quantity

Hello Everyone- In the same requirement i want to find out the 1st po date and 1st po Qty

to get the 1st po date i am doing min(po date) which is working fine

but to get the 1st po qty i am trying to do

=Alt(FirstSortedValue(Aggr(Sum([Qty On Order]), [Item Number], [Promise Date]), [Promise Date]), Aggr(Sum([Qty On Order]), [Item Number], [Promise Date]))

=Sum({<[Promise Date] = {"\$(=Min([Promise Date]))"}>} [Qty On Order])

Both the expressions are not working for me please give me some suggetions how to get the 1st PO Qty for that item.

the other thing happening =Sum({<[Promise Date] = {"\$(=Min([Promise Date]))"}>} [Qty On Order]) with this expression is that it is working only if i select one item, and is displaying all over when no item is selected in the chart.