topic Re: group in QlikView

group

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

Hi ALl

Hi i have a field name called lstatus and it has many type of status in it i wanted to grupou the below mentioned status as Close and other should be as it is

if(match(Lstatus('Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close',LStatus

Can someone please suggest me on this ?

Re: group

Anil_Babu_Samineni — Thu, 03 Aug 2017 11:44:44 GMT

Here you go?

if(match(Lstatus,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close',LStatus)

Re: group

arvind_patil — Thu, 03 Aug 2017 11:50:43 GMT

Hi John,

Try Below one:

if(Wildmatch(Lstatus,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close',LStatus) as FinalStatus

Thanks,

Arvind Patil

Re: group

balar025 — Thu, 03 Aug 2017 11:53:42 GMT

Try ApplyMap function.

StatusMapping:

Mapping Load * Inline

[

Status,Status1

Closed,Close

Training,Close

];

Data:

Load

LStatus,

ApplyMap('StatusMapping',LStatus,LStatus) as NewStatus;

Load * Inline

[

LStatus

Closed

Training

Open

];

Re: group

smilingjohn — Thu, 03 Aug 2017 12:15:08 GMT

It is giving is giving me the error for below script

if(WildMatch(Status,'New'), 'New',

if(WildMatch(Status,'In Progress'), 'In Progress',

if(WildMatch(Status,'Resolved'), 'Resolved',

if(WildMatch(Status,'Test'), 'Test',

if(WildMatch(Status,'*Blocked-*'), 'Blocked',

if(WildMatch(Status,'Failed'), 'Failed',

if(WildMatch(Status,'Code Review'),'Code Review',

if(WildMatch(Status,'SCCB'),'SCCB',

if(WildMatch(Status,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required','Close',))))))))))as Lstatus,

Re: group

balar025 — Thu, 03 Aug 2017 12:17:53 GMT

Have you tried below script?

StatusMapping:

Mapping Load * Inline

[

Status,Status1

Closed,Close

Training,Close

];

Data:

Load

LStatus,

ApplyMap('StatusMapping',LStatus,LStatus) as NewStatus;

Load * Inline

[

LStatus

Closed

Training

Open

];

Re: group

sunny_talwar — Thu, 03 Aug 2017 12:19:21 GMT

May be this

if(WildMatch(Status,'New'), 'New',

if(WildMatch(Status,'In Progress'), 'In Progress',

if(WildMatch(Status,'Resolved'), 'Resolved',

if(WildMatch(Status,'Test'), 'Test',

if(WildMatch(Status,'*Blocked-*'), 'Blocked',

if(WildMatch(Status,'Failed'), 'Failed',

if(WildMatch(Status,'Code Review'),'Code Review',

if(WildMatch(Status,'SCCB'),'SCCB',

if(WildMatch(Status,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close' ))))))))) as Lstatus,

Re: group

Chanty4u — Thu, 03 Aug 2017 12:27:23 GMT

Bro just wanted to know is it works or anything ?Sunny Talwar

instead of this if conditions can we create a inline table like below?

load * inline[

status,value

new, ,,,

...

,..............];

Re: group

sunny_talwar — Thu, 03 Aug 2017 12:28:35 GMT

Are you asking me?

Re: group

balar025 — Thu, 03 Aug 2017 12:29:30 GMT

Not advisable to use long if conditions.

Re: group

Chanty4u — Thu, 03 Aug 2017 12:29:47 GMT

yes bro your's only the approach is correct or not am asking

Re: group

sunny_talwar — Thu, 03 Aug 2017 12:31:39 GMT

Applymap with mapping load is definitely the way to go...

Re: group

Chanty4u — Thu, 03 Aug 2017 12:34:24 GMT

Ok bro thank you