1 Reply Latest reply: Jan 12, 2016 5:47 AM by PAVAN CH RSS

    Aggregated numbers to detail rows (Master Detailed report)

    PAVAN CH

      Hi All,

       

      I am quite new to QlikView. Trying below Master detail scenario to achieve but unformatley couldn't able to success. Your inputs are vary valuable.

       

      Table:

       

      Maturity DateDeal Count
      01-JAN-20152
      02-JAN-20153
      03-JAN-20154

      The above one I have achieved by set analysis. Both the master and detail records are from one table.

      When I click on number 2 it should show details as below, in the same way when I Click on 3 below table should show detail 3 deals.

      Deal NumberDealerMaturity Date
      100Robin01-JAN-2015
      200Charles02-JAN-2015

       

      Please help me with some tips to achieve above.

       

      Thanks in Advance

       

      Pavan