Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER 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

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

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

Creator III
Creator III

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)

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

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