Discussion board where members can get started with QlikView.
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").
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?
add rowno() as Index in your table with GLAccount filed and
use resident load like below
Rowno() as Index,
where Index <=150;
drop table Temp;
View solution in original post
can you post data source like excel
Use Rand() function like the post below:
Have you always an issue ?
If your are satisfied, mark a response as correct or helpful to close this thread,
Thanks a lot,
Thanks for quick responce .
I appreciated all your answers.
The issue has been resolved.
Another victory for the community 😉
Well done !