convert a set analysis to load script editor scripting

[KayPong]

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])

[Taoufiq_Zarra]

@KayPong  can you share a sample data and the expected output if possible ?

[Kushal_Chawda · Accepted solution]

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]

Thanks @Kushal_Chawda , it works!