Count

[#1]

ID	TEST DATE
1	13/01/2013
2	14/01/2013
3	15/01/2013
4	16/01/2013
5	17/01/2013
6	18/01/2013
7	19/01/2013
8	20/01/2013
9	21/01/2013
10	22/01/2013
11	23/01/2013
1	13/01/2014
3	15/01/2014
4	16/01/2014
5	17/01/2014
7	19/01/2014
9	21/01/2014

The above table shows the ID and TestDate.

I want to get the following result in qlikview

1 time - how many test conducted (2,6,8,10,11)-So it should count 6

2 time - how many test conducted (1,3,4,5,7,9)-So it should count 6

3 time - how many test conducted

.....

.....

Kindly help me in scripting and expression part .

Thanks and Regards,

Sivasu

[Gysbert_Wassenaar · Accepted solution]

Create a straight table with a calculated dimension =aggr(count(distinct [TEST DATE]),ID) and an expression count(distinct ID). See attached qvw

[MK_QSL]

Like this?

[maxgro]

1) you can use a listbox with ID and a text box with expression  =count([TEST DATE])

then in listbox select

1 time    2 6 8 10 11

....

or

2) use  set analysis

1 time is       =count({$ <ID={2,6,8,10,11}> } [TEST DATE])

.....

or I'm missing something?

[#5]

Thanks a lot Gysbert. Its working fine now..