Should I use Count ?

[#1]

Hi,

I have a database of staff holidays.

How do you calculate the number of staff who have exceeded 30 days holiday in a particular location? Do I need to use set analysis within a Count to define the location ?

Any help would be useful

Thanks,

MW

[Michiel_QV_Fan]

That is a possible solution.

Are you searching for the syntax for this?

[sujeetsingh]

One thing if it is that you want to count  it then use count.

Well will you please explain your scenario ?

[#4]

use may use count and aggregate functions based on your requirement

[#5]

Hi, Michiel.

Yes, please. I am not familiar with coding in QlikView so I am finding it a little hard to learn.

Thanks,

MW

[#6]

Any example code would be great.

Thanks,

MW

[jagan]

Hi,

Use StaffID or Name, Location as dimensions and use the following expression in straight or pivot table

=If(Count(HolidayFieldName) > 30, Count(HolidayFieldName))

Hope this is what you are expecting.

Regards,

Jagan.

[Michiel_QV_Fan · Accepted solution]

Something like this:

To select the location:

count({<Location = {'The value from your location dimension'}>}Staff)

And with days more than 30

count({<Location = {'The value from your location dimension'}, Holiday_days  ={">=31"}>}Staff)

change the fields according to your field names

[#9]

Thankyou Gentlemen.

You were very prompt and helpful.

Regards,

MW.