topic If statement in QlikView

If statement

akpofureenughwu — Tue, 11 Apr 2017 11:18:54 GMT

Hello sir,

I need to do an statement for a set of data like this

if(count({$<[Project Status] = {'Completed'} >}Community) /Count(Community)>=0.9,Green(),

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<0.9,LightGreen(),

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<0.5, Blue()

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<0.5,Red()))))

but it's not give me the desired result.

Regards

sunny_talwar — Tue, 11 Apr 2017 11:25:38 GMT

The last two conditions look the same, is that on purpose?

akpofureenughwu — Tue, 11 Apr 2017 11:27:54 GMT

Sorry sir,

if(count({$<[Project Status] = {'Completed'} >}Community) /Count(Community)>=0.9,Green(),

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<0.9,LightGreen(),

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<0.5, Blue()

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<=0.49,Red()))))

sunny_talwar — Tue, 11 Apr 2017 11:33:36 GMT

May be try this

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<=0.49,Red(),

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<0.5, Blue(),

if(count({$<[Project Status] = {'Completed'} >} Community) /Count(Community)<0.9,LightGreen(), Green())))

Peter_Cammaert — Tue, 11 Apr 2017 11:37:01 GMT

If we assume that IF() functions are evaluated in sequence, this expression only produces two colors:

The other expressions won't be evaluated because there will always be a match in the first two IF() calls.

Reorder your expression as:

IF (expr <= 0.49, Red(),

if (expr < 0.5, Blue(),

if (expr < 0.9, Lightgreen(),

Green())))

You may want to change the border values for the first two tests, because the blue color range will only match 0.49 < x < 0.5