topic Re: range condition in QlikView

?

xyz1 — Sun, 14 Apr 2019 14:39:59 GMT

jackhertel — Fri, 05 May 2017 07:15:03 GMT

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 — Fri, 05 May 2017 07:16:52 GMT

Your might be wrong.

Try like:

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

xyz1 — Sun, 14 Apr 2019 14:45:16 GMT

antoniotiman — Fri, 05 May 2017 09:00:55 GMT

Hi Agrim,

add

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

Regards,

Antonio

senpradip007 — Fri, 05 May 2017 09:31:31 GMT

Have a look at the attachment.