If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
So I have created a rolling statement
MEMBER [Measures].[12Months Rolling Value] AS
,ParallelPeriod([Date].[Calendar].[Date], -1, [Date].[Calendar].CurrentMember)
//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