Two Values in Text Object

[#1]

Hi,

Ihave a simple requirement where i need to do the following:

EMPID Name Sal

1 A 10
2 B 20
3 C 30

I need to show:

Highest Salary is 30 and Name of Employee is C

How do i show the corressponding value to the max(Sal)

[#2 · Accepted solution]

Hi Chinmayfun,

You must be use the follow expression:

= concat({$<Sal = {$(=Max(Sal))} >} Name)

This will return you one or more Names that mach with the max sal.

I hope this help you.

Best regards.

[#3]

Hi Miguel,

Thanks a lot for the answer, it did solve my problem.

But I have still not very well understood the syntax. Would appreciate if you could explaing with some more examples.

Regards,

Chinmayfun

[#4]

Hi Chinmayfun,

Basicly the sentence has two parts:

Set analysis: {$<Sal = {$(=Max(Sal))} >} It will return the records whose have their Sal value equal to the Max(Sal) based on the actual selection (if you want to omit the selection use 1 instead of $).

Function concat: Takes the indicated field and concatenate every value from the resultant records.

See the qlikview help for more details.

Best regards.