Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yavoro
Partner - Contributor III
Partner - 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

Y.A.
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

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
Partner - Contributor III
Partner - Contributor III
Author

Thanks Liron, that works for me perfectly!

Y.A.
lironbaram
Partner - Master III
Partner - Master III

hei y

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