distinct text from 3 tables

[wunderch]

Hello,

I have a .qvw with 3 tables. For example:

Table1:

Tour	Driver 1	Qualification
10	Peter	A, B, C

Table2:

Tour	Driver 2	Qualification
10	Paul	C, D

Table3:

Tour	Driver 3	Qualification
10	John	A, B

My Problem is:

When i select Tour 10, then i want to show in a listbox or a diagramm the result of Qualification from all Drivers

Tour	Qualification
10	A, B, C, D

Can anybody help me?

Thanks

Chris

[Jason_Michaelides · Accepted solution]

This may not work depending on your data schema but try:

Concat(DISTINCT Qualification,',')

as your expression, with Tour as your dimension.

Hope this helps,

Jason

[#3]

it wont work without 'total' qualifer

Vitul

[Jason_Michaelides]

Shouldn't need TOTAL if Tour is the only dimension.

[#5]

its not working even tour is the only dimension..........

Vitul

[wunderch]

Hi Jason,

do you also have a solution for this constellation:

1 Table:

Tour

Driver1

Qual1. Driver1

Qual2. Driver1

Qual.3 Driver1

Driver2

Qual1. Driver1

Qual2. Driver1

Qual.3 Driver1

Driver3

Qual1. Driver1

Qual2. Driver1

Qual.3 Driver1

10

Peter

A

B

C

Paul

C

D

John

A

B

Result

Tour

Qualifikation

10

A, B, C, D

Thanks

Chris

[#7]

its working...i had some problem with my data...

sry....

Vitul

[Jason_Michaelides]

How does the actual data look, Chris?  Can you post a sample?

[wunderch]

Here is a example.

TUTURN = Tour

TUFHR1 = Driver1

TUFHR2 = Driver2

TUFHR3 = Driver3

TUFHR1_ZQUA1 = Driver1_Qualification1

.

.

.

Result for TUTURN=1686386

TUTURN Qualification

1686386 KÜCHEN 1, KÜCHEN 2, KÜCHEN 3, MÖBEL 3, ELEKTRO

[Jason_Michaelides]

OK - got it.  You need to use Crosstable().  Please post your 2 QVD files:

ZQUA_TESTCW.qvd and TOUR_Ebene2_2012.qvd and I'll show you how.

Cheers,

Jason