topic Re: Set Expression - Sum of Current Financial Year Sales in QlikView

Set Expression - Sum of Current Financial Year Sales

Tue, 07 Oct 2014 04:04:30 GMT

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

aveeeeeee7en — Tue, 07 Oct 2014 04:07:38 GMT

Try this:

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

Regards

Av7eN

aveeeeeee7en — Tue, 07 Oct 2014 04:11:51 GMT

See the Attachment.

senpradip007 — Tue, 07 Oct 2014 04:12:26 GMT

Try this:

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

Tue, 07 Oct 2014 20:24:28 GMT

Awesome, Thanks Mate