# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean: Not applicable

## Sum Budget of next months of this Year!!

Hi every one ;

I create a function that calculate the Sum of Budget for the currently month :

=SUM({<[MoisBudget_Date] = {'<=\$(=Today())'}, MONTHNAME_Budget = {'\$(=Month(Today()))'}>}Données)

I want to create anothet indicator that calculate the sum of budget for next months of this year .

We are in March 2014, I want the sum of budget for APr, Mai., Jun , ....

What fonction shoud I create??

Thks

1 Solution

Accepted Solutions Not applicable
Author

It works . Thank you for your help:

sum({\$ <MONTHNAME={">=\$(=(num(month(today()))))"}>}Données) // Next months

-SUM({<[Mois_Date] = {'<=\$(=Today())'}, MONTHNAME = {'\$(=Month(Today()))'}>}Données) // ( This Month )

7 Replies  MVP

For Apr: =SUM({< MONTHNAME_Budget = {'Apr'}>}Données)

talk is cheap, supply exceeds demand  MVP  MVP

I think

=sum({\$ <MONTHNAME_Budget={">=\$(=(num(month(today()))))"}>} Données)

If you have a calendar loaded every day and linked to your budget table, use a column flag to identify next months of this year (FlagNextMonthsThisYear) in the calendar, your expression will be much easier

=sum({\$ <FlagNextMonthsThisYear={1}>} Données) Not applicable
Author

Hi Manish;

I trying your function and it's helpful for the next Month , But I want to calculate quatity of  All Next MONTHS of the year .

Exmp:

From Apr. to December of this year .

Thnks  MVP

Can you provide sample data files along with your requirements?  MVP

Hi,

try this

Regards,

Great dreamer's dreams never fulfilled, they are always transcended. Not applicable
Author

It works . Thank you for your help:

sum({\$ <MONTHNAME={">=\$(=(num(month(today()))))"}>}Données) // Next months

-SUM({<[Mois_Date] = {'<=\$(=Today())'}, MONTHNAME = {'\$(=Month(Today()))'}>}Données) // ( This Month ) Community Browser