topic Re: convert a set analysis to load script editor scripting in App Development

convert a set analysis to load script editor scripting

KayPong — Sat, 16 Nov 2024 01:34:03 GMT

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

Re: convert a set analysis to load script editor scripting

Taoufiq_Zarra — Mon, 31 Aug 2020 11:01:50 GMT

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

Re: convert a set analysis to load script editor scripting

Kushal_Chawda — Mon, 31 Aug 2020 12:04:55 GMT

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

Re: convert a set analysis to load script editor scripting

KayPong — Thu, 03 Sep 2020 02:53:31 GMT

Thanks @Kushal_Chawda , it works!