# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Contributor II

## Condition check

Hi All,

i have made this formula to achive

<(less than 0.75) over budget

between(o.75-0.85)within budget

&

>(Greater than 0.85)-underbudget

PLEASE CHECK IS THIS RIGHT CONDITION??

CPI",

IF("Project

CPI"<0.75, 'OverBudget', IF("Project

CPI" <=0.75,  'Within Budget','Under Budget' )) as CostClassification

Tags (3)
1 Solution

Accepted Solutions
Contributor II

## Re: Condition check

Thanks Friends i got my perfect results via this:-

IF("Project

CPI" > 0 and "Project

CPI" <0.75, 'OverBudget',

IF("Project

CPI" >= 0.75 and "Project

CPI" < 0.85 ,  'Within Budget',

if("Project

CPI" >= 0.85 ,

'Under Budget' ))) as CostClassification

11 Replies
Honored Contributor III

## Re: Condition check

IF("ProjectCPI" < 0.75, 'OverBudget',

IF("ProjectCPI" >= 0.75 and "ProjectCPI" <= 0.85 ,  'Within Budget',

if("ProjectCPI" > 0.85 ,

'Under Budget' ))) as CostClassification

Or

IF("ProjectCPI" < 0.75, 'OverBudget',

IF("ProjectCPI" >= 0.75 and "ProjectCPI" <= 0.85 ,  'Within Budget',

'Under Budget' )) as CostClassification

Or share some sample app

MVP

## Re: Condition check

Hi Agrim,

IF("Project CPI" < 0.75, 'OverBudget', IF("Project CPI" <= 0.85,  'Within Budget','Under Budget' )) as CostClassification

MVP

## Re: Condition check

CPI",

IF("Project CPI" <0.75, 'OverBudget',

IF("Project CPI" >0.85,'Under Budget','Within Budget')) as CostClassification

Contributor II

## Re: Condition check

Hi Kushal,

Can you please check the results, its showing wrong results, i am attching my excel file, select Phase =Project and than see the calculations are wrong.

Thanks

Honored Contributor III

PFA....

Contributor II

## Re: Condition check

Hi, PM

No. of project must be 39+4+2=45 that’s correct,

but, Project CPI less than <0.75=3(OverBudget) false result 39 in pie chart,

Like wise Project CPI Greater Than>0.85=3(UnderBudget) false result 4 in pie chart

but i am not getting these results can you please confirm from Excel file.

Honored Contributor III

## Re: Condition check

could you share some sample output ...

What exactly you want

Contributor II

Contributor II

## Re: Condition check

in my attached images you can see my result that are

but, Project CPI less than <0.75=3(OverBudget) false result 39 in pie chart,

Like wise Project CPI Greater Than>0.85=3(UnderBudget) false result 4 in pie chart

but in pie chart its