Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
anisha_nan
Contributor II
Contributor II

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
bharathadde
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 🙂

anisha_nan
Contributor II
Contributor II
Author

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
bharathadde
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.