topic Re: Reference to Same Table in QlikView

Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 15:39:32 GMT

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....

Re: Reference to Same Table

giakoum — Mon, 17 Feb 2014 15:45:19 GMT

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?

Re: Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 15:55:17 GMT

Can you upload your result QVW file?

Re: Reference to Same Table

giakoum — Mon, 17 Feb 2014 15:59:32 GMT

i don't have one

do you have a sample application?

Re: Re: Reference to Same Table

giakoum — Mon, 17 Feb 2014 16:05:06 GMT

see attached

Re: Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 16:05:49 GMT

Sample file enclosed.

Re: Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 16:09:26 GMT

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.

Re: Re: Reference to Same Table

giakoum — Mon, 17 Feb 2014 16:11:15 GMT

more detailed

Re: Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 16:19:34 GMT

We must need Customer field.

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

Re: Re: Reference to Same Table

IAMDV — Mon, 17 Feb 2014 16:55:22 GMT

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

I hope this helps!

Cheers,

Re: Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 17:05:14 GMT

Looks OK but only concern is Customer1 vs Customer2 table now shows list of all Cusotmers... !!

Re: Reference to Same Table

IAMDV — Mon, 17 Feb 2014 17:08:17 GMT

Sorry, I didn't get that one. Please can you explain in detail?

Update - I get it... I'm fixing that one. Ignore my previous message.

Thanks,

Re: Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 17:10:11 GMT

Re: Reference to Same Table

giakoum — Mon, 17 Feb 2014 19:54:06 GMT

Use either customer1 or customer2 as customer field. there is no difference.

Re: Reference to Same Table

MK_QSL — Mon, 17 Feb 2014 23:51:31 GMT

any reply on this?

Re: Reference to Same Table

maxgro — Mon, 17 Feb 2014 23:59:09 GMT

see attachment, hope it helps you

Re: Reference to Same Table

IAMDV — Tue, 18 Feb 2014 11:10:29 GMT

Hi Manish - I think Massimo solved this one for you. Are you happy with the result?

Thanks,