3 Replies Latest reply: Mar 5, 2015 5:55 AM by Gayan Jayakody RSS

    Pivot Table, Double values

    Marius Larsen


      I have created a pivot table, but I have a problem with values that come up twice. (See picture)


      I've made a QlikView model containing hourly values of our electricity meters.
      All electricity meters are connected to a measuring point ID. (Measuring point ID is the unique "fingerprint" of your electrical cabinets / Location)
      During the year, some of the power gauges been replaced, therefore it comes up two electricity meters per measuring point id.

      Is there any way to remove all the non active measurement numbers?

      Is there a way where you can remove all measures numbers which have not received hourly values in 2015?