topic Re: Pivot Table, Double values in QlikView

Pivot Table, Double values

Anonymous — Wed, 04 Mar 2015 14:30:30 GMT

Hi,

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

background:

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?

Re: Pivot Table, Double values

awhitfield — Wed, 04 Mar 2015 17:00:23 GMT

Can you remove the forth dimension 'Malernr' ?

Re: Pivot Table, Double values

Anonymous — Thu, 05 Mar 2015 10:46:03 GMT

No. I need that dimension.

Re: Pivot Table, Double values

Thu, 05 Mar 2015 10:55:52 GMT

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'.