0 Replies Latest reply: Apr 20, 2012 8:46 AM by Sonika Jain RSS

    creating a pivot table with static columns

    Sonika Jain

      Hi all,

       

      Am new to Qlikview and am stuck in a scenario where I have to migrate a reporting application in OBI to Qlikview. A sample table looks like below.

       

      I needed help on creating such a table. I have taken the option of Pvot table to depict this.

       

      Columns B,C,D,E, are fetched from database, while the column A has to be added synthetically .

       

      Please help on achieving this.

       

       

       


      Actual ResultsTrendActualYTD
      XPY-Q1PY-Q2PY-Q3PY-Q4CY-Q1CY-Q2CY-Q3CY-Q4Q1-CY/PYQ2-CY/PYQ3-CY/PYQ4-CY/PYCY/PY12 Month12 Month12 MonthYTD PYYTD CYYTD ChangeYTD Trend
      actualactualactual
      endingendingchange
      PYCY
      A$1,692






      -7.60%-6.40%1.30%1.60%-3.00%


      $1,619


      B$2,477






      -7.60%-5.00%3.00%1.50%-2.30%


      $2,394


      C$908






      6.90%1.30%1.70%7.00%4.10%


      $924


      D$1,002






      8.70%0.60%0.50%-3.10%1.80%


      $1,057


      E$401






      1.80%4.20%6.30%-3.30%2.40%


      $392


      F$1,476






      20.80%20.40%21.10%-5.40%14.60%


      $1,503