topic Re: expression in QlikView

expression

everest226 — Thu, 12 Jan 2017 00:38:17 GMT

i have a table where i need to add a single column which will display if student pass or fail

the field from data model is

NOTE- in single column

Pass Ind: A Y/N 1/0 dual flag that indicates whether the Student pass
Fail Ind: A Y/N, 1/0 dual flag that indicates whether the student Fail

Any suggestion would be helpful

tamilarasu‌

stalwar1‌

Re: expression

Oleg_Troyansky — Thu, 12 Jan 2017 01:32:27 GMT

You need to explain your problem in a bit more detail, and possibly post a sample app. It's not too clear what is your issue.

Re: expression

rahulpawarb — Thu, 12 Jan 2017 05:29:58 GMT

Hello Everest,

I agree with Oleg; please elaborate your request.

However, I am just passing a guess answer. Use below expression to get the desired results.

if(A='Y' OR A=1, 'Pass','Fail') AS Status

Hope this will help.

Thank you!

Rahul

Re: expression

vinieme12 — Thu, 12 Jan 2017 05:39:31 GMT

Try below

Dual (If (A='Y','Pass','Fail'),If (A='Y',1,0)) as Status

Re: expression

tamilarasu — Mon, 16 Jan 2017 13:09:05 GMT

Hi Ujjwal,

Sorry for the delayed response. Could you explain your question a bit more or post some sample data and expected output? It would be easy for us to help you quickly.

Re: expression

everest226 — Tue, 17 Jan 2017 18:07:12 GMT

Thanks

if(A='Y' OR A=1, 'Pass','Fail') AS Status

works perfectly

Re: expression

rahulpawarb — Wed, 18 Jan 2017 04:52:34 GMT

Cheers...

Rahul