total sum quantity

[#1]

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.

Thanks in advance,

Teles

[Anonymous]

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.

[#3]

Hi Dennis,

Thank you,

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

Please help.

Teles

[Anonymous]

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

The data is different:

But there is something strange about your data.
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?

[#5]

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.

Please help.

Teles

[Anonymous]

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?

I think you should try something in your loading script,

Maybe something like:

     NUM(DABMG) AS [QUANTITY REDUCED],

and see what happens ...

[Anonymous]

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

Sorry.

[#8]

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.

Please help me.

Thank you so much,

Teles

[Anonymous]

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 ....

[#10]

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