Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count

             IDTEST DATE
113/01/2013
214/01/2013
315/01/2013
416/01/2013
517/01/2013
618/01/2013
719/01/2013
820/01/2013
921/01/2013
1022/01/2013
1123/01/2013
113/01/2014
315/01/2014
416/01/2014
517/01/2014
719/01/2014
921/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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
MK_QSL
MVP
MVP

Like this?

maxgro
MVP
MVP

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?

Not applicable
Author

Thanks a lot Gysbert. Its working fine now..