topic Re: aggregation question in QlikView

aggregation question

ngosz4074 — Wed, 08 Mar 2017 14:45:41 GMT

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?

ID	Name	Code	Measure -tbl1	Measure -tbl2
5	Joy	1550	30	10
5	Joy	1550	30	10
5	Joy	1550	30	9.75
5	Joy	1550	30	.25

Thanks in advance

Neal

Re: aggregation question

sunny_talwar — Wed, 08 Mar 2017 14:47:43 GMT

What are you looking to get here?

Re: aggregation question

ngosz4074 — Wed, 08 Mar 2017 14:50:46 GMT

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.