I want a bar chat count between 20-40,40-60,70-80,80-100 separate bars

[#1]

I want a bar chat count between 20-40,40-60,70-80,80-100.

Sample Table.

Name	Dept	Input1	input2	input3	input4	input5
abc1	Level1	20	3	15	12	6
abc2	Level1	3	5	5	10	3
abc3	Level2	10	10	20	5	5

if Selection of Depat in list box.

Bar chat needs to display a value(count(names) between 20-40(first bar),40-60 second bar),70-80,80-100  (count(names) .

I write below  count its giving me a error.

[djallelsadki]

Hello,

Can you upload the QlikView Document ?

Thanks,

D.Sadki

[buzzy996]

try tis way on ur calculated dimension,modify accordinly ur expression.

=If(Round(Interval([LASTCHANGEDTS]-[CREATETS],'d'))<='40','20-40',

If(Round(Interval([LASTCHANGEDTS]-[CREATETS],'d'))>='41'  and If(Round(Interval([LASTCHANGEDTS]-[CREATETS],'d'))>='60' ,'40-60',

some thing above modify..

))

[#4]

looking for like this