Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
See duplication post: https://community.qlik.com/t5/New-to-QlikView/Aggregation-in-script/m-p/1670016#M385959
Regards,
Brett
See duplication post: https://community.qlik.com/t5/New-to-QlikView/Aggregation-in-script/m-p/1670016#M385959
Regards,
Brett