How to Exclude range in If Condition

[sspawar88]

Hi Everyone,

I am creating calculated dimension in stacked Bar Chart.

Each bar in Chart gives 100% in which each stack has belongs to some defined ranges for colour.

Calculative dimension are as below:

if(param_name='TEMP' and (param_value)<='-1' and (param_value)>= '-10', 'Red',

if(param_name='TEMP' and (param_value)<= '-10.1' and (param_value)>='-13.9', 'Yellow',

if(param_name='TEMP' and (param_value)<= '-14' and (param_value)>='-17.9', 'Amber',

if(param_name='TEMP' and (param_value)<= '-20','Green')))

Problem is this If condition also consider below range:

param_value<=-18 & param value>=-19.9

it has to be excluded.

How to achieve this?

Thanks in Advance.

[sspawar88]

we are trying to exclude values from -18 to -19.9

[sasiparupudi1]

=if(param_name='TEMP' and (param_value)<='-1' and (param_value)>= '-10', 'Red',

if(param_name='TEMP' and (param_value)<= '-10.1' and (param_value)>='-13.9', 'Yellow',

if(param_name='TEMP' and (param_value)<= '-14' and (param_value)>='-17.9', 'Amber',

if(param_name='TEMP' and (param_value<=-20 and (not (param_value> -18  and param_value< 19.9))),'Green'))))

[sspawar88]

No..Its Not working. its still considering range which will exclude from showing.

have to try out some differerent way.

[#5]

Please upload a sample QVW with the issue for quick resolution.

Regards,

KKR