Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dolly777
Contributor III
Contributor III

Yearly Closure 2016, the figures of 2015 and 2016 are not on the latest Status?

Hi Friends,

Could you please help this Issuse

PY (2015). In the enclosed example for China, you see a difference  (123,445m€ in EIS and 123,130m€ in MMV).

I think the problem is, that the 123,445m€ includes the turnovers from Industrial Business Area. The 123,130m€ in MMV only shown the Country Group China / Business Area M – Marketing / Business Unit AP, which corresponds to the Actual / Budget figures. My opinion is, to show the correct PY figures is, that only Business Area M and Business Unit AP should be included in the figures (see picture below).

Capture.PNG

This PY Expression:

Pick(

  Only({1}OrganisationDetails.flagEmptyRow )+1,

  Sum(

  {<

  VersionKey={'PY'},

  YearMonthWeekKey ={'>$(vYMW_FyPy_Start_Closure)<$(vYMW_FyPy_End_Closure)'},

  Month,

  BaseYearKey={$(=constBaseDate_YearNum-1)}

    >} #Values

  )/vSelect_ScalingFactor,

  ''

)

Capture1.PNG

0 Replies