Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try This
if(QST_ID='1473' or ANS_ID='6263',Y)
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')
Nope
Hi Marcus,
I tried that too,
Its not working
=if(QST_ID=1473 And ANS_ID=6263,Y)
can you upload your sample
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.