Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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)

Output Required.jpg

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

1 Solution

Accepted Solutions
prieper
Master II
Master II

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

See the attached example

HTH
Peter

View solution in original post

4 Replies
Not applicable
Author

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
Master II
Master II

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

See the attached example

HTH
Peter

pat_agen
Specialist
Specialist

hi,

I hope I've saved your companty some Kwh

Not applicable
Author

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

1.jpg

is great.

Thanks

John