EOM report showing wrong at Access point

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: EOM report showing wrong at Access point

qliksus — Thu, 05 May 2016 09:33:08 GMT

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

Re: EOM report showing wrong at Access point

marcus_sommer — Thu, 05 May 2016 10:52:28 GMT

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

topic Re: EOM report showing wrong at Access point in QlikView

EOM report showing wrong at Access point

Re: EOM report showing wrong at Access point

Re: EOM report showing wrong at Access point