Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with counting instances

I probably wont explain this well but here goes....

I have a file that has a list of dates, locations and technicians. What I would like to do is show how many technicians were at a location on a certain date.

But what I would also really like to do is create a list displaying 5, 4, 3, 2, or 1 technicians on site, so that when the user clicks on a number it will display all data for a location, for example clicking on 5 then all data that had 5 technicians there, or 4 technicians and so forth on a certain date will be shown.

Thanks,

Adam

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Would something like this in the load script help ?

load

     Date ,

     Location ,

     count(Technician)     as TechnicianCount

from ..............

group by Date , Location

sorted by Date , Location

;

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Would something like this in the load script help ?

load

     Date ,

     Location ,

     count(Technician)     as TechnicianCount

from ..............

group by Date , Location

sorted by Date , Location

;

Anonymous
Not applicable
Author

You can create a Count(technicians) field in you script and group by Location and Date.

Or


Not sure if this would work but create an expression list box.   AGGR(Count(technician),date,location)

avinashelite

Hi Adam,

In the list box of date add a expression like count(technician) it will display like below:

Date

21-jul-14 4

12-jul-14 5

20-jul-14 3

Not applicable
Author

Thanks to everyone on this, was staring at me all along but this has worked fantastically. Its unfortunate I can only mark one post as the correct answer as all seem to work.

Thanks and all the best!
Adam