topic Compare a single data information with a set of data information in QlikView

Compare a single data information with a set of data information

Anonymous — Wed, 07 Oct 2015 21:24:04 GMT

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.

Re: Compare a single data information with a set of data information

sunny_talwar — Wed, 07 Oct 2015 21:30:10 GMT

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?

Re: Compare a single data information with a set of data information

sunny_talwar — Wed, 07 Oct 2015 21:34:14 GMT

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)

Re: Compare a single data information with a set of data information

Anonymous — Wed, 07 Oct 2015 21:36:20 GMT

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

Re: Compare a single data information with a set of data information

sunny_talwar — Wed, 07 Oct 2015 21:37:47 GMT

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

Best,

Sunny