2 Replies Latest reply: Oct 16, 2017 8:50 PM by fu li RSS

    Qlik Sense  set analysis to calculate YTD for last year according to the year selection

    fu li

      I want to compare the number of Quote of the last year(From the year begin to the max QuoteDate in current year) to current year YTD, the current year can be choosed  in the filter panel.

      For example, the max QuoteDate of current year is 10/10/2017,If I choose 2016 in the filter panel, I want to see the Quote numbers from 1/1/2015 to 10/10/2015

       

      222.png

      I use this :

      Count( distinct [QuoteNo] )-Count({<[QuoteDate.autoCalendar.Year]={"$(=(year(([QuoteDate.autoCalendar.Year]))-1))"},[QuoteDate.autoCalendar.Year]=>} distinct [QuoteNo] )distinct [QuoteNo] )  but it not work ......