topic Re: Grouping in QlikView

Grouping

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

Hi IAM trying to give a new field name to this , but this script is howing wrong

Can someone suggest me the right of wrtiing this

if(match(Severity ='1 - Critical','Severity 1')and

if(Match( Severity ='2 - High','Severity 2' ) and ,

if(match( Severity ='3 - Medium','Severity 3')) as Seveity,

Thanks

Re: Grouping

arvind_patil — Tue, 18 Jul 2017 06:59:54 GMT

Hi John,

Please find below code it may help you:

if(wildmatch(Severity ,'1 - Critical'),'Severity 1',

if(wildmatch( Severity ,'2 - High'),'Severity 2' ,

if(wildmatch( Severity ,'3 - Medium'),'Severity 3'))) as Seveity

Thanks

Arvind Patil

Re: Grouping

smilingjohn — Tue, 18 Jul 2017 07:04:30 GMT

Thanks arvind ,

This works i also wanted to knowhow do we achieve this .

Cureently i have a field by Name Dept , under it i have New.Old and Brand ...Now i want to show it horizontally in a startight table , then how do i write the script for this ?

Actaul :

DEPT"

New

Old

Brand

expected : New Old Brand

Thanks

Re: Grouping

effinty2112 — Tue, 18 Jul 2017 07:09:05 GMT

Hi John,

This seems a simpler way to write this:

'Severity ' & Match(Severity,'1 - Critical','2 - High','3 - Medium')

'Severity ' & left(Severity,1)

Cheers

Andrew

Re: Grouping

smilingjohn — Tue, 18 Jul 2017 07:09:56 GMT

Do we need to do this at the script level ?

Re: Grouping

effinty2112 — Tue, 18 Jul 2017 07:13:01 GMT

Hi John,

No - use it in the interface it you want.

Cheers

Andrew

Re: Grouping

smilingjohn — Tue, 18 Jul 2017 07:23:31 GMT

hi Andrew

Sorry its not working

I want the horizontal representaion for DEPT ?

Cureently i have a field by Name Dept , under it i have New.Old and Brand ...Now i want to show it horizontally in a startight table , then how do i write the script for this ?

Actaul :

DEPT"

New

Old

Brand

expected : New Old Brand

Re: Grouping

arvind_patil — Tue, 18 Jul 2017 08:13:00 GMT

Please mark It.

Thanks,

Arvind Patil

Re: Grouping

arvind_patil — Tue, 18 Jul 2017 08:14:37 GMT

HI John,

With the help of Set analysis you can achieve this.

Thanks,

Arvind Patil