Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

1 Solution

Accepted Solutions
xyz1
Creator III
Creator III
Author

9 Replies
prma7799
Master III
Master III

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

tamilarasu
Champion
Champion

Hi Agrim,

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

Kushal_Chawda

LOAD "Project

CPI",

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

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

xyz1
Creator III
Creator III
Author

.

prma7799
Master III
Master III

PFA....

xyz1
Creator III
Creator III
Author

.

prma7799
Master III
Master III

could you share some sample output ...

What exactly you want

xyz1
Creator III
Creator III
Author

.

prma7799
Master III
Master III

Hi Ajit ,

I already gave you that solution

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

Please check above.