topic Re: Max/Min/Avg for straight table in QlikView

Max/Min/Avg for straight table

anisha_nan — Sat, 16 Nov 2024 21:13:02 GMT

Hi ,

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

Please find the attached data set of it.

Regards

bharathadde — Tue, 19 Mar 2019 18:46:17 GMT

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 — Wed, 20 Mar 2019 09:25:49 GMT

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 — Wed, 20 Mar 2019 15:34:34 GMT

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

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