topic Period Ranges in QlikView

Period Ranges

Thu, 18 Feb 2016 04:12:02 GMT

Hi Experts,

My Scenario:

I have to display more than 75% as Distinction, between 60-75% as Pass and less than 60% as Fail. My script as follows

If(Grade> 0.75, 1, 0) AS Distinction,

If(Grade>= 0.60 AND Grade<=0.75, 1, 0) AS Pass,

If(Grade< 0.60, 1, 0) AS Fail;

But not achieving the result.

Thanks in Advance!!

settu_periasamy — Thu, 18 Feb 2016 16:51:50 GMT

Try this..

if(Grade >0.75, 'Distinction',

if(Grade >=0.6 and Grade<=0.75, 'Pass', 'Fail')) as Stu_Grade

kaushiknsolanki — Thu, 18 Feb 2016 17:00:16 GMT

Hi,

You must try nested if statement like below.

If(Grade> 0.75, 'Distinction', If(Grade>= 0.60 AND Grade<=0.75, 'Pass',if(Grade< 0.60, 'Fail'))) as Result

Regards,

Kaushik Solanki