Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

nboccassini
Contributor

Static (dynamic) max on y axes

Hi all,

I want to set a dynamic value for a max axes. The automatic max value don't show the value as shown in image

The yellow expression is:

(((sum([FIELD A]+[FIELD B]))  /  Count(DISTINCT [FIELD C])) /

Above(((sum([FIELD A]+[FIELD A]))  /  Count(DISTINCT [FIELD C])))) -1

How I can calculate the max  of this expression?

Tags (4)
1 Reply

Re: Static (dynamic) max on y axes

Try something like this:


Max(Aggr(

(((sum([FIELD A]+[FIELD B]))  /  Count(DISTINCT [FIELD C])) /

Above(((sum([FIELD A]+[FIELD A]))  /  Count(DISTINCT [FIELD C])))) -1, yourDimension))


Best,

Sunny

Community Browser