1 Reply Latest reply: Aug 25, 2011 5:53 PM by Stefan Wühl RSS

    Fixed count to use for formulas

    Cassadi Myers

      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
          Stefan Wühl

          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