topic total sum quantity in QlikView

total sum quantity

Fri, 29 Jul 2011 06:13:00 GMT

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

total sum quantity

Anonymous — Fri, 29 Jul 2011 06:32:14 GMT

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

Fri, 29 Jul 2011 07:41:24 GMT

Hi Dennis,

Thank you,

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

Please help.

Teles

Re: total sum quantity

Anonymous — Fri, 29 Jul 2011 08:40:06 GMT

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?

Re: total sum quantity

Fri, 29 Jul 2011 09:12:27 GMT

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

Re: total sum quantity

Anonymous — Fri, 29 Jul 2011 09:50:08 GMT

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

Re: total sum quantity

Anonymous — Fri, 29 Jul 2011 09:52:06 GMT

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

Sorry.

Re: total sum quantity

Mon, 01 Aug 2011 01:09:22 GMT

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

Re: total sum quantity

Anonymous — Mon, 01 Aug 2011 10:20:53 GMT

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

Tue, 02 Aug 2011 01:42:36 GMT

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

Anonymous — Tue, 02 Aug 2011 06:27:11 GMT

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

Tue, 02 Aug 2011 07:18:00 GMT

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

Wed, 03 Aug 2011 01:50:00 GMT

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

maahivee — Thu, 27 Aug 2015 16:39:47 GMT

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.