topic Need Help on an Expression in QlikView

Need Help on an Expression

Fri, 11 Oct 2013 11:38:10 GMT

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?

Fri, 11 Oct 2013 11:43:30 GMT

Try This

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

marcus_malinow — Fri, 11 Oct 2013 11:46:18 GMT

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')

Fri, 11 Oct 2013 11:47:49 GMT

Nope

Fri, 11 Oct 2013 11:48:13 GMT

Hi Marcus,

I tried that too,

Its not working

Fri, 11 Oct 2013 11:49:55 GMT

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

Fri, 11 Oct 2013 11:50:16 GMT

can you upload your sample

MayilVahanan — Fri, 11 Oct 2013 11:59:36 GMT

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.