Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
can you post data source like excel
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;
Hi Venkatesh,
Use Rand() function like the post below:
http://community.qlik.com/message/584942#584942
Best Regards,
François
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
Hi All,
Thanks for quick responce .
I appreciated all your answers.
The issue has been resolved.
BR,
Venkatesh
Great !
Another victory for the community 😉
Well done !
François