6 Replies Latest reply: May 30, 2017 5:53 AM by Dima OStrovsky RSS

    How to add column into table which will be calculated disregarding one of two dimensions?

    Dima OStrovsky

      Hi everyone!)
      ... am relatively new to Qlik Sense but already got tricky task.
      Need to add measure column to table which already has two dimensional columns.

       

      Warehouse Code | Product Code | MyMeasureColumn

       

      Tricky part - MyMeasureColumn should be calculated depending on Product Code but also based on data of all warehouses (at which this product is available) not just one warehouse in table row.


      If it's possible, how to avoid forced data slicing imposed by one dimensional column of QLik Sense table ?
      Exactly table column slicing not selection.

       

      Thanks in advance!