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: 
Not applicable

Counting Ranks. I have no idea :/

I hope this is a simple task and that it is only me having problems because I am new to qlik.

Example:

I have 5 Products. And i have price information on that products for 3 online-shops

ProductShop A priceShop B priceShop C price
P1123
P2213
P3312
P4212
P5123

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:

productshopnameshopprice
abcsomeshop1337

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.

6 Replies
sunny_talwar

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.

Not applicable
Author

Can you please post more sample data & expected out put ?

Not applicable
Author

This is part of my fake/test-data I use:

data_shops.jpg

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: -

shop B:

Top1: 3 times

Top2: 5 times

Top 3: 1 time

As fake-Chart:

fake_chart.jpg

In a table it would be possible to show the AVG(position) per shop (if shop is the dimension in the table)

Not applicable
Author

Use advanced editor to attach the data file to the post.

Not applicable
Author

and where do i find this file on my disc?

or how can i export it?

Not applicable
Author

you mean this file?