topic Re: Axis Sort & Scale in QlikView

Axis Sort & Scale

Fri, 28 Oct 2016 22:27:26 GMT

Hello Qlik Community!

I'm reaching out hoping to get some help on Axis Sorting & Scaling.

I have 2 charts: Line & Scatter Plot. I need to make sure that axis scale is identical on those 2 charts. The application automatically adjusted axis scale on the scatter plot. However, I am having trouble adjusting axis on the line chart to match it. I tried using class function to assign ranges, but this is not we are looking for.

The second issue is to adjust sorting on Scatter chart from oldest to newest (i.e. from 900 to 100). It seems that it should be pretty straight forward. However, I am having trouble finding the solution.

The picture is attached

Thank you for your help!

Re: Axis Sort & Scale

Frank_Hartmann — Sat, 29 Oct 2016 09:43:22 GMT

Can you upload a sample?

That would make it much easier to assist!

Re: Axis Sort & Scale

Sat, 29 Oct 2016 14:09:34 GMT

Here is qvd. Thank you for your help!

Re: Axis Sort & Scale

vinieme12 — Sun, 30 Oct 2016 10:46:51 GMT

For your First Part, round your days to nearest 100

your dimension will be : Round(Days,100)

Re: Axis Sort & Scale

vinieme12 — Sun, 30 Oct 2016 12:03:42 GMT

for the second part read this post

Reversing axes on scatter chart

Re: Axis Sort & Scale

Frank_Hartmann — Sun, 30 Oct 2016 12:04:55 GMT

and in addition to Vineeths proposal set axis to "continous":

Re: Axis Sort & Scale

Sun, 30 Oct 2016 17:06:54 GMT

Thank you so much! I was able to solve the first part. However, I'm still having trouble with the second one. I followed steps in the post above, in particular:

1. Changed Expression to: -Sum (days)

2. Checked Static max to 0 for x-axis

3. Set number to fixed to '#,##0'

I also tried multiplying by -1 to get rid off '-' in front of days. However, the numbers are still showing in negative format.