Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Min, Max Value

Hello All,

I have  a requirement where i need to shaow Min/Max/Avg values

Client    Rev

1          100

2            50

3            75

4            25

5           -50

6           -25

The O/P should be

Max: 100

Min:   -50

Avg:    29  (For Avg the client can vary)

i was able to achieve max using the below as dimension and then hiding the dimension in the presentation.




is there ay other way that i can use .


1 Reply
Not applicable

Re: Min, Max Value


You could try this.

Average - num(avg(Rev),'##')

Min - num(min(Rev),'###')

Max - num(max(Rev),'###')



Community Browser