topic Re: two conditions in if statement in QlikView

two conditions in if statement

yogitamehta10 — Mon, 03 Jul 2017 23:02:37 GMT

Hi all,

I have a expression

what I want to do here is if criteria no Q9 and its assessment is 'Y'

and then it should match with criteria no P11 and its assessment is 'Y'

if both value should be Y then only it would be Y for a ID otherwise it would be 'No'

not sure I'm using right expression or not.

I have a field table a

ID brand criteria assesement

123 abc Q9 Y

145 abc Q9 Y

ID brand criteria assesement

123 abc P11 Y

145 abc P11 N

one id can be used for different criteria.

if (if([CriteriaNo=('Q9'),AssessmentManual=('Y')) and if(CriteriaNO=('P12'),Assessment=('Yes')), 'Yes','No')

anyhelp??

Re: two conditions in if statement

Anil_Babu_Samineni — Mon, 03 Jul 2017 23:59:20 GMT

May be this

if(match([CriteriaNo,'Q9','P12'),if(match(Assessment,'Y') , 'Yes','No'))

Re: two conditions in if statement

vinieme12 — Tue, 04 Jul 2017 05:57:52 GMT

Try below

if(Count({<[CriteriaNo]={'Q9','P11'},AssessmentManual={'Y'} >} ID)=2, 'Yes','No')

Re: two conditions in if statement

arvind_patil — Tue, 04 Jul 2017 06:21:11 GMT

Hi Yogita,

I have a doubt criteria P9 and P11 are available in same table or Different.

Thanks,

Arvind Patil

Re: two conditions in if statement

yogitamehta10 — Tue, 04 Jul 2017 08:49:23 GMT

P9 and Q11 are in different table I need to match the values of it on the basis of ID.

Suppose ID

table 1

ID brand criteria assesement

123 abc P11 Y it has value Y for ID 123 and I have to match this with is Q9 that is in table 2 then if both are Y then its Y otherwise N

145 abc P11 N

table 2

123 abc Q9 Y

145 abc Q9 Y

Re: two conditions in if statement

vinieme12 — Tue, 04 Jul 2017 08:53:28 GMT

have you tried the expression i posted above

Re: two conditions in if statement

yogitamehta10 — Tue, 04 Jul 2017 09:15:13 GMT

this is not the way. I want both conditions to be true only then it can become yes.

P11 and Q9are in different table I need to match the values of it on the basis of ID.

Suppose ID

table 1

ID brand criteria assesement

123 abc P11 Y it has value Y for ID 123 and I have to match this with is Q9 that is in table 2 then if both are Y then its Y otherwise N

145 abc P11 N

table 2

123 abc Q9 Y

145 abc Q9 Y

Re: two conditions in if statement

girish2195 — Tue, 04 Jul 2017 09:23:48 GMT

Hi Yogita,

Try this.

what I want to do here is if criteria no Q9 and its assessment is 'Y'

and then it should match with criteria no P11 and its assessment is 'Y'

if((Criteriano='Q9' and Assesment='Y') and ((Criteriano=P11and Assesment='Y'),'Y','N')

Regards,

Girish Kumar DV