4 Replies Latest reply: Mar 27, 2018 4:38 AM by BHARATH KUMAR RSS

    YoY Percent Change in Straight table

    BHARATH KUMAR

      Hi,

       

      Is it possible to get Year-over-Year Comparison based on quarter by keeping Year as dimension in straight table as below example:

      YoY.JPG

      For example : 2012 Q1 Sales is compared with 2011 Q1 and percent difference is populated in 2012 Q1 Record.

      Is any workaround in Qlik, to get the same ?

       

      For data:

      https://community.tableau.com/servlet/JiveServlet/download/364331-59869/Sample%20-%20Superstore%20Subset%20(Excel).xlsx

       

      Thanks in advance

      Bharath