Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

agrimroquette
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??

LOAD "Project

CPI",

IF("Project

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

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

1 Solution

Accepted Solutions
agrimroquette
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
prma7799
Honored Contributor III

Re: Condition check

Please check

LOAD "ProjectCPI",

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

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

if("ProjectCPI" > 0.85 ,

'Under Budget' ))) as CostClassification

Or

LOAD "ProjectCPI",

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

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

'Under Budget' )) as CostClassification

Or share some sample app

Re: Condition check

Hi Agrim,

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

Re: Condition check

LOAD "Project

CPI",

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

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

agrimroquette
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

prma7799
Honored Contributor III

Re: Condition check

PFA....

agrimroquette
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.

prma7799
Honored Contributor III

Re: Condition check

could you share some sample output ...

What exactly you want

agrimroquette
Contributor II

Re: Condition check

11.png22.png

agrimroquette
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 33.PNG

Community Browser