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: 
nareshthavidishetty
Creator III
Creator III

EOM report showing wrong at Access point

Hi,

Actually we have deliver  2 kinds of reports one is PDF and another is AccessPoint.

The EOM data in PDF report is showing correct but in Accesspoint it showing wrong data.

EX:

PDF : Electronis sales for 30th April,2016 = 20.6%

Access Point: Electronis sales for 30th April,2016 = 19.5%

Which is not correct and these should match each other.

Logic Used:

If(/*District_RetailScorecard='District' or*/ [Location] = '888',

      (sum({$<Year = {$(vRunYear)},Month = {$(vRunMonth)},[Current Sales Class Nbr] = {001}>} TOTAL ([Invoice Merchandise Amt] +  [Invoice Price Concession Amt]))

      -

      sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},

        [Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"},[Current Sales Class Nbr]  = {001}>} TOTAL ([Invoice Merchandise Amt] + [Invoice Price Concession Amt])))

      /

      (sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},

        [Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"}, [Current Sales Class Nbr] = {001}>} TOTAL ([Invoice Merchandise Amt] + [Invoice Price Concession Amt]))),

        //Default - totals for individual Districts or Stores

          (sum({$<Year = {$(vRunYear)},Month = {$(vRunMonth)},[Current Sales Class Nbr] = {001}>} [Invoice Merchandise Amt] + [Invoice Price Concession Amt])

          -

          sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},

            [Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"},[Current Sales Class Nbr]  = {001}>} [Invoice Merchandise Amt] + [Invoice Price Concession Amt]))

          /

          (sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},

            [Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"}, [Current Sales Class Nbr] = {001}>} [Invoice Merchandise Amt] + [Invoice Price Concession Amt])))

Thanks..

2 Replies
qliksus
Specialist II
Specialist II

Was there any difference in the selection between the Selection made during PDF creation and in the  access point

marcus_sommer

Bothe reports are based on the same datamodel with the same version of data? If yes, then could the reason only a different selection and/or any implemented section access respectively other user-related - on osuser() - conditions.

- Marcus