topic Re: Should I use Count ? in QlikView

Should I use Count ?

Fri, 10 Jan 2014 08:21:19 GMT

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,

Re: Should I use Count ?

Michiel_QV_Fan — Fri, 10 Jan 2014 08:35:57 GMT

That is a possible solution.

Are you searching for the syntax for this?

Re: Should I use Count ?

sujeetsingh — Fri, 10 Jan 2014 08:41:27 GMT

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

Well will you please explain your scenario ?

Re: Should I use Count ?

Fri, 10 Jan 2014 08:57:58 GMT

use may use count and aggregate functions based on your requirement

Re: Should I use Count ?

Fri, 10 Jan 2014 09:02:18 GMT

Hi, Michiel.

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

Thanks,

Re: Should I use Count ?

Fri, 10 Jan 2014 09:02:47 GMT

Any example code would be great.

Thanks,

Re: Should I use Count ?

jagan — Fri, 10 Jan 2014 09:02:55 GMT

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.

Re: Should I use Count ?

Michiel_QV_Fan — Fri, 10 Jan 2014 09:07:15 GMT

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

Re: Should I use Count ?

Fri, 10 Jan 2014 09:10:58 GMT

Thankyou Gentlemen.

You were very prompt and helpful.

Regards,

MW.