Qlik Community

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?

Thanks in advance for your help.

Jordan

1 Solution

Accepted Solutions
Highlighted
aveeeeeee7en
Valued Contributor III

Re: Set Expression - Sum of Current Financial Year Sales

Try this:

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

Regards

Av7eN

View solution in original post

4 Replies
Highlighted
aveeeeeee7en
Valued Contributor III

Re: Set Expression - Sum of Current Financial Year Sales

Try this:

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

Regards

Av7eN

View solution in original post

Highlighted
aveeeeeee7en
Valued Contributor III

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

See the Attachment.

Highlighted
senpradip007
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