Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agrimroquette
Not applicable

range condition

hi,

i want get the values whose are between 0.9-1 as "Within Budget" eg. 0.91, 0.92, 0.93...0.99, 1

>=0.9 and <=1

i have this

[Data3]:

LOAD "Project

CPI",

        

          IF("Project

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

CPI"=0.9, 'Within Budget',IF("Project

CPI">0.9, 'Under Budget'

           ))) as CostClassification

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

(ooxml, embedded labels, table is Projects);

Tags (1)
1 Solution

Accepted Solutions
senpradip007
Not applicable

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

5 Replies
jackhertel
Not applicable

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.

senpradip007
Not applicable

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

agrimroquette
Not applicable

Re: range condition

Thanks for qlick reply

is there any possibility to use range between 0.9-1?


thanks


antoniotiman
Not applicable

Re: range condition

Hi Agrim,

add

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

Regards,

Antonio

senpradip007
Not applicable

Re: range condition

Have a look at the attachment.