Case statement

[#1]

Hi All,

case when activeusercount is not null and activeusercount > 2 then 'yes' else 'no' end as "More than 2 users in 30 days",

Can someone please help me in writing this if statement. I'm aware case when statement doesn't exist in Qlik and when I write out this statement it gives me an error. Active User Count is a field in my table.

Thanks in advance

[m_woolf · Accepted solution]

I don't think you need the "is not null".  If activeusercount > 2 then it must not be null.

if(activeusercount > 2,'yes','no') as [More than 2 users in 30 days],

[#3]

Thanks for the reply it gives me an error.

[sunny_talwar]

I think what m w‌ gave you is needed to be used in the script

[Anonymous]

what it says Sunny T is correct  , if you want to use in one dimension then

if(Floor(Active.activeusercount)> 2,'yes','no')

Regards.

[#6]

Yeah it works in the script. Can you guide me towards how to write this statement in Qlik please.

coalesce(statusname,d2.recordedstatus) as status,

Thanks,

[#7]

They are fields located in different tables

[#8]

Thanks for all your help.