Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

Line graph X-axis values sorting

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.

Tags (2)
13 Replies
MVP
MVP

Re: Line graph X-axis values sorting

Hey Mark

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

Best,

Sunny

markgraham123
Contributor II

Re: Line graph X-axis values sorting

Hi Sunny,

How are you?

Here is my attachment.

giakoum
Honored Contributor II

Re: Line graph X-axis values sorting

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

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

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

Highlighted
MVP
MVP

Re: Line graph X-axis values sorting

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

Capture.PNG

markgraham123
Contributor II

Re: Line graph X-axis values sorting

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

markgraham123
Contributor II

Re: Line graph X-axis values sorting

Hi,

Its still the same result.

1.png

markgraham123
Contributor II

Re: Line graph X-axis values sorting

Hi Ioannis,

Can you please explain it.

MVP
MVP

Re: Line graph X-axis values sorting

Isn't this what you want?

Capture.PNG

Community Browser