# 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

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?

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