topic Re: Line chart - axis formatting in QlikView

Line chart - axis formatting

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm looking at a QV app that was created by someone else. How do you format the x-axis so the text is

being shown at an "angle"? See attached screenshot. I've looked through the settings for Line Chart but not able

to determine which property to set or configure. Please kindly let me know.

Re: Line chart - axis formatting

Anonymous — Tue, 22 Nov 2016 18:46:41 GMT

Nevermind, i just found it. It's under Primary dimension label.

Re: Line chart - axis formatting

Anonymous — Tue, 22 Nov 2016 18:58:41 GMT

Re: Line chart - axis formatting

Anonymous — Tue, 22 Nov 2016 19:00:16 GMT

Thanks Marcio.

Re: Line chart - axis formatting

Anonymous — Tue, 22 Nov 2016 19:02:41 GMT

Your welcome.

Re: Line chart - axis formatting

Anonymous — Wed, 23 Nov 2016 13:42:28 GMT

I have another question but related to my initial screenshot. The x-axis has labels like "JUL-2011" which composes of the month and the year. How do you format it so that it comes out in chronological order with JULY being the first month of the fiscal year and JUNE being the last? I tried using the DUAL() function but it did not work for me.

I get multiple years (example: I see 2014 when I picked 2016). In my table, I have a field called MonthYear which is already formatted to JUL-2011, AUG-2011 .... JUN-2012. I also have another field called MonthSort - example 1 for JUL, 2 for AUG and 12 for JUN. Finally in my load statement, I have something like DUAL(MonthYear, MonthSort) as 'MonthYear'.

This does not work. My x-axis has years that I don't expect to have.

Can someone help?