topic Re: Aggr Function Issue in QlikView

Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 16:34:04 GMT

I have a straight table and I am using this expression

SUm(Aggr(

If(sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)>

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)),Prod_Variety_Number))

My Dimension is Prod_Variety_Number, but I am loosing rows when I am doing this expression.

Any idea what am I doing wrong?

Re: Aggr Function Issue

Anil_Babu_Samineni — Thu, 11 Jan 2018 16:39:54 GMT

No Idea.. But, Try to use this and share screen where values are getting wrong?

If(sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)>sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty))

Re: Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 16:41:44 GMT

Already tried this first

Re: Aggr Function Issue

Anil_Babu_Samineni — Thu, 11 Jan 2018 16:43:28 GMT

Can you consider as expresions like

1) sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)

2) sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders)

And show image?

Re: Aggr Function Issue

sunny_talwar — Thu, 11 Jan 2018 16:51:41 GMT

May be this

Sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"}>} Aggr(

If(sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)>

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Order_Date)"},Production_Key={'Orders'}>} sum_orders),

sum({< LinkType = {'Production'}, Crop={'Corn'},Date = {"$(vMax_Prod_Prod_Date)"},Production_Key={'Production'}>} sum_floor_qty)),Prod_Variety_Number))

Re: Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 16:53:29 GMT

Please se the attached . On top u see the results seperately and at the bottom I expect to see 1330390 cuz that is not greater then sum orders

Re: Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 17:04:20 GMT

Doesnt work, still missing rows

Re: Aggr Function Issue

sunny_talwar — Thu, 11 Jan 2018 17:06:30 GMT

Would you be able to share a qvw sample?

Re: Aggr Function Issue

Anil_Babu_Samineni — Thu, 11 Jan 2018 17:08:03 GMT

Validation looks Okay? Can you highlight where you getting wrong?

Re: Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 17:08:28 GMT

Can we do a screen sharing or something?

Re: Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 17:12:17 GMT

The second chart at the bottom expect to see 1330391

Re: Aggr Function Issue

Anil_Babu_Samineni — Thu, 11 Jan 2018 17:46:00 GMT

Not sure about your application, May be share to investigate. But sample data looks working?

Re: Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 19:11:29 GMT

what is ur expression for this sample out put

Re: Aggr Function Issue

azmeerrehan — Thu, 11 Jan 2018 19:12:33 GMT

Can u pls share ur qvw

Re: Aggr Function Issue

Anil_Babu_Samineni — Fri, 12 Jan 2018 01:59:47 GMT

PFA

Re: Aggr Function Issue

Anil_Babu_Samineni — Mon, 15 Jan 2018 12:50:48 GMT

IS that helps? If not, Please post sample application to investigate?