3 Replies Latest reply: Oct 5, 2013 7:15 AM by behnaz rezaei RSS

    Ristrict data to be show on table

    shariq ahmed

      I have source table like this

      authorityheadfiscal_ yeartype_idcommited_amtexpense

      IA

      4412002-2003L125005000
      IA4412003-2004L1500500
      IA

      441

      2009-2010

      F$500$100

      IA

      4412010-2012F$6555$1200
      IA4412012-2013L150003500
      IA4412013-2014L2000100

      I ONLY WANT TO SHOW A PIVOT TABLE IN QLIKVIEW

       

      with all records of type_id= 'L' and Fiscal year except maximum which is  2013-2014 in my case and

      note:

      max_year is a variable having value 2013-2014 in it

       

      KINLDY give a expression to achive in a pivote table

      having a dimenions

      =authority

      =head

      =fiscal_year

      =type_id

       

      expression

      for commited amt is  =sum({$<type_id={'L'}>}commited_amt)

      for expense   is  =sum({$<type_id={'L'}>}expense_amt)

       

      how to show data not including 2013-2014 row ???

       

      regards

       

      Fady