Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

?

.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: range condition

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
Highlighted
Contributor III
Contributor III

Re: range condition

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.

Highlighted
Specialist III
Specialist III

Re: range condition

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

Highlighted
Creator III
Creator III

?

.

Highlighted
Master III
Master III

Re: range condition

Hi Agrim,

add

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

Regards,

Antonio

Highlighted
Specialist III
Specialist III

Re: range condition

Have a look at the attachment.