Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Hi all I'm new to Qlik sense and had a question regarding loading an MDX query into Qlik sense

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

0 Replies