Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Creating a line chart without using continuous

Hi,

I'm struck at a point where i have to display the data using Line chart.

Since i have thousands of records on X-axis, i have to use Continuous to show the trend at a time.

But when i use "Continuous" i'm not getting the order i need.

Can someone look in to the attached application and lemme know how can i load in the same order which is specified in the table of the application.

I'm trying to get o/p like the attached image.

2 Replies
Highlighted
Specialist
Specialist

SKU on x-axis and other dimension on Y-axis.

Highlighted

Hi,

one solution could be:

QlikCommunity_Thread_169026_Pic1.JPG

table1:

LOAD Dual(SKU#,RecNo()) as SKU#,

    [30-day Relative Velocity %]

FROM (txt, utf8, embedded labels, delimiter is '\t', msq, no eof);

hope this helps

regards

Marco