topic Re: Help with counting instances in QlikView

Help with counting instances

Mon, 21 Jul 2014 17:13:14 GMT

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

Re: Help with counting instances

Anonymous — Mon, 21 Jul 2014 17:19:40 GMT

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

;

Re: Help with counting instances

Anonymous — Mon, 21 Jul 2014 17:21:15 GMT

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

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

Re: Help with counting instances

avinashelite — Mon, 21 Jul 2014 17:25:02 GMT

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

Re: Help with counting instances

Mon, 21 Jul 2014 18:49:42 GMT

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