Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.