Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

];

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Dim: Name

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

PFA

View solution in original post

2 Replies
tresesco
MVP
MVP

Dim: Name

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

PFA

Not applicable
Author

Thanks a lot for a very quick and correct answer!

Olav