7/27/2019 QlikView Example

1/4

200910 200909 200908 200907 200906 200905 200904 200903

Family Jan-10 Dec-09 Nov-09 Oct-09 Sep-09 Aug-09 Jul-09 Jun-09

Sawn 100 110 105 110 106 103 102 106

MAT 105 106 105 105 104 103 103 103

Data Tables Sales_Invoice %Analysis

Calendar_Monthly %Analysis

sin_ProductFamily (From Sales_Invoice T

cam_AnalysisPeriod (From Calendar_Mont

cam_MonthName (From Calendar_Mont

=SUM(sin_Sales)

I need this to be the sum of the current month

Unable to us accumulation as suggested by John

MAT (Moving Average Total)

Product Family Field Name

Analysis Period Field Name

Month Name Field Name

Month Name Field Name

7/27/2019 QlikView Example

2/4

200902 200901 200812 200811 200810 200809 200808 200807 200806

May-09 Apr-09 Mar-09 Feb-09 Jan-09 Dec-08 Nov-08 Oct-08 Sep-08

102 104 105 109 108 105 99 95 96

102 103 102 103 102 102 101 100 100

eriodKey, %ProductFamilyKey

eriodKey

able)

ly Table)

ly Table)

+ last 11 months / 12 (please see formula in cells above)

Keys

7/27/2019 QlikView Example

3/4

200805 200804 200803 200802 200801 200712 200711 200710 200709

Aug-08 Jul-08 Jun-08 May-08 Apr-08 Mar-08 Feb-08 Jan-08 Dec-07

100 102 104 103 98 111 106 99 95

100 100 99 99 98 98

7/27/2019 QlikView Example

4/4

200708 200707 200706 200705 200704 200703 200702 200701

Nov-07 Oct-07 Sep-07 Aug-07 Jul-07 Jun-07 May-07 Apr-07

94 88 99 100 95 94 93 100