Evaluate several records in pivot/table, and only showing 1 record as a result

[#1]

Hi all,

Based on the following (see also attached .qvw file) I want to create a pivot/table that shows

Name, Yes / No

All names should only be shown once, and all names that have the Value 3 as a possible result should show Yes, the rest should show No.

I.e I want this result:

Arne, Yes

Harald, No

Jens,No

Olav, Yes

Any suggestions on how to solve this?

(I can solve this during scripting load, but I want to solve it without doing that).

Thanks,

Olav

--------------------------------------------

Table1:

LOAD * INLINE [

KeyField,Name

1,'Olav'

2,'Harald'

3,'Arne'

4,'Jens'

];

Table2:

LOAD * INLINE [

KeyField,Value

1,1

2,1

3,1

4,1

1,2

2,2

3,2

4,2

1,3

2,4

3,3

4,4

1,5

2,5

3,5

4,5

];

[tresesco · Accepted solution]

Dim: Name

Exp: If(Max(If(Value=3,1,0))=1, 'Yes', 'No')

PFA

[#3]

Thanks a lot for a very quick and correct answer!

Olav