So I have created a rolling statement
WITH
MEMBER [Measures].[12Months Rolling Value] AS
SUM(
(ParallelPeriod(
[Date].[Calendar].[Year]
,1
,ParallelPeriod([Date].[Calendar].[Date], -1, [Date].[Calendar].CurrentMember)
)
:
[Date].[Calendar].CurrentMember)
,[Measures].[Sales]
)
//and have it at the beginning of my query before selecting the measures from a hierarchy
//this works when I run it in SQL server management studio but not in Qlik sense and I am unsure on why this is.
//Any help on this issue would be greatly appreciated
