topic Re: Creating a line chart without using continuous in QlikView

Creating a line chart without using continuous

markgraham123 — Thu, 18 Jun 2015 19:55:59 GMT

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.

markgraham123 — Thu, 18 Jun 2015 19:56:41 GMT

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

MarcoWedel — Thu, 18 Jun 2015 22:48:36 GMT

Hi,

one solution could be:

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