Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
vijayptcs
Creator II
Creator II

Values are not tallying

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

1 Solution

Accepted Solutions
tyagishaila
Specialist
Specialist

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

13 Replies
tyagishaila
Specialist
Specialist

(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

vijayptcs
Creator II
Creator II
Author

How can I solve this???

Because the above formula is right for pending so.

tyagishaila
Specialist
Specialist

Please share sample data with required output.

tyagishaila
Specialist
Specialist

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

vijayptcs
Creator II
Creator II
Author

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

vijayptcs
Creator II
Creator II
Author

Hi All / gwassenaar‌,

Any solution on this???

tyagishaila
Specialist
Specialist

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

vijayptcs
Creator II
Creator II
Author

Am not getting exact output....

I want bucketing of Pending SO figure ....

tyagishaila
Specialist
Specialist

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.