6 Replies Latest reply: Feb 10, 2016 3:28 PM by Edgar Lensing RSS

    Counting Ranks. I have no idea :/

    Edgar Lensing

      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.