topic Re: Case Statement in QlikView

Case Statement

Thu, 18 Feb 2016 18:28:47 GMT

Hi all,

I am trying to write a Case statement in Qlikview as follows but I am getting nothing as result.

I am trying to execute in Chart Object Expression.

if(wildmatch([Trnsctn_Code],'*APA*', 'Approved'),

if(wildmatch([Trnsctn_Code],'*APC*', 'Credit'),

if(wildmatch([Trnsctn_Code],'*APP*','Pending',),

'OTHER')))

Please advise me.

Re: Case Statement

Anonymous — Thu, 18 Feb 2016 19:09:40 GMT

I think your closing brackets are misplaced, maybe something more like this :

if(wildmatch([Trnsctn_Code],'*APA*') , 'Approved',

if(wildmatch([Trnsctn_Code],'*APC*') , 'Credit',

if(wildmatch([Trnsctn_Code],'*APP*') ,'Pending',

'OTHER')))

Re: Case Statement

Thu, 18 Feb 2016 19:21:00 GMT

Hi Bill,

Thanks for your Quick response, Its working fine.

Re: Case Statement

Anonymous — Thu, 18 Feb 2016 19:24:28 GMT

Glad you are sorted.

Re: Case Statement

maxgro — Thu, 18 Feb 2016 19:52:45 GMT

pick(wildmatch([Trnsctn_Code],

'*APA*', '*APC*', '*APP*', '*'),

'Approved','Credit','Pending','OTHER'

)

Re: Case Statement

sunny_talwar — Thu, 18 Feb 2016 20:56:20 GMT

Instead of marking your own responses as helpful, you should consider marking Bill‌'s response as correct and M G‌‌'s response as helpful.

Re: Case Statement

satishkurra — Thu, 18 Feb 2016 21:24:27 GMT

Thanks for this.

I assume Pick will give better performance than If (correct me if i'm wrong)

Also can we write the similar statement for the range of values as well?

Some thing like below....

Please respond.

=if(GetSelectedCount(Project) = 0,

if(Sum(Beneficiaries) <= 50,rgb(255,255,102),

if(Sum(Beneficiaries) >= 51 and Sum(Beneficiaries) <= 100,rgb(255,255,51),

if(Sum(Beneficiaries) >= 101 and Sum(Beneficiaries) <= 150,rgb(204,204,0),

if(Sum(Beneficiaries) >= 151 and Sum(Beneficiaries) <= 200,rgb(102,102,0),

if(Sum(Beneficiaries) > 200, rgb(51,51,0))))))

Re: Case Statement

MarcoWedel — Thu, 18 Feb 2016 22:27:51 GMT

Hi,

maybe like

Pick(Match(Ceil(Value,50),50,100,150,200),RGB1,RGB2,RGB3,RGB4)

regards

Marco