Script Aggregation

prrajendran — Sat, 16 Nov 2024 01:24:26 GMT

Hi,

I have the following tables loaded in the script

Vehicle:

LOAD VehicleKEY,
VehicleCode,
[Vehicle Primary Type],

[Vehicle Secondary Type]

FROM Vehicle.qvd

Activity:

LOAD Activity,
     [Activity Key]

FROM Activity.qvd

Employee:

Load EmployeeKEY,

[Employee Type]

From Employee.qvd

Time:

Load TimeKEY,

Hour,

[15 min Interval]

From Time.qvd

[Fact Data]:
LOAD Date,
     EmployeeKEY,
     VehicleKEY,
     TimeKEY,
     Area,

     Group
    [Time in Seconds],
     [Activity Key]

FROM Data.qvd

From this data, I am reporting Two Metrics with the expressions below:

Average Vehicle Count:

AVG(AGGR(

(count({<[Vehicle Primary Type]={'SUV'},Activity ={'Logged'},[Vehicle Secondary Type]={'Manual','Auto'},[Employee Type]-={'Not Available'}>}VehicleCode)
+
count({<[Vehicle Primary Type]={'Hatch'},Activity ={'Logged'},[Vehicle Secondary Type]={'Manual','Auto'},>}VehicleCode))

,[15 min Interval],Date))

Logged Time/day:

Interval(

(sum({< Activity = {Logged},Group={S},[Employee Type]-={'Not Available'}>}
[Time in Seconds]/86400)
/
count(Date))

,'hh:mm:ss')

I want to replicate this in the script itself. Is it possible? Because the data is too big and it is taking long time to load the chart. Can someone please help me with the script?

Re: Script Aggregation

Brett_Bleess — Mon, 24 Feb 2020 15:17:09 GMT

See duplication post: https://community.qlik.com/t5/New-to-QlikView/Aggregation-in-script/m-p/1670016#M385959

Regards,
Brett

topic Script Aggregation in QlikView

Script Aggregation

Re: Script Aggregation