Aggregation

prrajendran — Sat, 16 Nov 2024 01:23:53 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: Aggregation

Arthur_Fong — Thu, 06 Feb 2020 08:31:30 GMT

You have a sample app and also a sample data source?

Re: Aggregation

Brett_Bleess — Mon, 24 Feb 2020 16:30:23 GMT

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

Regards,
Brett

topic Re: Aggregation in QlikView

Aggregation

Re: Aggregation

Re: Aggregation