topic Re: Logic to compare the values wit different variation in QlikView

Logic to compare the values wit different variation

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

The Group1 shouldbe equal to Group2, as we need to follow the below logic to define the code. would you pleas help me to correct the code as I'm new to QlikView.

AAA = 'SECA ● SECB ● SECC’

AAA = 'SECB ● SECA ● SECC’

AAA = 'SECC ● SECB ● SECA’

AAA = ‘'SECC ● SECA ● SECB’

Group1	Group2
AAA	'SECA ● SECB ● SECC’

if(Group1)='AAA' and (Group2)='SECA ● SECB ● SECC' or (Group2)='SECA' and (Group2)='SECB' and (Group2)='SECC','Correct','Wrong' as Data,

Re: Logic to compare the values wit different variation

Clever_Anjos — Wed, 27 Jul 2016 17:48:07 GMT

if(

(Group1='AAA' and Group2='SECA ● SECB ● SECC')

or (Group2='SECA' and Group2='SECB● SECC','Correct','Wrong') as Data,

Re: Logic to compare the values wit different variation

sunny_talwar — Wed, 27 Jul 2016 17:48:31 GMT

Not entirely sure what you are doing, but you have some misplaced parenthesis:

If(Group1 = 'AAA' and Group2 = 'SECA ● SECB ● SECC' or (Group2 = 'SECA' and Group2 = 'SECB' and Group2 = 'SECC'), 'Correct', 'Wrong') as Data,

I am still not 100% sure if this is right, but may be if you can expand on the logic, we might be able to provide a better response

Re: Logic to compare the values wit different variation

Anonymous — Wed, 27 Jul 2016 19:02:49 GMT

Thanks for your response.

But when I try to update the following logic doesn't match. Please refer logic screenshot + attached qvw which I created.

Re: Logic to compare the values wit different variation

sunny_talwar — Wed, 27 Jul 2016 19:14:48 GMT

Try this out:

Group:

Load *

Inline

[Group1, Group2,

AAA, SECA ● SECB ● SECC

AAA, SECB ● SECA ● SECC

AAA, SECC ● SECB ● SECA

AAA, SECC ● SECA ● SECB

AAA, SECA ● SECB ● SECC ● SECD

AAA, SECA ● SECB

];

Groupnew:

LOAD Group1,

Group2,

If(Group1 = 'AAA' and Index(Group2, 'SECA') and Index(Group2, 'SECB') and Index(Group2, 'SECC') and Len(Trim(KeepChar(Group2, '●'))) = 2, 'Correct', 'Wrong') as Data

Resident Group;

Re: Logic to compare the values wit different variation

Anonymous — Thu, 28 Jul 2016 15:53:09 GMT

Thanks Sunny, it works well