Solved: Re: Values are not tallying - Qlik Community

Anonymous · ‎2016-12-27

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

tyagishaila · ‎2016-12-27

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

View solution in original post

tyagishaila · ‎2016-12-27

(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

Anonymous · ‎2016-12-27

How can I solve this???

Because the above formula is right for pending so.

tyagishaila · ‎2016-12-27

Please share sample data with required output.

tyagishaila · ‎2016-12-27

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

Anonymous · ‎2016-12-27

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

Anonymous · ‎2016-12-27

Hi All / gwassenaar‌,

Any solution on this???

tyagishaila · ‎2016-12-27

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

Anonymous · ‎2016-12-27

Am not getting exact output....

I want bucketing of Pending SO figure ....

tyagishaila · ‎2016-12-27

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.