topic Re: Line graph X-axis values sorting in QlikView

Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 14:01:11 GMT

Hi,

I have a data like

Product Sales

1 100

2 25

3 50

4 15

I wanna plot Product on X-axis like 4 2 3 4 but not 1 2 3 4 so as to get the continuous line.

Can anyone help me

Attached is my current applicaiton.

Re: Line graph X-axis values sorting

sunny_talwar — Thu, 18 Jun 2015 14:02:28 GMT

Hey Mark

I think you forgot to attach. Please attach it again.

Best,

Sunny

Re: Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 14:03:53 GMT

Hi Sunny,

How are you?

Here is my attachment.

Re: Line graph X-axis values sorting

giakoum — Thu, 18 Jun 2015 14:04:35 GMT

use dual when you load product. text can be the product name and number the order you need it.

if you sort by product in your chart, it will sort by number not text

Re: Line graph X-axis values sorting

Kushal_Chawda — Thu, 18 Jun 2015 14:06:33 GMT

Create a line chart with Dimension: Product & Expression : Sum(Sales)

Now go to chart properties and go to sort Tab, check Y-value Ascending

Re: Line graph X-axis values sorting

sunny_talwar — Thu, 18 Jun 2015 14:07:36 GMT

See if this helps (Sorting on Y-value Ascending)

Re: Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 14:13:03 GMT

Sunny, i tried that but the X-axis values were loading from 1. So, it still shows the same result.

Re: Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 14:24:27 GMT

Hi,

Its still the same result.

Re: Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 14:24:48 GMT

Hi Ioannis,

Can you please explain it.

Re: Line graph X-axis values sorting

sunny_talwar — Thu, 18 Jun 2015 14:28:59 GMT

Isn't this what you want?

Re: Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 14:32:46 GMT

Hi Sunny,

That was an example i stated.

But its not working with my actual data since i have to select the option "Continuous" in the chart as the data on X-axis is huge.

U can find my app. in the attachment.

Re: Line graph X-axis values sorting

sunny_talwar — Thu, 18 Jun 2015 14:38:01 GMT

The chart in attached qvw is empty. Do you want to repost the qvw after adding the dimension and expression back with your required settings.

Best,

Sunny

Re: Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 14:41:28 GMT

I Apologize for the mistake.

Here is the actual app.

Re: Line graph X-axis values sorting

markgraham123 — Thu, 18 Jun 2015 15:31:33 GMT

I was wondering why does it take so much time when i use continuous option in the line chart.