topic Re: How to show the largest possible value in a text object? in QlikView

How to show the largest possible value in a text object?

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

HI!

How can we show the largest possible value in a text object?

For example:

Customer | Sales

ABCD | 500

EFGH | 700

IJKL | 300

MNOP | 1000

so the text box should output : MNOP 1000 something like that. But when for example EFGH become 1100 for the next month, the text object will output EFGH 1100 automatically.

Thanks

Re: How to show the largest possible value in a text object?

PrashantSangle — Thu, 11 Apr 2019 09:16:52 GMT

Use FirstSortedValue()

try below
FirstSortedValue(Customer,-Sales)

Regards,
Prashant

Re: How to show the largest possible value in a text object?

Vengatesh — Thu, 11 Apr 2019 09:28:33 GMT

Try This:
=FirstSortedValue(Customer,Sales,1)&' - '& Max(AGGR(Sum(Sales),Customer))

Re: How to show the largest possible value in a text object?

PrashantSangle — Thu, 11 Apr 2019 09:42:58 GMT

if you want value Value along with customer number
then use
FirstSortedValue(Customer,-Sales)& ' ' & FirstSortedValue(Sales,-Sales)

Regards,

Re: How to show the largest possible value in a text object?

JoeyPob1214 — Thu, 11 Apr 2019 11:51:06 GMT

what is the meaning of "-" in the sales? if may I ask?

Re: How to show the largest possible value in a text object?

PrashantSangle — Thu, 11 Apr 2019 15:15:39 GMT

he used '-' just to add additional string between Customer and Sales .
So your final output will look like
EFGH-1700

Re: How to show the largest possible value in a text object?

sergio0592 — Thu, 11 Apr 2019 18:01:30 GMT

I think Joey asks for - in your First Sorted Value expression :

FirstSortedValue(Customer,-Sales)& ' ' & FirstSortedValue(Sales,-Sales)

So, here - , it means that the function returns the last (highest) sorted value.

Re: How to show the largest possible value in a text object?

JoeyPob1214 — Fri, 12 Apr 2019 01:19:27 GMT

hi, why does the Customer name doesn't show up? Thanks