Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arockiyaselvana
Partner - Creator
Partner - Creator

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
Partner - Creator
Partner - Creator
Author

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.

View solution in original post

1 Reply
arockiyaselvana
Partner - Creator
Partner - Creator
Author

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.