5 Replies Latest reply: Dec 1, 2017 2:42 AM by jagan mohan rao appala RSS

    Qlik Sense Set Analysis and Expression Help

    Hari Nag

      Hi Qlik Experts,

       

      I have the following requirement.

       

      Amount 1

       

      Sum({<Status={'Active'}>}Finance Amount)

       

      Amount 2

       

      Sum({<Status={'Passive'}>}Finance Amount)


      I want the List of Proects where Amount 1 > Amount 2 and there corresponding Amount 1 where satisfies the condition that is Amount 1> Amount 2.


      When I tried the below expression I am getting the projects where Amount 1 > Amount 2 and Amount 1 = Amount 2


      Sum(Aggr(if(Amount 1> Amount 2, Amount 1), Project Number)).


      Please help me in this regard.


      Thanks

      Hari