Need Help on an Expression

[#1]

This is my sql output .I am loading in a QVD.

  I have to check the following condition in qlikview.

I will have Person_Key as Select field.

and In a expression i will check for that PersonKey:

if(QST_ID='1473' AND ANS_ID='6263','Y')

But Y is not getting displayed.

Any help?

[#2]

Try This

if(QST_ID='1473' or ANS_ID='6263',Y)

[marcus_malinow]

Are your values text or numeric?

If they're numeric then removing the quotes may help - if(QST_ID=1473 AND ANS_ID=6263,'Y')

[#4]

Nope

[#5]

Hi Marcus,

I tried that too,

Its not working

[#6]

=if(QST_ID=1473 And ANS_ID=6263,Y)

[#7]

can you upload your sample

[MayilVahanan]

HI

Try like this

TableA:

Load *, if(QST_ID=1473 AND ANS_ID=6263,'Y', 'N') As Flag;

Select * from TableName;

Store TableA into TableA.qvd(qvd);

Then check in the TableA.qvd once.

Edit:

Note:

You have More rows for the single PersonId, If you need to check in expression,

Use PersonID, QST_ID, ANS_ID as dimension and Then use that in if(QST_ID=1473 AND ANS_ID=6263,'Y', 'N') in expression.