topic Count in QlikView

Count

Wed, 12 Mar 2014 14:30:20 GMT

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 — Wed, 12 Mar 2014 14:42:30 GMT

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 — Wed, 12 Mar 2014 14:43:36 GMT

Like this?

maxgro — Wed, 12 Mar 2014 14:49:02 GMT

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

....

2) use set analysis

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

.....

or I'm missing something?

Wed, 12 Mar 2014 15:03:05 GMT

Thanks a lot Gysbert. Its working fine now..