2 Replies Latest reply: May 8, 2013 9:23 AM by Gysbert Wassenaar RSS

    Prior Year to sit under current year in a table

      Qlikview Community,

       

      My problem is that I would like to represent prior year under the dimension of current year.  However at the moment using this code:

       

      sum({<[SAP Year]={$(=[SAP Year]-1)}>}[Net Sales Local Currency]*[ER SAP CY])

       

      but getting this result:


      20122013
      Sales
      1,915,861
      Prior Year10,500,564

       

      But would like it to look like this:

       


      2013
      Sales1,915,861
      Prior Year10,500,564