# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

## Set Expression - Sum of Current Financial Year Sales

Hi,

I am trying to sum the current financial year sales.

I have tried the below expression but I just get - back.

=sum({1<FinancialYear = max(FinancialYear)>}Sales)

If I enter the year 2015 I get the correct results, however I don't want to have to hardcode the current financial year.

=sum({1<FinancialYear = {2015}>}Sales)

Am I on the right track?

Jordan

Tags (4)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor III

## Re: Set Expression - Sum of Current Financial Year Sales

Try this:

=sum({1<FinancialYear ={'\$(=Max(FinancialYear))'}>}Sales)

Regards

Av7eN

4 Replies
Highlighted
Valued Contributor III

## Re: Set Expression - Sum of Current Financial Year Sales

Try this:

=sum({1<FinancialYear ={'\$(=Max(FinancialYear))'}>}Sales)

Regards

Av7eN

Highlighted
Valued Contributor III

## Re: Re: Set Expression - Sum of Current Financial Year Sales

See the Attachment.

Highlighted
Valued Contributor III

## Re: Set Expression - Sum of Current Financial Year Sales

Try this:

sum({1<FinancialYear ={\$(=Max(FinancialYear))}>} Sales)

Highlighted
Not applicable

## Re: Re: Set Expression - Sum of Current Financial Year Sales

Awesome, Thanks Mate