Ihave createda pivottable, but I have a problem withvaluesthat come uptwice. (See picture)
I've made aQlikViewmodelcontaininghourly valuesof ourelectricity meters. Allelectricity metersare connected toameasuring pointID. (Measuring point IDis the unique"fingerprint" of yourelectrical cabinets/Location) During the year, some of the powergaugesbeen replaced, thereforeit comesup twoelectricity metersper measuringpointid.
Is there any wayto removeall the nonactive measurementnumbers?
Is there a waywhere you canremove allmeasuresnumbers whichhave not receivedhourly valuesin2015?
Do you have a field such as 'In-Use' or similar which has a 'yes/no' value? If you do then you could add in a WHERE clause in the load script and filter those non-active meters eg: WHERE In-Use = 'Yes'.