Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arockiyaselvana
Contributor

Help with Set analysis for P&L Statement

Hi All,

I trying to create a Profit & Loss Statement in Qlik Sense with the help of below Post.

How IntervalMatch Solved My Profit and Loss Dilemma

But I am unable to get values for the below Table Expression.

If([Exec P&L Level]='s','',Sum({<[Fiscal Year]={$(=Max([Fiscal Year])}>}Amount)).

It returning only Null values. Can you please help me to find out why this is happening in Qlik Sense?

Thanks & Regards,

Arockiya.

1 Solution

Accepted Solutions
arockiyaselvana
Contributor

Re: Help with Set analysis for P&L Statement

Hi All,

I found a mistake in that code.

If([Exec P&L Level]='s','',Sum({<[Fiscal Year]={$(=Max([Fiscal Year]))}>}Amount))


After I corrected it, now its working fine.


Regards,

Arockiya.

1 Reply
arockiyaselvana
Contributor

Re: Help with Set analysis for P&L Statement

Hi All,

I found a mistake in that code.

If([Exec P&L Level]='s','',Sum({<[Fiscal Year]={$(=Max([Fiscal Year]))}>}Amount))


After I corrected it, now its working fine.


Regards,

Arockiya.

Community Browser