11 Replies Latest reply: Oct 10, 2018 12:06 PM by Daniel Berkes RSS

    Current YTD vs Previous whole year showing together

    Daniel Berkes

      Hi,

       

      I have a line chart where I would like to display the current YTD and the previous full year.

       

      The prev full year should be displayed with the current year values together e.g from JAN 2018 till DEC 2018 and not from JAN 2017 till DEC 2017.

       

      With this, the prev vs curr can be compared easily.

       

      I was able to solve it, with above function i shifted the previous year's value but when I do selection I lose prev year values.

      Which make sense since Qlik Sense ( ) evaluate the prev year expression in the selected dims (2018) .

       

      could you suggest solution which can be applied in frontend?

       

      Thanks,

      Daniel