2 Replies Latest reply: Jun 28, 2018 12:38 PM by Isaias Darci RSS

    How to write set analysis for display current year

    NURUL ATIKAH

      Hi,

       

      I am using Qlik Sense and want to use set analysis to display Current Year and Previous year. I already try a few expression but not working to me. Can anyone help me ?

       

      I have field name Order Date and sales in this case

       

      Here is a few expression that I try :

      SUM({$<Year={$(=MAX(Year))}>}Sales)

      SUM(${<Year={"$(=Year(Today()))"}>}Sales)

       

       

      Thank You

      Nurul