11 Replies Latest reply: Jun 12, 2012 6:08 AM by seydou coly RSS

    HELP NEEDED IN YOY CALCULATION

    Raj Vadde

      Hi qlikgurus,

       

      i need to calculate yoy calculation so logic is current year week-previous year week/previous year week

       

       

      so i 'm have week sequence num  field for 2yrs like 1(firstweek) to 104(last week)

       

       

      so i'm using expression like sum({1<WEEK_SEQUENCE_NUM={$(=ONly(WEEK_SEQUENCE_NUM)-52)}>}UNITS)

       

       

      I'm using  dimensions as month and name of the week and all the values are 0

       

      i'm doing this in pivot table

       

       

      can you please help with expression

       

      Thanks

      have a good day