topic Re: Series Chart in Qlikview in QlikView

Series Chart in Qlikview

Thu, 26 Sep 2013 19:59:47 GMT

Hello,

I am trying to create a chart like the screen shot attached.

In the chart, I want the x axis to be the Publication date, with the grouping done by publication. The Y axis will have results for # of Primary and Secondary stops, # of mins for Primary and Secondary Stops, and a total

Is this possible in Qlikview?

I am able to get all of the data into list boxes to validate it, but I am lost as to how to display this properly.

Re: Series Chart in Qlikview

Clever_Anjos — Thu, 26 Sep 2013 20:24:24 GMT

Similar, check if fits

Re: Series Chart in Qlikview

Fri, 27 Sep 2013 13:48:53 GMT

I can get it to show that way, but that is not the way my user wants it presented. Is there a way to display it like the screen shot I provided?

Re: Series Chart in Qlikview

Clever_Anjos — Fri, 27 Sep 2013 14:08:25 GMT

I dont see a way to do it pixel by pixel

Re: Series Chart in Qlikview

rwunderlich — Fri, 27 Sep 2013 17:12:30 GMT

The rule for having a grouped bar chart is that it must be two dimensions and one expression. So the trick here is to limit your chart to two dimensions. You can do that by combining Date & Pub together in a Calculated Dimension.

=Pub & ' ' & Date

You can make it multi-line by

=Pub & chr(10) & Date

However, multiple lines will only display on the axis if you choose the slanted or vertical orientation.

See attached.

-Rob

http://masterssummit.com

http://robwunderlich.com