topic Comparison table in QlikView

Comparison table

yavoro — Tue, 14 Feb 2012 13:08:03 GMT

Hi all,

I need fresh ideas on the following problem (please see the attachment):

I have list of prices from different companies for products (multiple prices for 1 product possible, because of partner companies, etc).

I want to count the number of times a competitor price is closest to my price where my price is best (rank 1).

But sometimes my company (partner) gives second best price as well, so I have to count third best price as a closest competitor one.

In the attached example I'm able to achive this when a product is selected. Table Closest Competitors would show what I want.But I don't know how to show the overall numbers.

Any ideas are welcome and much appreciated.

Thanks

Re: Comparison table

lironbaram — Wed, 15 Feb 2012 12:49:37 GMT

well i had to sleep on it

but here is an example of what you want

it uses first sorted value

hope it helps you

Comparison table

yavoro — Wed, 15 Feb 2012 14:48:38 GMT

Thanks Liron, that works for me perfectly!

Comparison table

lironbaram — Wed, 15 Feb 2012 14:50:40 GMT

hei y

so please make this case as answered on so other can know that this question have an answer