Discussion board where members can get started with Qlik Sense.
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?
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.
Thanks for the feedback. Unfortunately, I do not have an option in the
Presentation section to choose Horizontal orientation. Please see
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.
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:
Or do you have the data for each month in a separate field? Like:
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?
Yes, you are correct.