Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How to set values from 1 to 150 in qlikview?


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.

1 Solution

Accepted Solutions
Highlighted
Not applicable

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;

View solution in original post

6 Replies
Highlighted
Master III
Master III

can you post data source like excel

Highlighted
Not applicable

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;

View solution in original post

Highlighted
Partner
Partner

Hi Venkatesh,

Use Rand() function like the post below:

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

Best Regards,

François

Highlighted
Partner
Partner

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

Highlighted
Contributor II
Contributor II

Hi All,

Thanks for quick responce .

I appreciated all your answers.

The issue has been resolved.

BR,

Venkatesh

Highlighted
Partner
Partner

Great !

Another victory for the community 😉

Well done !

François