Discussion board where members can get started with QlikView.
I have a requirement where i need to shaow Min/Max/Avg values
The O/P should be
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 .
You could try this.
Average - num(avg(Rev),'##')
Min - num(min(Rev),'###')
Max - num(max(Rev),'###')