Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.