0 Replies Latest reply: Nov 28, 2011 8:34 AM by Marcos Herrera RSS

    YTD and rolling 12 months problem

      Hi Dear QlikCommunity

       

      I have a problem, I need a pivot table in which indicators are displayed on a rolling 12 months, these indicators are formed by summing all, in the fact table is registered daily values for each of those accounts.


      I need the monthly value recorded in each period (Month - Year) is the YTD up to that period.
      What I'm trying to do is calculate the YTD loads the script but I got no success, for n the front end to implement the rolling 12 months.

      Any suggestions, to calculate the YTD in upload script?