topic Re: Aggr function help! in QlikView

Aggr function help!

mgdotcom — Mon, 11 Sep 2017 11:10:31 GMT

I'm trying to display costs per a batch_uuid (aggr cost by batch_uuid) but all I seem to be able to do is sum total costs. I'm using the Total Spend = Aggr(sum(cost),batch_uuid). Would anyone be able to help me with this?

Re: Aggr function help!

Anil_Babu_Samineni — Mon, 11 Sep 2017 15:10:47 GMT

I am not sure, When we talk about the Total Cost?

Sum(Aggr(sum(cost),batch_uuid))

Sum(Aggr(sum(TOTAL <batch_uuid> cost),batch_uuid))

Re: Aggr function help!

sunny_talwar — Mon, 11 Sep 2017 15:23:27 GMT

Why are you not just doing this Sum(Cost)?

Re: Aggr function help!

mgdotcom — Mon, 11 Sep 2017 15:29:24 GMT

Thank you for helping. @Anil, the outcome is the same. I just can't get it to give me the cost for each batch_uuid. Even when I add Cost as a dimension it seems to replicate numerous times.

Re: Aggr function help!

mgdotcom — Mon, 11 Sep 2017 15:30:23 GMT

Thanks for trying to help Sunny. I've tried that. the outcome is the same.

Re: Aggr function help!

sunny_talwar — Mon, 11 Sep 2017 15:44:00 GMT

It seems that you might have issue with your data model.... Cost may not be disconnected to the batch_uuid field in the back end model

Re: Aggr function help!

Anil_Babu_Samineni — Mon, 11 Sep 2017 15:45:14 GMT

can you share application to check because it may concern from DM as i believe

Re: Aggr function help!

mgdotcom — Mon, 11 Sep 2017 18:17:08 GMT

Thanks Sunny. I removed a syn key I created and it all seems to be fine now.