Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Go to Solution.
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
Thanks Liron, that works for me perfectly!
so please make this case as answered on so other can know that this question have an answer