topic Two Values in Text Object in QlikView

Two Values in Text Object

Fri, 11 Dec 2009 13:10:21 GMT

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)

Two Values in Text Object

Fri, 11 Dec 2009 14:52:19 GMT

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.

Two Values in Text Object

Tue, 15 Dec 2009 11:39:04 GMT

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

Two Values in Text Object

Tue, 15 Dec 2009 15:15:06 GMT

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.