Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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

13 Replies
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

vijayptcs
Creator II
Creator II
Author

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

vijayptcs
Creator II
Creator II
Author

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

tyagishaila
Specialist
Specialist

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)?