Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

creating a line graph

Hello - I am new to Qlik Sense and trying to create a line graph measuring revenue by month.  I am unable to align month on the y-axis as hoping.  Is there something I am missing?

11 Replies

Re: creating a line graph

Can you post a screeenshot of your problem?

-Rob

Not applicable

Re: creating a line graph

Please see attached.  I selected monthly dollars as my measurement, but

want them to appear on the X-axis and my customer on the Y-axis.

Re: creating a line graph

Expand the Presentation section in the chart properties and select the Horizontal orientation.

-Rob

Not applicable

Re: creating a line graph

Thanks for the feedback. Unfortunately, I do not have an option in the

Presentation section to choose Horizontal orientation.  Please see

attached.

Re: creating a line graph

My mistake. I was looking at bar chart options. Could you use a bar chart as a workaround? A line chart isn't typically used with a categorical value list customer.

Not applicable

Re: creating a line graph

It might be helpful to show what I'm attempting to replicate.  Please see

attached.  Is this doable in Qlik Sense?  I appreciate your time looking

into this for me.

bvk
Contributor II

Re: creating a line graph

Hi Matt,

What do you have for dimensions and what do you have as measures. I think you should be able to create it by having the following dimensions:

- Month

- Product

And measure

- sum(Revenue)

Or do you have the data for each month in a separate field? Like:

Jan 2013Feb 2013Mar 2013
Product 0
Product 1
Product 2
Product 3

In that case you need to change the way you load your data. This can be done using crosstable load (see http://help.qlik.com/sense/en-US/online/#../Subsystems/WorkingWith/Content/Scripting/ScriptPrefixes/...)

Re: creating a line graph

If I understand your example correctly, the Y axis is each customer, and the lines are a trend line over months? And each customer has it's own scale for the trendline?

-Rob

Not applicable

Re: creating a line graph

Yes, you are correct.

Community Browser