Compare a single data information with a set of data information

[Anonymous]

Dear community, I'm having the following problem that I hope you can help me with:

I have the following information about products that are selled from my company and some others:

My company
Product	Price
banana	1
Apple	2
Pear	3

Company B
Product	Price
banana	4
Apple	5
Pear	6

CompanyC
banana	3
Apple	2
Pear	1

Company D
banana	2
Apple	1
Pear	3

What I want to do, is that if I pick the product "banana" from my company, qlikview shows me all the other products that are named the same way with their respective price.

All of that I want to display it on a chart.

So far I can only compare by clicking on each table and only my company with one of the others, not all at the same time.

Is there a function that can help me do this?

can anybody help me please?

best regards.

[sunny_talwar]

How exactly is the data getting loaded into QlikView? Can you share your script you are using right now and also the expression you are using?

[sunny_talwar]

May be load the data like this:

Table:

LOAD Product,

          Price,

          'My Company' as [Company Name]

Inline [

Product, Price

Banana,	1
Apple,	2
Pear,	3

];

Concatenate (Table)

LOAD Product,

          Price,

          'Company B' as [Company Name]

Inline [

Product, Price

Banana,	4
Apple,	5
Pear,	6

];

Concatenate (Table)

LOAD Product,

          Price,

          'Company C' as [Company Name]

Inline [

Product, Price

Banana,	3
Apple,	2
Pear,	1

];

Concatenate (Table)

LOAD Product,

          Price,

          'Company D' as [Company Name]

Inline [

Product, Price

Banana,	2
Apple,	1
Pear,	3

];

And then create a chart with

Dimensions: Product and Company Name

Expression: Sum(Price)

[Anonymous]

The data is loaded from excel files.

and the file is something like this:

CompanyName	ProductName	Price
Mine	Apple	1
Mine	Banana	2
Mine	pear	3
B	Apple	4
B	Banana	5
B	pear	6
C	Apple	3
C	Banana	2
C	pear	1
D	Apple	2
D	Banana	1
D	pear	3

[sunny_talwar]

Look at the attached qvw file to see if that helps.

Best,

Sunny