3 Replies Latest reply: Apr 11, 2017 6:07 AM by omar bensalem RSS

    Show Result on Parent Row

    Rahul Mahajan

      Hi All,

       

      i am facing the issue as below.

       

      Simple data as:

       

      CoL1CoL2CoL3Result
      Parent1Activity1Parent1
      Child1Activity2Parent1
      Child2Activity3Parent15
      Child3Activity4Parent1
      Child4Activity5Parent1


      here i want to count the number of Activities performed on Parent+Child, and the result will be display on Parent row only. which is not happening above. for above problem i written expression for result as :

      AGGR(Distinct Count([CoL2]),[COL3])

       

      Expected result will be :

       

      CoL1CoL2CoL3Result
      Parent1Activity1Parent15
      Child1Activity2Parent1
      Child2Activity3Parent1
      Child3Activity4Parent1
      Child4Activity5Parent1

       

      Is there a way to display the count for Parent row only not for Child.

      OR is their any other way to get this expect AGGR?

      [NOTE: i am using the Qlik Sense 2.2 edition]


      I hope I made myself clear.


      Thanks,

      Rahul