Reference to Same Table

[MK_QSL]

I have customer data table as below.

Customer	Country
A	Germany
B	France
C	Italy
D	Spain
E	Poland
F	Sweden
G	Turkey
H	Denmark

We are comparing two customers based on sales strength. Below is the table which is fixed to compare the customers.

Customer1	Customer2
A	D
B	F
C	E
H	G

I want to create a customer wise sales bar chart, so that if I select any customer from Customer List Box, the bar chart will show corresponding Customer1 vs Customer2 sales.

i.e. If i select G, the bar chart will reflect Sales for H & G.

Note : We have more than 200 customers, so the solution should be dynamic....

[giakoum]

so this is your link table :

Customer1	Customer2
A	D
B	F
C	E
H	G

and you need to load customer twice. one instance connected to customer1 (rename customer to customer1 in table customer) and the other connected to customer2. Does this make sense?

[MK_QSL]

Can you upload your result QVW file?

[giakoum]

i don't have one

do you have a sample application?

[giakoum]

see attached

[MK_QSL]

Sample file enclosed.

[MK_QSL]

No... Actually these two Customer1 and Customer2 should be linked with Customer,

so that when I select a particular customer from Customer List BOX,

I would get Customer1 and Customer2 data in two different column.

[giakoum]

more detailed

[MK_QSL]

We must need Customer field.

You are providing Customer1 and Customer2 fields but not Customer field.

[IAMDV]

Manish - How about this approach? See this makes sense.... this is completely dynamic.

I hope this helps!

Cheers,

DV