How do I turn my electricity usage data into a daily graph?

[#1]

Hello QC,

   This is my first post so I hope I can get my problem across accurately. My company has a commitment to show it's environmental impact and one of these includes graphically showing our daily electricity usage. I have attached the spreadsheet which I download monthly from our electricity supplier (Scottish Power). On the first tab is the type of graph I would like display in Qlikview, you can see how I have selected the row of 1/2 hourly values for a given day and plotted the values (I have used the column headers as the axis text)

In Qlikview I would like to be able to have a selection box showing the dates available and when a date is selected the daily usage is shown.

Is this possible, or has Qlikview met it's match with this spreadsheet layout?

Thanks

John

[#2]

Hello john,

you can start by using your date field as a list box and then create a Line Chart with the Date time field as a Dimension and sum(Usage) as expression.

Thanks,

ANDY

[prieper · Accepted solution]

Think that you may normalize the data with the Crosstable-function, and then make your graph.

See the attached example

HTH
Peter

[pat_agen]

hi,

I hope I've saved your companty some Kwh

[#5]

Thanks Prieper & Pat.agen, both of your solutions were brilliant. Peter your very concise cross table of

is great.

Thanks

John