Color elements of calculated dimension

Fri, 07 Aug 2015 16:57:12 GMT

Hi,

I have a chart with a calculated dimension including if statements

e.g.

[...]

IF( AGGR(
		COUNT(
			{<
				data_type_key={'profitability'}
				,version_single_key={'Actual'}
				,%measures_key={'$(v_select_measure)'}
				,period_year={'<$(v_select_mr_end)>$(v_select_mr_start)'}
				,fiscal_year
			>}material_count_key
		)
	,
		material_count_key
	) > 50

DUAL('>= 3.500 EUR and > 50pcs', 2)

[...]

Now I would like to color all elements with '>= 3500 EUR and > 50pcs' red.

But how can I refer to a calculated dimension?

Thank your for your help.

Best

Simon

Re: Color elements of calculated dimension

sunny_talwar — Fri, 07 Aug 2015 17:02:59 GMT

Use this may be for the background color of your dimension:

IF(AGGR(COUNT({<data_type_key={'profitability'},version_single_key={'Actual'},version_single_key={'Actual'},%measures_key={'$(v_select_measure)'},period_year={'<$(v_select_mr_end)>$(v_select_mr_start)'},fiscal_year>}material_count_key), material_count_key) > 50, Red())

topic Color elements of calculated dimension in QlikView

Color elements of calculated dimension

Re: Color elements of calculated dimension