Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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

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