Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
If you need to calculate duration per SystemId simply use
Sum(DURATION)
even sum(Duration) is giving me the same values
Can you share your data model or sample app?
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 |
When you say 'are joined' do mean that you are using inner join or tables are automatically joined by QlikView?
they are joined by qlikview