Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

silambarasan
Contributor

How to display add/remove and count of id?

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

Tags (5)
2 Replies

Re: How to display add/remove and count of id?

Hi,

May be check the Attachment..

silambarasan
Contributor

Re: How to display add/remove and count of id?

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

Community Browser