4 Replies Latest reply: Apr 4, 2018 10:01 PM by Simon Howard RSS

    Using 'Total <Dimension>' in a Pivot Table in Qlik Sense

    Simon Howard

      Hi,

       

      I am trying to use the total keyword in a pivot table, and am getting strange results. I am using a fact table structure similar to the following:

          

      StoreEmployeeSalarySale Amount
      ABob50000
      AAdam55000
      ASteve45000
      BGeoff47000
      BSandra70000
      BCharles56000
      BFelicity51000
      CBeth43000
      CCarter42000
      CDaniel39000
      CSusan53000
      CPamela57000
      CErin46000
      A 14963.95
      A31631.62
      A26528.53
      A12708.55
      A14206.99
      A95192.72
      A

      7123.50

       

      .. and so on. The reason the Salaries are included in the fact table is that these values are attached to a particular payslip, and can change over time. The sales are not recorded against any particular employee, just against the store.

       

      What I am trying to achieve is to display the sum of sales for that store, against each employee in a pivot table. The values are displayed correctly against the store, until a node is expanded, where each value is then turned to 0:

      2018-04-04_16-19-25.png

      2018-04-04_16-21-20.png

      What I am trying to achieve is the Sum figure of $437,227.12 is displayed in this column for Adam, Bob and Steve.

       

      Thanks.