How to load Dimension Dynamically

[#1]

i have a table of dept

id	Name	locid
1	Finance	10
2	Account	20
3	Sales	30
4	HR	10
5	Finance	20
6	Finance	30
7	HR	20

now i want to

FOR mycounter = 1 to 3

loc & $(mycounter)*10: //dynamically dimenstion name

load

id as loc & $(mycounter)*10 & "_id",

name as loc & $(mycounter)*10 & "_name";

SQL

SELECT

id,name

FROM dept

where locid = $(mycounter)*10;

NEXT

mycounter is multiplying with 10

there are syntax errors

i want

loc10:

loc20:

lco30:

three dimension

can i do this in qlikview?

[tresesco]

possibly you are missing Quotation marks (Single). You have to use 'LOC' rather than simple LOC, because it would be treated as string. when you put LOC alone, QV finds for field of the same name.

Hope this helps you.

Regards, tresesco