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.