Fixed count to use for formulas

Anonymous — Thu, 25 Aug 2011 19:38:20 GMT

I would like to use the count of employee by location as a fixed count.

For example if I use the frequency check box in the location list box I get a number I would like to use.

I want to look at Occupancy by day. But in order to do that I need to have a fixed count of employees by location. So I can use that number to calcualate daily access.

When I make selections the number drops by the day and I cant get the % of daily visits compared to the count of employees for a certain region.

I thought maybe I would need to build a variable. I am sure this a pretty basic question but any help would be greatly appreciated.

Thank you,

Cassadi

Fixed count to use for formulas

swuehl — Thu, 25 Aug 2011 21:53:04 GMT

Hi Cassadi,

not sure if I got your issue correctly, but I think you want to get a count independent from current selections.

You could do this with set analysis (have a look in the help file about set analysis or here: http://iqlik.wordpress.com/2010/09/11/the-magic-of-set-analysis-syntax-and-examples/)

So if you want to count the percentage of employees in your selection compared to the number by location without limitation by selection, I would use a chart (e.g. straight table) with dimension Location and then as expression

= count(Employee) / count({1} Employee)

the {1} will get the count() to disregard your current selections.

If you want to get the share of Employees for a certain location compared to all Locations, you could use

= count(Employee) / count(total Employee)

here, total will disregard the charts dimension (certain location).

Hope this helps,

Stefan

topic Fixed count to use for formulas in QlikView

Fixed count to use for formulas

Fixed count to use for formulas