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.

=

aggr(rank(sum(Net)),Client

)

is there ay other way that i can use .

Thanks

1 Reply
Not applicable

Re: Min, Max Value

HI,

You could try this.

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

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

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

Regards,

Janzen

Community Browser