Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a straight table with a calculated dimension =aggr(count(distinct [TEST DATE]),ID) and an expression count(distinct ID). See attached qvw
Create a straight table with a calculated dimension =aggr(count(distinct [TEST DATE]),ID) and an expression count(distinct ID). See attached qvw
Like this?
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?
Thanks a lot Gysbert. Its working fine now..