8 Replies Latest reply: May 7, 2018 4:06 AM by Helge Jørgensen RSS

    Set analysis - Year-to-date

    Helge Jørgensen

      Hi qlik expert.

       

      I have started to use this master calendar; https://community.qlik.com/docs/DOC-8642 , and now I would like to start using the date-function in qlik. I have tried with different set-analysis but with no success.

       

      I would like the sum of values for year-to date, and previous year to the same date (previous year. 04.05.2018 and 04.05.2017)

      I have tried using this expression for YTD.

      Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=YearStart(Today()))<=$(=Today())’}, ElementID= {RR}>} [Vaerdata.Verdi])

       

      But it doesn’t work. Does some have a suggestion? Do I use wrong master calendar script?

       

      Thanks

       

      Cheers
      Helge