Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a data like
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.
I think you forgot to attach. Please attach it again.
How are you?
Here is my attachment.
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
Create a line chart with Dimension: Product & Expression : Sum(Sales)
Now go to chart properties and go to sort Tab, check Y-value Ascending
See if this helps (Sorting on Y-value Ascending)
Sunny, i tried that but the X-axis values were loading from 1. So, it still shows the same result.
Its still the same result.
Can you please explain it.
Isn't this what you want?