aggr function.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I'm kind of new to Qlikview. Could someone tell me what i did wrong for my program ? The final value is not correct. I use aggr() function group by a unique field. It seems to me there are some duplicate values , which does not make sense.

Sum(

{$< [Cost Transaction Date] = {"<=$(=date(max(Date)))>=$(=date(min(Date)))"} >}

Aggr(

aggr(DISTINCT

sum({$<[Cost Transaction Date] = {"<=$(=date(max(Date)))>=$(=date(min(Date)))"},

[Operation Code] = {'80','40'},

LinkId = {'OPSJ'}

>}[Cost Transaction Scrap Quantity Actual]),[Cost Job Code])

( aggr(distinct

sum({$< [Cost Transaction Date] = {"<=$(=date(max(Date)))>=$(=date(min(Date)))"},

[Cost Category Num] = {'3'},

[Cost Type Code] = {'1'},

LinkId = {'OPSJ'}

>}[Cost Transaction Value Actual]),[Cost Job Code])

aggr(DISTINCT

sum({$< [Cost Transaction Date] = {"<=$(=date(max(Date)))>=$(=date(min(Date)))"},

[Cost Category Num] = {'3'},

[Cost Type Code] = {'1'},

LinkId = {'OPSJ'}

>} [Cost Transaction Quantity Actual]), [Cost Job Code])

)

aggr(DISTINCT

sum(

{$< [Cost Transaction Date] = {"<=$(=date(max(Date)))>=$(=date(min(Date)))"},

[Operation Code] = {'80','40'},

LinkId = {'OPSJ'}

>}[Cost Transaction Value Actual]),[Cost Job Code])

,[Cost Job Code])

)

Re: aggr function.

Anonymous — Wed, 17 Jan 2018 17:17:02 GMT

Try separating the function to identify which aggr is not working properly

Re: aggr function.

sunny_talwar — Wed, 17 Jan 2018 17:21:14 GMT

Very difficult to know just by looking at the expression... would you be able to share a sample where you are trying this out and it isn't giving you want you want.

topic aggr function. in QlikView

aggr function.

Re: aggr function.

Re: aggr function.