I hope this is a simple task and that it is only me having problems because I am new to qlik.
I have 5 Products. And i have price information on that products for 3 online-shops
|Product||Shop A price||Shop B price||Shop C price|
I choose prices which are equivalent with the ranks which would result from rRnk(-shopprice, 1, 1).
In my fake-data (excel)
I have no seperate field for each shop. I simply have this format:
What i want to get is a stacked bar-chart with shops as dimension.
The bars should stack the count of how often this shop has which rank (which price-position)
Thus shop A is 2 times cheapest, 2 times in the middle and 1 time the most expensive.
for now i have now idea how to count those different cases.
I think the structure you have right now is a better one from my point of view. You can add product as your 1st dimension and shopname as your second dimension and Sum(shopprice) or Avg(Shopprice) as your expression.
This is part of my fake/test-data I use:
What I want to do is:
1. For each product be able to tell who is top1 to topN shop based on the price.
I managed that with the FirstSortedValue (but if there are two on top1 using the rank would be better)
2. I want to see the distribution of price-positions per shop.
Thus with the given data shop A has:
Top1: 4 times
Top2: 6 times
Top 3: -
Top1: 3 times
Top2: 5 times
Top 3: 1 time
In a table it would be possible to show the AVG(position) per shop (if shop is the dimension in the table)