Discussion Board for collaboration related to QlikView App Development.
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:
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