How to load Dimension Dynamically

Mon, 21 Feb 2011 08:40:34 GMT

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?

How to load Dimension Dynamically

tresB — Mon, 21 Feb 2011 09:22:18 GMT

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

topic How to load Dimension Dynamically in QlikView

How to load Dimension Dynamically

How to load Dimension Dynamically