Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Color elements of calculated dimension

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

1 Reply
MVP
MVP

Re: Color elements of calculated dimension

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())

Community Browser