topic Re: Recover the maximum value in a table in QlikView

Recover the maximum value in a table

Thu, 02 Jul 2015 12:22:13 GMT

Hello or hello again,

Do you know if it is possible to recover the maximum value for counting and for what mode the maximum is reached. (in a table).

Thank you.

Re: Recover the maximum value in a table

Gysbert_Wassenaar — Thu, 02 Jul 2015 12:29:06 GMT

Something like max(aggr(count( SomeField ), Dim1, Dim2,..., DimN)) where Dim1, Dim2, ..., DimN the dimensions are over which the count is calculated.

Re: Recover the maximum value in a table

Thu, 02 Jul 2015 12:37:02 GMT

I would like to retrieve it in a text object.

I enter &max (aggr (count (SECTORS) [NumProduct])) & but it makes me value 1.

Re: Recover the maximum value in a table

sunny_talwar — Thu, 02 Jul 2015 12:49:11 GMT

Try this may be:

FirstSortedValue(Aggr(Count(SECTORS), NumProduct), -Aggr(Count(SECTORS), NumProduct))

Re: Recover the maximum value in a table

Thu, 02 Jul 2015 12:52:13 GMT

This does returns nothing.

Re: Recover the maximum value in a table

sunny_talwar — Thu, 02 Jul 2015 12:57:54 GMT

Would you be able to share a sample?

Re: Recover the maximum value in a table

Thu, 02 Jul 2015 13:02:22 GMT

A sample of? Table?

The table is the following :

The formula for 205 and 190 is : count([No product])

Re: Recover the maximum value in a table

sunny_talwar — Thu, 02 Jul 2015 13:10:38 GMT

Assuming your Dimension name is SECTEURS, try this:

=Max(Aggr(Count([No product]), SECTEURS))

Re: Recover the maximum value in a table

Thu, 02 Jul 2015 13:16:52 GMT

Thank you very much, It recovers the maximum. But is it possible to get to what sector it has reached the maximum?

Re: Recover the maximum value in a table

sunny_talwar — Thu, 02 Jul 2015 13:18:28 GMT

Sure:

Try this:

=FirstSortedValue(SECTEURS, -Aggr(Count([No product]), SECTEURS))

Re: Recover the maximum value in a table

Thu, 02 Jul 2015 13:21:49 GMT

Oh thank you very much ... You are awesome!

Re: Recover the maximum value in a table

sunny_talwar — Thu, 02 Jul 2015 13:22:57 GMT

No Problem

I am glad it worked.

Best,

Sunny

Re: Recover the maximum value in a table

sunny_talwar — Thu, 02 Jul 2015 13:46:00 GMT

Please close the thread by marking correct and helpful answers, so that it can prove useful for people in the future.

Thanks,

Sunny