1 Reply Latest reply: Feb 27, 2015 7:07 AM by Arockiya Selvan A RSS

    Help with Set analysis for P&L Statement

    Arockiya Selvan A

      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,