Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.