topic Re: Step Charts in QlikView

Step Charts

mrchristopher — Thu, 16 Feb 2012 16:33:58 GMT

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

Re: Step Charts

Thu, 16 Feb 2012 16:59:35 GMT

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

Re: Step Charts

mrchristopher — Fri, 17 Feb 2012 08:29:10 GMT

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

Re: Step Charts

mrchristopher — Fri, 17 Feb 2012 09:10:36 GMT

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

Chris