Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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

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