topic Re: aggregate function in QlikView

aggregate function

Thu, 13 Feb 2014 00:33:03 GMT

I have a table as follows:

And when I apply the aggregate function on duration as aggr(sum(DURATION),SYSTEM_ID) , I get the values totally scaled up.. I noticed they are multiplied 7 or 6 or 5 times than the expected values what could be the reason, the aggregated table is as follows:

Re: aggregate function

iktrayanov — Thu, 13 Feb 2014 00:53:46 GMT

If you need to calculate duration per SystemId simply use

Sum(DURATION)

Re: aggregate function

Thu, 13 Feb 2014 00:59:10 GMT

even sum(Duration) is giving me the same values

Re: aggregate function

iktrayanov — Thu, 13 Feb 2014 01:15:17 GMT

Can you share your data model or sample app?

Re: aggregate function

Thu, 13 Feb 2014 01:20:22 GMT

The values are taken from 2 tables which are joined on System_ID field. this is my data model with 2 tables outage and system

system

system_id

sla_name

outage

system_id

outage_id

start_date

duration

Re: aggregate function

iktrayanov — Thu, 13 Feb 2014 01:28:23 GMT

When you say 'are joined' do mean that you are using inner join or tables are automatically joined by QlikView?

Re: aggregate function

Thu, 13 Feb 2014 01:30:17 GMT

they are joined by qlikview