Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Max/Min/Avg for straight table

Hi ,

I want Max/Min/Avg each description wise and tool wise.

Please find the attached data set of it.

Regards

 

Labels (1)
3 Replies
Highlighted
Creator II
Creator II

Please find the attachment

Minimum Rate by ToolName

=Min(Total <ToolName>Rate)

Minimum Rate by Description1

=Min(Total <Description1>Rate)

Maximum Rate by ToolName

=Max(Total <ToolName>Rate)

Maximum Rate by ToolName

=Max(Total <Description1>Rate)

Average Rate by ToolName

=Avg(Total <ToolName>Rate)

Average Rate by Description1

=Avg(Total <Description1>Rate)

Hope this helps you 🙂

Highlighted
Contributor
Contributor

Hi,

Thanks for the quick response.

I want to min/max/avg of rate at description 1 level.

why we are using total in this not clear?

Regards
Highlighted
Creator II
Creator II

I'm not sure what exactly you want as output.

Can you send me sample output for the data I created on the app.