2 Replies Latest reply: May 27, 2016 2:03 AM by Silambarasan M RSS

    How to display add/remove and count of id?

    Silambarasan M

      Day-1:

       

      ID,Date

      A, 1-jan-2016

      B,1-jan-2016

      C,1-jan-2016

      D,1-jan-2016

       

       

      Day-2

       

      ID,Date

      A, 2-jan-2016

      B,2-jan-2016

      C,2-jan-2016

      E,2-jan-2016

       

      I want three tables

       

      Table one display count of id on daily basis.

       

      Table two display newly added id on daily basis

       

      Table three display removed id.

       

      table-1

      MonthYear12345678910111213141516171819202122232425262728293031
      Jan-20164400000000000000000000000000000
      Feb-20160000000000000000000000000000000
      Mar-20160000000000000000000000000000000
      Apr-20160000000000000000000000000000000
      May-20160000000000000000000000000000000

       

      if i click 2-jan in table-1 ,it will show list of new id added and list of existing id removed in two separate table

       

      Eg:

       

      Day-2

       

      table-2

      IDnewtype
      Enew

       

      table-3

      IDnewtype
      Dremove

       

      johnwQlikView App Developmenthicgwassenaarswuehl

       

      swuehlhicjohnwQlikView App Developmentgwassenaar

       

       

      note:

      need scripting  preferable

       

      Message was edited by: Silambarasan M