Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

Max value bar chart

Hello,

I have a bar chart (see below) for which:

- The dimension is G

- The measure is a count (ID_number)

I would like to display in a simple KPI the maximum value of the bar chart (39)


Sceenshot.png

Could you help me writting the formula that will allow me to have the max value of the G dimension ?

Thank you in advance

Stephane

1 Solution

Accepted Solutions

Re: Max value bar chart

Try this

Max(Aggr(Count(ID_number), G))
2 Replies

Re: Max value bar chart

Try this

Max(Aggr(Count(ID_number), G))
Partner
Partner

Re: Max value bar chart

perfect thanks