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?