Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ngosz4074
New Contributor III

aggregation question

Hello,

I have two tables joined by Employee ID where I have the repeating total in one column and the correct hours value in the last (tbl2) column.  I have been using this Aggr(Sum([Measure -tbl1])),ID,Name,Code,Date) - but I get the same result. 

I added Distinct to the AGGR formula and I get 0,0,2,0 as a result set. 

Aggr(Sum(Distinct([Measure -tbl1])),ID,Name,Code,Date))

Any advice on tweaking the formula? 

IDNameCodeMeasure -tbl1Measure -tbl2
5Joy15503010
5Joy15503010
5Joy1550309.75
5Joy155030.25

Thanks in advance

Neal

Tags (3)
2 Replies

Re: aggregation question

What are you looking to get here?

Highlighted
ngosz4074
New Contributor III

Re: aggregation question

I'm hoping to get the same hours in the tbl1 column to tbl2 so we can compare hours between the tables.  I think we have different granularity levels, so that's why I was trying to work with AGGR.