topic Re: Нow to create a line list of numbers? in QlikView

Нow to create a line list of numbers?

vtatarnikov — Thu, 21 May 2015 07:40:09 GMT

Sorry for the stupid question..

Нow to create a line list of numbers from 5 to 10 in increments of 1, for example?

Is there a simple function list(5,10,1)=(5,6,7,8,9,10)?

Re: Нow to create a line list of numbers?

avinashelite — Thu, 21 May 2015 07:41:15 GMT

use autogenerate function

Re: Нow to create a line list of numbers?

Thu, 21 May 2015 07:51:35 GMT

Hi,

use this =ValueLoop(5,10,1)

Re: Нow to create a line list of numbers?

Thu, 21 May 2015 08:24:49 GMT

Hi,

below should work for you, added the loop in to the weighting too so the order is as generated

Concat(ValueLoop(5,10,1),',',ValueLoop(5,10,1))

Joe

Re: Нow to create a line list of numbers?

vtatarnikov — Thu, 21 May 2015 09:03:33 GMT

autogenerate create the column.

I am used concat() for convert to string, but column(1,2,3,4,5,6,7,8,9,10,11)=string(1,10,11,2,3,4....)

how to sort in concat()?

Re: Нow to create a line list of numbers?

vtatarnikov — Thu, 21 May 2015 09:04:31 GMT

ValueLoop() not a script function

Re: Нow to create a line list of numbers?

Thu, 21 May 2015 09:25:19 GMT

Didn't realise you wanted this in the script, but concat has a weight sorting parameter so you can use that to sort

Re: Нow to create a line list of numbers?

avinashelite — Thu, 21 May 2015 09:32:37 GMT

Hi ,

What's your exact requirement ? need to generate the columns and sort rite ?

Load 5+RecNo() as num

AutoGenerate(5);

This will do...or do you need to link this with the filed and use for sorting ?? if so use dual() function and assign the number for it

Re: Нow to create a line list of numbers?

manojkulkarni — Thu, 21 May 2015 09:41:25 GMT

set vMax = 10;

set vStart = 5;

set vFreq=1;

Load ($(vStart)-1)+RecNo() as num

AutoGenerate($(vMax)-($(vStart)-1));

Re: Нow to create a line list of numbers?

vtatarnikov — Thu, 21 May 2015 10:17:03 GMT

Re: Нow to create a line list of numbers?

avinashelite — Thu, 21 May 2015 10:31:13 GMT

Hi ,

try adding order by statement for the second part of code like order by homeca... ASC ;

Re: Нow to create a line list of numbers?

Thu, 21 May 2015 10:47:20 GMT

The concat is doing as you asked and is sorting on the date field you have. If you want to retain the original line number list, use that in the sort weight instead.

Concat(LineNum,',',LineNum)

Joe

Re: Нow to create a line list of numbers?

vtatarnikov — Thu, 21 May 2015 11:51:24 GMT

ASC does not work

Re: Нow to create a line list of numbers?

vtatarnikov — Thu, 21 May 2015 11:52:50 GMT

Thanks, works!

Sadly what nen such a function list (5,10,1)