topic Re: Max value in QlikView

Max value

trishita — Wed, 25 Nov 2020 16:16:04 GMT

I want to find max value in a chart expression.The field I used max[Fuel Surveyed] on expression.BUt it shows garbage after expression "Fuel Surveyed" and not showing the max values in report.Any solution

Re: Max value

shruthibk — Tue, 29 May 2018 10:43:50 GMT

max([Fuel Surveyed]) do you get an error after this expression?

Re: Max value

shiveshsingh — Tue, 29 May 2018 11:44:14 GMT

May be you missed the brackets max([Fuel Surveyed])

can you share sample data and expected output?

Re: Max value

Miguel_Angel_Baeyens — Tue, 29 May 2018 11:45:44 GMT

Use this. Also make sure that the field is spelled capitalized as in the data model, QlikView is case sensitive also for the names of the fields.

Re: Max value

trishita — Wed, 30 May 2018 08:07:15 GMT

The problem is that I want to show only the corresponding max values from a set of records..but now syntax is working but it s not showing me the largest value in a set of records

Re: Max value

trishita — Wed, 30 May 2018 08:09:55 GMT

Re: Max value

VishalWaghole — Wed, 30 May 2018 08:34:01 GMT

max([Fuel surveyed])

Your s should be small one.

Re: Max value

trishita — Wed, 30 May 2018 09:57:09 GMT

still not working

Re: Max value

trishita — Wed, 30 May 2018 09:59:14 GMT

vishalwaghole‌

Re: Max value

shruthibk — Wed, 30 May 2018 10:05:46 GMT

can you please share the QVW?

Re: Max value

trishita — Wed, 30 May 2018 10:13:23 GMT

i did changes to my qvw only.but how can u access it if you dont have the required qvd s

Re: Max value

trishita — Wed, 30 May 2018 10:19:44 GMT

shruthibk‌ HOW CAN I SEND THE QVW::HERE THERE IS NO SUCH OPTION::

Re: Max value

shiveshsingh — Wed, 30 May 2018 10:34:11 GMT

Use advanced editor option and the attach

Re: Max value

shruthibk — Wed, 30 May 2018 10:36:52 GMT

Use the advanced editor, right side you will find attach icon and share the expected output as well

Re: Max value

trishita — Wed, 30 May 2018 12:53:01 GMT

Please find the attachment

Re: Max value

buzzy996 — Wed, 30 May 2018 13:38:27 GMT

try this

Re: Max value

Miguel_Angel_Baeyens — Thu, 31 May 2018 06:39:23 GMT

What's wrong with that? The Max() expression is working fine. Which result do you expect instead?

Re: Max value

tresB — Thu, 31 May 2018 06:52:16 GMT

Not sure what you are trying to get. If you need to get the max value irrespective of the dimensions, try

= Max( Total [Fuel per last Noon])

Re: Max value

trishita — Thu, 31 May 2018 14:07:04 GMT

The problem is I just want to see the records corresponding to the maximum value of the fuel per last noon..but it shows all

Re: Max value

Miguel_Angel_Baeyens — Thu, 31 May 2018 14:12:21 GMT

Then you need to use TOTAL as Tresesco mentions below, or even Aggr() to get one value based on whatever the field for "value of the fuel per last noon" it is instead of the Max() per line, as you are currently getting.

Max(TOTAL <[Last Noon]> [Fuel surveyed])

Aggr(Max([Fuel surveyed]), [Last Noon])

or even

FirstSortedValue(Max([Fuel surveyed]), -[Last Noon]) // the "-" before the date field means descending order / most recent first