topic Values are not tallying in QlikView

Values are not tallying

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I stuck on one bucketing issue that I am not able to tallying last column of report that is Pending SO.

I have created bucket on Shipment date.

Please check

Re: Values are not tallying

tyagishaila — Tue, 27 Dec 2016 06:22:12 GMT

(1 / (IF(LEN( [Currency Factor])>0,[Currency Factor],0 ) )) as [Pending Order Qty]

For [Pending Order Qty] , If you have LEN([Currency Factor])=0 than IF expression will return 0,

it will make 1/0 = - (null value)

Because of this null value your PendingSO is giving false result.

Regards

Shaila

Re: Values are not tallying

Anonymous — Tue, 27 Dec 2016 06:37:59 GMT

How can I solve this???

Because the above formula is right for pending so.

Re: Values are not tallying

tyagishaila — Tue, 27 Dec 2016 06:42:10 GMT

Please share sample data with required output.

Re: Values are not tallying

tyagishaila — Tue, 27 Dec 2016 06:59:48 GMT

Is there issue with [Pending Order Qty] or with [Pending SO]?

Re: Values are not tallying

Anonymous — Tue, 27 Dec 2016 07:21:40 GMT

both are same

but I have issue with [Pending SO] that Pending So value should sum of all first 8 column I mean first 8 column is break up of Pending SO(Pending Order Qty)

Please check ....

Re: Values are not tallying

Anonymous — Tue, 27 Dec 2016 08:58:10 GMT

Hi All / gwassenaar‌,

Any solution on this???

Re: Values are not tallying

tyagishaila — Tue, 27 Dec 2016 09:43:17 GMT

I found Pending SO is correct but [Pending Order Quantity] Before Dec2016 is not giving correct value

and Pending SO/Total Pending Order Quantity should be the sum of

Before Dec2016, Dec2016, Jan 2017, Feb 2016, Mar 2017, After Mar2017

Check it

Re: Values are not tallying

Anonymous — Tue, 27 Dec 2016 10:15:59 GMT

Am not getting exact output....

I want bucketing of Pending SO figure ....

Re: Values are not tallying

tyagishaila — Tue, 27 Dec 2016 10:27:23 GMT

Let me know how are you creating bucket list?

How can you add Before Dec2016 data with past 6 month data... by this data will add twice.

it is not clear to me...

According to me.. bucket must be

Before Dec2016

Dec2016

Jan2017

Feb2017

Mar2017

After Mar2017.

Re: Values are not tallying

tyagishaila — Tue, 27 Dec 2016 10:42:56 GMT

For Past 6 Month

Expression is-

Sum({<SHIP_DT_NUM={">$(=floor(monthstart(vToday),-6)) <=$(=today())"} ,SalesLine_DT={1},Order_Flag={'P'}>}[Pending Order Qty])/100000

Replace today() by vToday variable.

sum({<SHIP_DT_NUM={">$(=floor(monthstart(vToday),-6)) <=$(vToday)"} ,SalesLine_DT={1},Order_Flag={'P'}>}[Pending Order Qty])/100000

Re: Values are not tallying

Anonymous — Tue, 27 Dec 2016 11:58:37 GMT

Hi Shaila,

I really appreciate your help...

As you said i am showing

Before Dec2016

Dec2016

Jan2017

Feb2017

Mar2017

After Mar2017 as bucket but How can will get old orders? .

Thanks

Re: Values are not tallying

Anonymous — Wed, 28 Dec 2016 04:37:25 GMT

When I apply your suggested chart then I am getting different values

Re: Values are not tallying

tyagishaila — Wed, 28 Dec 2016 05:18:14 GMT

please share required output.

As per your data your Pending SO is correct (total Pending Order Qty from Jan 1753 to Oct 2017).

and what do you mean by old orders (from MnthYr to MonthYr)?