0 Replies Latest reply: Jan 3, 2017 2:45 AM by Shrujan Shah RSS

    I need help to chart year over year CPI

    Shrujan Shah

      Hello community, I am novice to qlik sense.

      I have attached the file and I will try to describe my question as simple as I can.

      I want to create a chart which measure consumer price index, year over year.

      First, I want to set 2006 as benchmark = 1. And then divide 2007 to 2006. 2008 to 2007 and so on.

      How I can achieve it? How Can I set expression to make it happen?

      Please see attached file for that.

      (price_index_year is the column which is mentioning the column of years so Please disreagard the first column as it is character string.)

       

      Thank you for any suggestion or hint.

      Happy new year,

      Shrujan