Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

yavoro
New Contributor III

Comparison table

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

Y

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: Comparison table

hi

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

3 Replies
lironbaram
Honored Contributor II

Re: Comparison table

hi

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

yavoro
New Contributor III

Comparison table

Thanks Liron, that works for me perfectly!

lironbaram
Honored Contributor II

Comparison table

hei y

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

Community Browser