topic Re: Grouped if or else in QlikView

Grouped if or else

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Iam trying to created 3 rows in one field by grouping for which i am not getting the proper result .

Below is my script can you please help on this .

Script :

if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(not wildmatch(Status,'Accepted','Proceed'),'Rejected')
and
if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(wildmatch(Status,'Closed'),'In_Progress')
and
if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(not wildmatch(Status,'Rejected'),'Built')))))) as Grouped,

Thanks in Advance

Re: Grouped if or else

Taoufiq_Zarra — Wed, 21 Oct 2020 08:39:17 GMT

can you share a sample data and the expected output ? @smilingjohn

Re: Grouped if or else

MayilVahanan — Wed, 21 Oct 2020 09:37:59 GMT

Hi @smilingjohn

Can you try like below

if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(wildmatch(Status,'Closed'), 'In_Progress',
if(not wildmatch(Status,'Accepted','Proceed'),'Rejected',
if(not wildmatch(Status,'Rejected'),'Built')))))as Grouped