How to display add/remove and count of id?

[silambarasan]

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

MonthYear		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
Jan-2016		4	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Feb-2016		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Mar-2016		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Apr-2016		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
May-2016		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

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

ID	newtype
E	new

table-3

ID	newtype
D	remove

johnw‌QlikView App Development‌hic‌gwassenaar‌swuehl‌

swuehl‌hic‌johnw‌QlikView App Development‌gwassenaar‌

note:

need scripting  preferable

Message was edited by: Silambarasan M

[settu_periasamy]

Hi,

May be check the Attachment..

[silambarasan]

1. No sethu.When i click day-2 it shows only newly added id and not show removed id.

2. synthetic key formed

3. please don't do this in inline table