Help with Set analysis for P&L Statement

[arockiyaselvana]

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.

[arockiyaselvana · Accepted solution]

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.