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,

      Arockiya.