Step Charts

[mrchristopher]

I am creating a dashboard to track price changes within our contracts where prices are fixed for a period of time and remain constant until the next price review, we normally present this data as a step chart, is there a way to create this type of visualisation in Qlikview?

I have included an example of the type of data that I am working with below.

Part,  Start, Expire, Price
Widget X, Jan-10, Jun-10, 1.00
Widget X, Jul-10, Dec-10, 1.10
Widget X, Jan-11, Jun-11, 0.88
Widget X, Jul-11, Dec-11, 1.01
Widget X, Jan-12, Jun-10, 1.11

Any help would be kindly appreciated.

Many Thanks

Chris

[#2 · Accepted solution]

Hello,

If i understand your question, you can do step chart with a line chart.

I do an example in attachment. I hope that can help you.

Regards.

Rod

[mrchristopher]

Many Thanks Rod, that was a lot easier than I imagined, I changed the display options in my chart to Plateau (trailing) and I almost have the visulisation I need. The other feature of the step chart that I am looking for is the dimension axis that acts as a time line so that we can see the period of time between each price review.

Chris

[mrchristopher]

I've added a master calender and unchecked the supress zero values in the presentation options and here is the finished example.

Chris