Hi..Can someone help me out with this.... I have got a Table as mentioned below. I want to display the count (number of employees) between age group 20-29,30-39,40-49,50-60 in a bar chart where 20-29,30-39,40-49 should be x axis ?

[baarathi]

EmployeeId	EmployeeName	Age

Thanks in Advance

[el_aprendiz111]

Hi Baarathi

OPTION-1 : =Class(AGE,10)

OPTION-2 :

=if(AGE<20, 'Under 20',
if(AGE>60, 'Over 60',text(20+(Div(AGE-20,10)*10)) & ' - ' &
text(29+(Div(AGE-20,10)*10))))

[MarcoWedel]

maybe helpful:

class ‒ QlikView

regards

Marco

[baarathi · Accepted solution]

Thank You Sir.It was so much helpful

[baarathi]

Thank you, sir

[baarathi]

Can you please explain me about how this section of your statement works?

text(20+(Div(AGE-20,10)*10)) & ' - ' &
text(29+(Div(AGE-20,10)*10))))