topic Sum Maximum date in QlikView

Sum Maximum date

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

Dear all.

I am having problems with the following and sincerely I know it is going to be a very simple thing for you but I am not able to solve it.

I have to tables one with Actual Sales with monthly information for several years and i have another table with Budget same format. My applications is showing ok YTD information (currently March) and i can make comparisons between both tables, but the problem is when i try to compare YTD sales vs Full year Budget, meaning, accumulate Sales from Jan 2017 to March 2017 and compared it with the sum of all months of the budget until dec 2017, I am not able to get the later, it always gives me YTD.

Budget date field format is 01/01/2017 (DD/MM/YYYY)

Please help

Thanks

Re: Sum Maximum date

Anil_Babu_Samineni — Fri, 12 May 2017 06:31:00 GMT

Can you share sample application and expected result, May be

Re: Sum Maximum date

tyagishaila — Fri, 12 May 2017 06:58:03 GMT

Share sample application, or at least share what expressions you are using to calculate/compare YTD sales vs Full year Budget.

Re: Sum Maximum date

Anonymous — Fri, 12 May 2017 07:38:51 GMT

Hi Anil, Shaila

the expressions i am using are:

=Sum({<SalesYear=,SalesMonth=>}Budget for budget

and

=sum(AMOUNT) for sales

both are OK for YTD information (as of Mach), but i want budget expression to give the FY2017 sum.

these are the tables i am using.

Thanks again

Budget Table

Sales Table

Country

BudgetDate

Budget

SalesDate

YTD Sales

9.947.851,5

01/01/2017

155.584,8

01/01/2016

3.104.235,0

YTD Budget

311.169,6

01/02/2017

155.584,8

01/02/2016

9.655.618,1

01/03/2017

155.584,8

01/03/2016

6.025.539,6

FY Budget

2.022.602,0

01/04/2017

155.584,8

01/04/2016

4.812.765,2

01/05/2017

155.584,8

01/05/2016

3.623.366,5

01/06/2017

155.584,8

01/06/2016

26.065.827,1

01/07/2017

155.584,8

01/07/2016

6.497.854,9

01/08/2017

155.584,8

01/08/2016

6.196.406,6

01/09/2017

155.584,8

01/09/2016

6.812.497,5

01/10/2017

155.584,8

01/10/2016

4.571.271,9

01/11/2017

155.584,8

01/11/2016

18.364.938,7

01/12/2017

155.584,8

01/12/2016

15.890.171,0

01/12/2017

155.584,8

01/01/2017

3.325.980,0

01/01/2017

6,621,871,5

Re: Sum Maximum date

ahaahaaha — Fri, 12 May 2017 08:01:33 GMT

Hi Victor,

May be just remove the {<SalesYear=,SalesMonth=>} selection exception for the budget field?

Regards,

Andrey