bar chart

[Mahamed_Qlik]

HI

I am calculating some count.

example:

Count ( Employee) and I want to create the category based on this expression only
example:

if( count(employee)<=5, 'small',

if( count(employee)>=6 and count(employee)<=10,'medium','big') as EMP_category

now I want show this in bar chart wherein my dimention will be EMP_category and expression will be same as count(employee)

but when I m doing it m getting only one category in bar char even though my count (employee) is more than 10

please suggest

[justISO]

Hi, let me guess, your 'only one category in bar char' is 'big'? Because, I believe, you need to aggregate this count(employee) on something, for example, per department, branch  etc. As I understand you creating this category in data load script, so if you are counting all employees, you are getting only one category.

[vinieme12]

As below 

Calculated dimension 

=Aggr(if(count(Employee)>=10,'big',if(count(Employee)>=6,'medium','small'),SomeDimension)

Measure 

Count(Something)