topic Re: need help in qlikview logic in QlikView

need help in qlikview logic

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

I have field value called

IBM-CONTENT-NAVIGATOR

IBM-CONTENT-NAVIGATOR-CONT

IBM-CONTENT-NAVIGATOR-DEV

IBM-CONTENT-NAVIGATOR-UAT

I need the value like

IBM-CONTENT-NAVIGATOR

I have wriiten the logic in qlik as

UPPER(IF
(SubField(Depedent_CI_NAME,'-',-1) = 'CONT', SubField(Depedent_CI_NAME,'-CONT',1),
IF
(SubField(Depedent_CI_NAME,'-',-1) = 'DEV', SubField(Depedent_CI_NAME,'-DEV',1) ,
IF
(SubField(Depedent_CI_NAME,'-',-1) = 'UAT', SubField(Depedent_CI_NAME,'-UAT',1),Depedent_CI_NAME)))) as Depedent_CI_NAMES

I am not getting proper result

I am geeting like IBM

CAn anyone please help

Re: need help in qlikview logic

qlikapple — Fri, 05 Jul 2019 14:11:35 GMT

Can anyone please help

Re: need help in qlikview logic

Frank_Hartmann — Fri, 05 Jul 2019 14:37:02 GMT

maybe this:

subfield(YOURFIELD,'-',1)&'-'&subfield(YOURFIELD,'-',2)&'-'&subfield(YOURFIELD,'-',3) as new_Field

Re: need help in qlikview logic

sasiparupudi1 — Sat, 06 Jul 2019 15:35:09 GMT

x:
Load
IF(SubStringCount(A,'-')=3,Left(A,Index(A,'-',3)-1),A) AS AA,
A;
Load * Inline
[
A
IBM-CONTENT-NAVIGATOR
IBM-CONTENT-NAVIGATOR-CONT
IBM-CONTENT-NAVIGATOR-DEV
IBM-CONTENT-NAVIGATOR-UAT
];

Re: need help in qlikview logic

qlikapple — Mon, 08 Jul 2019 06:33:42 GMT

It is working only for that particular value(IBM-CONTENT) only.

i have thousands of fields in which -CONT will come last, i need to remove the last 4/3 letters which are ending with

-CONT,-DEV and -UAT .

i have thousands of names lke this

example1:

3DAYS-BPM-CONT == i want to remove CONT here

example2:

if 2FA-STRONG-AUTHENTICATION-HBFR-DEV id there i want to remove DEV here

Can anyone please help.

i have written like this

But

Re: need help in qlikview logic

sasiparupudi1 — Mon, 08 Jul 2019 08:53:56 GMT

May be try

x:
Load
If(Match(SubField(A,'-',-1),'DEV','CONT','UAT')>0,Left(A,Index(A,'-',-1)-1),A) As AA,
A;
Load * Inline
[
A
IBM-CONTENT-NAVIGATOR
IBM-CONTENT-NAVIGATOR-CONT
IBM-CONTENT-NAVIGATOR-DEV
IBM-CONTENT-NAVIGATOR-UAT
2FA-STRONG-AUTHENTICATION-HBFR-DEV
3DAYS-BPM-CONT
];

Re: need help in qlikview logic

qlikapple — Mon, 08 Jul 2019 11:01:47 GMT

By my logic

=PICK( MATCH(SubField(UPPER(Depedent_CI_NAME),'-',-1), 'DEV', 'UAT','CONT'),
SubField(Depedent_CI_NAME,'-DEV'),
SubField(Depedent_CI_NAME,'-UAT'),
SubField(Depedent_CI_NAME,'-CONT'), Depedent_CI_NAME)

example:

ACCESS-CONTROL-CHECK-IN-SYSTEM-ITALY-CONT

i am getting the name as ACCESS only

why because it is taking ACCESS-CONTROL and here itslf it is taking as ACCESS

but i need as ACCESS-CONTROL-CHECK-IN-SYSTEM-ITALY

Re: need help in qlikview logic

Navars — Tue, 09 Jul 2019 11:23:50 GMT

Hi try the below one, it will work

temp:

load * ,

if(Right(AA,5)='CONT1' , Replace (AA,'-CONT1',''),

if(Right(AA,3)='DEV', Replace(AA,'-DEV',''),

if(Right(AA,3)='UAT', Replace(AA,'-UAT',''),

AA))) as AAA

;

Load

if(Right(A,4)='CONT', A&'1',A) as AA ;

Load * Inline [

IBM-CONTENT-NAVIGATOR

IBM-CONTENT-NAVIGATOR-CONT

IBM-CONTENT-NAVIGATOR-DEV

IBM-CONTENT-NAVIGATOR-UAT

3DAYS-BPM-CONT

2FA-STRONG-AUTHENTICATION-HBFR-DEV

];

Re: need help in qlikview logic

qlikapple — Fri, 12 Jul 2019 08:55:55 GMT

hi sasi

thnks for help.