Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calculating current month sales

Hi,

I have created a variable to calculate the current financial month;

vFINMNT =

=num(month(AddMonths(today(),-3)))

I now need to create an expression that calculates the current months sales without selecting the financial month but having difficulty creating it, can anyone help?

TIA

3 Replies

Re: Calculating current month sales

Do you have a MonthNum field in your application?

Not applicable

Re: Calculating current month sales

Yes I have FINMONTH

Re: Calculating current month sales

May be this

Sum({<FINMONTH = {'$(=vFINMNT)'}>}Sales)

Community Browser