8 Replies Latest reply: Feb 23, 2012 2:25 AM by thomaswelle RSS

    Ranking expression without using dimension

      Hi all,


      I would need your help with a problem I'm currently trying to solve (if it can be solved at all)


      I'm using geoqlik to show maps, the problem is, that I cant use a dimension in their forground analysis.


      I would like to know if it is possible to solve the following problem without a dimension or by putting a dimension into an expression:


      In order to color area, I would need to get the rank for Brand XY based on Sum(Sales) in each area.


      I have the solution in a basic table where I can sort the rank and it looks like this:


      aggr(rank(sum({<CYTD={1}>}Sales)),Area,Brand)  but here I have a calculated dimension: if(Brand='xy', Brand)


      then it shows me


      Area      Rank


      xyz1          1

      xyz2          1

      xyz3          1

      xyz4          2



      So would it be possible to bring this Expression and the calculated Dimension together into an Expression?


      You genious ideas are much appreciated..