Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-11-28 08:34 AM

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?

1,278 Views
0 Likes
0 Replies