2 Replies Latest reply: Oct 3, 2016 6:39 AM by Neelima Gonugunta RSS

    Creating Summary table in qliksense using Script

    Supriya R

      Hi,

       

      i have a table called BankMetrics where column's are

       

      BankID,BankName,BankBranch,BankSubBranch,BankStartDate,BankEndDate,BankIntialAmount ,BankAccountAmount,  BankSafeAmount

       

       

      My requirement is to create a single summary table in qliksense script, where it contains data column like

       

      1.)sum(BankIntialAmount)  for PreviousMonth for each BankID

      2.)sum(BankIntialAmount)  for CurrentMonth for each BankID

      2.)sum(BankSafeAmount)  for CurrentMonth for each BankID


      Here for PreviousMonth  and CurrentMonth date we can get from BankStartDate and BankEndDate.


      How could i do this? Any idea or Suggestion is most welcomed

      Please help me on this.