Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
johnwQlikView App Developmenthicgwassenaarswuehl
swuehlhicjohnwQlikView App Developmentgwassenaar
note:
need scripting preferable
Message was edited by: Silambarasan M
Hi,
May be check the Attachment..
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