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

Create a graph with date and prices. HELP! URGENT!

Hi guys! I'm finishing my Master project in Business Intelligence, and I need a help from you, the most expert people.

I need to do a graph, who shows the prices for each hour, but the thing is, i don't need 365 lines (each day of a year) in the graph.

I want to pick a date from a calendar that I already do in QV, and this date works as input of what prices are gonna be shown on the graph.

HELP!

I attached an excel spreatsheet, extracted from the DDBB.

Hope you can help me!

Thanks in advance.

1 Reply
Not applicable
Author

Hi

I suggest to use crosstable function to transform your data

After you will  keep only 3 fields : Date,  Hour,  Value
Then it will be very easy to select a date and display the chart.

Look at the attachment

JJ