topic Re: Case statement in QlikView

Case statement

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Case statement

m_woolf — Fri, 04 Mar 2016 20:41:54 GMT

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

Re: Case statement

Fri, 04 Mar 2016 20:46:09 GMT

Thanks for the reply it gives me an error.

Re: Case statement

sunny_talwar — Fri, 04 Mar 2016 20:47:19 GMT

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

Re: Case statement

Anonymous — Fri, 04 Mar 2016 21:20:35 GMT

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

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

Regards.

Re: Case statement

Fri, 04 Mar 2016 21:32:35 GMT

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,

Re: Case statement

Fri, 04 Mar 2016 22:00:26 GMT

They are fields located in different tables

Re: Case statement

Mon, 07 Mar 2016 18:08:16 GMT

Thanks for all your help.