topic Max value from group in QlikView

Max value from group

ameygosavi — Sat, 16 Nov 2024 03:32:39 GMT

Hello,

I am very new to Qlikview and I wanted some help to get the maximum value from various groups in a list.

I have attached a snapshot of the expected output.

There are 3 dimensions, a, b, c. There are more than one values for each of them. I would like to create another column which would take the maximum values for a,b,c and throw the output in a table

I really appreciate the help.

Re: Max value from group

jonathandienst — Fri, 17 May 2019 12:49:54 GMT

Intended output

=max(total <Dimension> [Actual Value])

Re: Max value from group

Anil_Babu_Samineni — Fri, 17 May 2019 12:52:15 GMT

You want to do this in script or UI? Perhaps this

Max(TOTAL <Dimension> [Actual Value])

Re: Max value from group

ameygosavi — Fri, 17 May 2019 13:04:10 GMT

Thank you so much for responding to my post but here's what I get.

The output should be ideally replacing the low values with maximum values for each category.

Re: Max value from group

jonathandienst — Fri, 17 May 2019 13:12:24 GMT

These answers assume that a field named 'Dimension' is actually a dimension. If dimension is an expression, then it will be harder to do this. I suggest that you upload a small sample qvw with a representative set of data (does not have to be real, but should be structured like the real data) and the table with which you want help.

Re: Max value from group

ameygosavi — Mon, 20 May 2019 20:53:50 GMT

Unfortunately, the data is very confidential. I did come up with a workaround for my problem using the expression you suggested and also wrote a couple of other expressions to get the job done.

Thank you so much though