Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you post a screeenshot of your problem?
-Rob
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.
Expand the Presentation section in the chart properties and select the Horizontal orientation.
-Rob
Thanks for the feedback. Unfortunately, I do not have an option in the
Presentation section to choose Horizontal orientation. Please see
attached.
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.
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.
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 2013 | Feb 2013 | Mar 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/...)
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
Yes, you are correct.