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