1 Reply Latest reply: Feb 21, 2011 4:22 AM by Tresesco B RSS

    How to load Dimension Dynamically

      i have a table of dept

       

      idNamelocid
      1Finance10
      2Account20
      3Sales30
      4HR10
      5Finance20
      6Finance30
      7HR20

      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?