Forum Discussion

edvapran's avatar
edvapran
New Member
8 years ago
Solved

group data by dimension (aggr function in qlik sense)

Hi, there's no way to say this problem easily.. I have 3 tables: POS current month data table (item, location code, datetime, sales amount) plan table (location code, latitude,longitude, sales pl...
  • edvapran's avatar
    edvapran
    8 years ago

    Ok, I managed to find a solution, it has to with relationship, [Cross filter direction] has to be set to both directions. Have no idea why isn't this set as default...

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Generally add Location to your Legend and you will get your grouping.

  • edvapran's avatar
    edvapran
    New Member
    8 years ago

    Does not allow to add this field to Map's Legend.

    I have also tried to create a simple chart, same result, all locations show the same execution percentage.

    • edvapran's avatar
      edvapran
      New Member
      8 years ago

      Ok, I managed to find a solution, it has to with relationship, [Cross filter direction] has to be set to both directions. Have no idea why isn't this set as default...

       

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Bi-directional cross filtering used to be the default but they changed this some time back. Probably had to do with performance and that bi-directional cross filtering is often not necessary. It is more the exception than the rule.