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
senpradip007
Specialist III
Specialist III

Your might be wrong.

Try like:

IF("Project CPI"<0.9, 'Under Budget', IF("Project CPI" <=1, 'Within Budget', 'Over Budget' ))) as CostClassification

View solution in original post

5 Replies
jackhertel
Contributor III
Contributor III

I might go with something like:

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

              IF("Project CPI">=0.9 and "Project CPI"<=1.0, 'Within Budget',

                  IF("Project CPI">0.9, 'Under Budget'

           ))) as CostClassification

FROM [lib://vvv/vvvv.xlsx]

(ooxml, embedded labels, table is Projects);

Put both conditions in the Withing Budget part of the statement with an 'and' Boolean operator.

senpradip007
Specialist III
Specialist III

Your might be wrong.

Try like:

IF("Project CPI"<0.9, 'Under Budget', IF("Project CPI" <=1, 'Within Budget', 'Over Budget' ))) as CostClassification

xyz1
Creator III
Creator III
Author

.

antoniotiman
Master III
Master III

Hi Agrim,

add

Where [Project CPI] >= 0.9 and [Project CPI] <= 1;

Regards,

Antonio

senpradip007
Specialist III
Specialist III

Have a look at the attachment.