7 Replies Latest reply: Nov 25, 2016 12:53 AM by Jerry Xie RSS

    Calculating Month-over-Month and Yoy Based on current selection

    Priyash shahane

      Hey guys,


      I am working on this app in qlik sense wherein i have chart with a column x, % change x MOM, % change x YOY

      In my load script i have the date


      Load "x",

      date(date,'MMM-YY') as "month_year",



      ( I have other columns but they are not relevant to the question)


      In my sheet i have a Filter Pane with month_year as the dimension


      So the way i want it to be is that firstly when user selects a month-year from the filter pane. the chart should populate with entries as following:


      website - x - MOM% change in X - YOY% change in x


      Here web_site is a dimension rest all are measures.


      I tried using various formulae for MOM from the qlik community but doesn't seem to work.

      What my best attempt was using set analysis:


      Sum({$<month_year= {"<=$(=date(getfieldselections(month_year)))"}>})total_unique_visitors for the current month

      and using the same expression but just month_year - 1 for previous month.


      However this does not result in any value. Can anyone please point out the error here. or suggest an easier approach