topic Re: Sum Budget of next months of this Year!! in QlikView

Sum Budget of next months of this Year!!

Wed, 19 Mar 2014 15:54:12 GMT

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

Re: Sum Budget of next months of this Year!!

Gysbert_Wassenaar — Wed, 19 Mar 2014 16:00:22 GMT

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

Re: Sum Budget of next months of this Year!!

MK_QSL — Wed, 19 Mar 2014 16:04:11 GMT

MONTHNAME_Budget = {'$(=Month(AddMonths(Today(),1)))'}

Re: Sum Budget of next months of this Year!!

maxgro — Wed, 19 Mar 2014 20:04:38 GMT

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)

Re: Sum Budget of next months of this Year!!

Fri, 21 Mar 2014 09:08:03 GMT

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

Re: Sum Budget of next months of this Year!!

MK_QSL — Fri, 21 Mar 2014 09:15:52 GMT

Can you provide sample data files along with your requirements?

Re: Sum Budget of next months of this Year!!

PrashantSangle — Fri, 21 Mar 2014 09:27:45 GMT

Hi,

try this

SUM({<[MoisBudget_Date] = {'<=YearEnd(Today())>=$(=Date(AddMonths(Today(),12)))'}>}Données)

Regards,

Re: Sum Budget of next months of this Year!!

Fri, 21 Mar 2014 15:48:13 GMT

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 )