Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
May I know how to convert the following set analysis to a script in Qliks Sense>
Sum({$<[WeekStart - GAI]={"$(=Max([WeekStart - GAI]))"}>}[Gravitrap Count])/
Count({<[Trap Status] = {"Functional"},[WeekStart - GAI]={"$(=Max([WeekStart - GAI]))"}>}[Trap Status])
try below
Data:
load *
FROM Table;
left join(Data)
load date(max([WeekStart - GAI])) as [WeekStart - GAI]
1 as Max_Weekstart_GAI_Flag
resident Data;
left join(Data)
load date(max([WeekStart - GAI])) as [WeekStart - GAI],
[Trap Status],
1 as Max_Weekstart_GAI_Status_Flag
resident Data
where [Trap Status]='Functional'
group by [Trap Status];
then you can try blow expression
Sum({$<Max_Weekstart_GAI_Flag={1}>}[Gravitrap Count])/
Count({<Max_Weekstart_GAI_Status_Flag={1}>}[Trap Status])
@KayPong can you share a sample data and the expected output if possible ?
try below
Data:
load *
FROM Table;
left join(Data)
load date(max([WeekStart - GAI])) as [WeekStart - GAI]
1 as Max_Weekstart_GAI_Flag
resident Data;
left join(Data)
load date(max([WeekStart - GAI])) as [WeekStart - GAI],
[Trap Status],
1 as Max_Weekstart_GAI_Status_Flag
resident Data
where [Trap Status]='Functional'
group by [Trap Status];
then you can try blow expression
Sum({$<Max_Weekstart_GAI_Flag={1}>}[Gravitrap Count])/
Count({<Max_Weekstart_GAI_Status_Flag={1}>}[Trap Status])
Thanks @Kushal_Chawda , it works!