topic Re: if else condition as Calculated Dimension in QlikView

if else condition as Calculated Dimension

sspawar88 — Mon, 20 Jul 2015 12:47:18 GMT

Hi ,

here i have stack bar chart for region.

each bar for each region is 100%.

Each color in stack bar chart have some range of param_value.

'Green' Color in Bar chart specifies temperature range <=-20 as per my if condition.

but it is also taking <=-18>=-19.9 range which is totally wrong. i don't want to show this range in bar chart.

i used calculated dimension are as following

if(param_name='TEMP',

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

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

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

if((param_value)<= '-20','Green')))))

( excluding values -18 to -19.9)

How can i Exclude Values in Between -18 to -19.9 in visualization of my stack bar chart?

Mon, 20 Jul 2015 12:52:05 GMT

Give diffrent color for between -18 to -19.9

MK_QSL — Mon, 20 Jul 2015 12:55:53 GMT

if(param_name='TEMP',

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

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

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

if((param_value)<= '-20' and (param_value <= '-18' and param_value >='19.0') ,'Green')))))

Mon, 20 Jul 2015 12:56:40 GMT

if(param_name='TEMP',

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

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

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

if((param_value)<= '-20' and (param_value <= '-18' and param_value >='19.0') ,'Green')))))

sspawar88 — Mon, 20 Jul 2015 12:59:42 GMT

Hi Manish,

i don't want to include (param_value <= '-18' and param_value >='19.0') in my stack bar chart.

and as your comment i think you are doing completely opposite of this.