How to set values from 1 to 150 in qlikview?

[venkatesh61524]

Hi Folks,

i have one "GLAccount" filed. in this filed i have 200 GL account numbers. so i want to delcare as default values(from "1" & to "150").

For example:

In GLAccount field i have  1 to 200 numbers.

so how to pass 1 to 150 numbers in varable? here do we need to use variable or some other function?

please can any one brief explanation on this issue?

Regards

Venkatesh.

[arulsettu]

can you post data source like excel

[#3 · Accepted solution]

add rowno() as Index in your table with GLAccount filed and

use resident load like below

Temp:

Load

Rowno() as Index,

GLAccount;

Load *

resident Temp

where Index <=150;

drop table Temp;

[francoiscave]

Hi Venkatesh,

Use Rand() function like the post below:

http://community.qlik.com/message/584942#584942

Best Regards,

François

[francoiscave]

Venkatesh,

Have you always an issue ?

If your are satisfied, mark a response as correct or helpful to close this thread,

Thanks a lot,

François

[venkatesh61524]

Hi All,

Thanks for quick responce .

I appreciated all your answers.

The issue has been resolved.

BR,

Venkatesh

[francoiscave]

Great !

Another victory for the community 😉

Well done !

François