4 Replies Latest reply: Aug 31, 2011 2:48 AM by Tanel Rüütli RSS

    When inputfields don't interact

      Hi all,

       

      I am probably missing something quite simple in my code here but can't seem to figure it out.

       

       inputfield BudgetPrognosis;
      /*************************BUDGET DATA******************************/
      BudgetTemp:
      CrossTable(BudgetYear, BudgetAmount, 1)
      LOAD autonumber(Office & ' ' & EmployeeID) as BudgetKey, 
           [2005], 
           [2006], 
           [2007], 
           [2008], 
           [2009]
      FROM
      [D:\DOX\BOOKS\KNOWLEDGE_ENGINEERING\QLIKVIEW\TRAINING\Developer II\Chapter04\Datasources\Budget.xls]
      (biff, embedded labels, header is 1 lines, table is Sheet1$, filters(
      Replace(1, top, StrCnd(null))
      ));
      
      Budget:
      LOAD BudgetYear, 
      BudgetAmount,
      BudgetKey, 
      rowno() as Counter,
      BudgetAmount as BudgetPrognosis
      
      Resident BudgetTemp;
      drop table BudgetTemp;
      
      
      Resident BudgetTemp;
      drop table BudgetTemp;
      

       

      When I create a table box, I don't see those little interaction icons on the inputfield 'Budget Prognosis'.

       

      However, when I do this, I am able to edit the Budget Prognosis values using the input field.

       

       

       

      inputfield BudgetPrognosis;
      /*************************BUDGET DATA******************************/
      BudgetTemp:
      CrossTable(BudgetYear, BudgetPrognosis, 1)
      LOAD autonumber(Office & ' ' & EmployeeID) as BudgetKey, 
           [2005], 
           [2006], 
           [2007], 
           [2008], 
           [2009]
      FROM
      [D:\DOX\BOOKS\KNOWLEDGE_ENGINEERING\QLIKVIEW\TRAINING\Developer II\Chapter04\Datasources\Budget.xls]
      (biff, embedded labels, header is 1 lines, table is Sheet1$, filters(
      Replace(1, top, StrCnd(null))
      ));
      

       

       

      I am showing data in the table box from two tables, the above table and the SalesPerson which apparently is connected to the Budget via an Employees Table.

       

      Keys:

      (Budget {BudgetKey}

      Employee {BudgetKey, EmployeeID}

      SalesPerson {EmployeeID}

      )

       

      Apparently the keys are also complete.

       

      I am using QV 10 SR3 Release 9061 (the latest)

       

      Thanks in Advance

        • Re: When inputfields don't interact
          Tanel Rüütli

          I guess inputfield does not like dropping a table BudgetTemp that contains same fields as it's final table Budget. Try to load BudgetTemp with temp fields:

           

           inputfield BudgetPrognosis;
          /*************************BUDGET DATA******************************/
          BudgetTemp:
          CrossTable(tmpBudgetYear, tmpBudgetAmount, 1)
          LOAD autonumber(Office & ' ' & EmployeeID) as tmpBudgetKey,
               [2005],
               [2006],
               [2007],
               [2008],
               [2009]
          FROM
          [D:\DOX\BOOKS\KNOWLEDGE_ENGINEERING\QLIKVIEW\TRAINING\Developer II\Chapter04\Datasources\Budget.xls]
          (biff, embedded labels, header is 1 lines, table is Sheet1$, filters(
          Replace(1, top, StrCnd(null))
          ));
          
          Budget:
          LOAD tmpBudgetYear as BudgetYear,
          tmpBudgetAmount as BudgetAmount,
          tmpBudgetKey as BudgetKey,
          rowno() as Counter,
          tmpBudgetAmount as BudgetPrognosis
          
          Resident BudgetTemp;
          drop table BudgetTemp;