topic count in a pie chart in QlikView

count in a pie chart

Thu, 16 Feb 2012 10:52:46 GMT

i have 3 list boxes name,emp id, and gender. i want to show the total no of male emp and female emp in pie chart.

can count be used for it??

if yes waht would be the syntax for it?/

CELAMBARASAN — Thu, 16 Feb 2012 10:54:40 GMT

Hi,

You can use count.

Have Gender as Dimesion.

Count(Distinct [emp id]) as expression

Celambarasan

Thu, 16 Feb 2012 11:00:57 GMT

how do we decide what to choose as a dimension and what to keep in expression?

CELAMBARASAN — Thu, 16 Feb 2012 11:04:06 GMT

Hi,

If we need the results based on some category means then that category will be the dimension.

Celambarasan

jagan — Thu, 16 Feb 2012 11:04:13 GMT

Hi,

The static values Like Department, Year, Month, Country, City like values are used as dimension.

The calculated values are used as expression. For example

=Sum(Sales) - Total Sales

=Count(Employees) - Count of employees

Hope this helps you.

Regards,

Jagan.