2 Replies Latest reply: Sep 4, 2018 2:26 PM by Gabriel Rodrigues RSS

    How to use Only(Year) when the main dimension is Year already

    Gabriel Rodrigues

      Hello everybody,.

      I have been introduced to the world of Qliksense early this year and there is a case that I cant solve by myself.

      So, my goal is to create a table with 3 columns: Year, amount and growth (The diference between year and the year before).

       

      1.PNG

      So, no biggie, right? But my ancient ape brain cannot create a function for this damn third column

      I've been using the Only() function but with no success.

      This is what I'm trying rn:

      Sum({<Ano={"=(Only(Ano)-1)"}>}[Qtde KG])

      Ano=Year and [Qtde KG] = Amount

       

      Thanks for your time.