Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggregate function

I have a table as follows:

1.JPG.jpg

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:

2.JPG.jpg

6 Replies
iktrayanov
Creator III
Creator III

If you need to calculate duration per SystemId simply use

Sum(DURATION)

Not applicable
Author

even sum(Duration) is giving me the same values

iktrayanov
Creator III
Creator III

Can you share your data model or sample app?

Not applicable
Author

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
iktrayanov
Creator III
Creator III

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

Not applicable
Author

they are joined by qlikview