Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you post a screeenshot of your problem?

-Rob

Not applicable
Author

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

Not applicable
Author

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

Presentation section to choose Horizontal orientation.  Please see

attached.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Author

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.

Anonymous
Not applicable
Author

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/...)

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Author

Yes, you are correct.