topic How do i calculate order Qty in QlikView

How do i calculate order Qty

Tue, 30 Aug 2011 10:47:59 GMT

Dear All,

I have one small query on my report, my query is how do i calculate Order Qty if Pending Qty is not equal to Zero.

I have two expressions in my report

1) Order Qty

2) Pending Qty

Order Qty - Order Qty wher pending Qty is not zero.

Pending Qty - Order Qty - Sales Qty.

Please find attached excel sheet.

Regards,

Napolean.

Re: How do i calculate order Qty

swuehl — Tue, 30 Aug 2011 10:54:00 GMT

I think this should work:

Create a straight table with dimension Quote_No,

Use two expressions:

=if([Pending Qty]>0,[Order Qty])

and

=[Pending Qty]

Check suppress zero values in presentation tab.

Regards,

Stefan

edited:

second expression field

edited by swuehl

How do i calculate order Qty

Tue, 30 Aug 2011 11:01:29 GMT

Hi,

Pending qty is not a field name, it is an expression name.

Pending Qty = Order Qty - Sales Qty.

Regards,

Napolean.

How do i calculate order Qty

swuehl — Tue, 30 Aug 2011 11:05:28 GMT

I was referring to your excel file (and I can't see a Sales Qty there), but anyway, just replace [Pending Qty] by ([Order Qty]- [Sales Qty])

Stefan

Re: How do i calculate order Qty

Tue, 30 Aug 2011 11:09:41 GMT

Hi,

Chk ths

-Jai

How do i calculate order Qty

Tue, 30 Aug 2011 11:10:13 GMT

Hi,

i tried in straight table but its not working....

=if(([Order Qty]- [Sales Qty])>0,[Order Qty])

Regards,

Napolean.

How do i calculate order Qty

swuehl — Tue, 30 Aug 2011 11:15:28 GMT

Do you have more than one record per Quote_No? Could you update your excel file with more detailed data then, including the sales data?

How do i calculate order Qty

Tue, 30 Aug 2011 11:33:04 GMT

you'll need to change that to a sum

=Sum(if(([Order Qty]- [Sales Qty])>0,[Order Qty]))