topic Re: Bar chart in QlikView

Bar chart

manoranjan_d — Mon, 28 Sep 2015 14:26:17 GMT

Hi,

In my bar chart i have 5 bars which shows with the counts and with different departments such as IT, CSE,EEE, ECE, MECH

all these has to be displayed as single bar with there counts how to do that?

pls help me

Re: Bar chart

MK_QSL — Mon, 28 Sep 2015 14:32:50 GMT

Remove Departments from Dimension Tab

Re: Bar chart

manoranjan_d — Mon, 28 Sep 2015 14:36:17 GMT

@ manish when i remove dept from dimension i getting single bar only but the dept is not segregated in a single bar, its showing over all total count only...

Re: Bar chart

jonathandienst — Mon, 28 Sep 2015 14:38:52 GMT

Your requirement is not very clear. Do you mean a single bar with coloured segments for each department?

Of so, remove the dimension and make one expression for each department:

=Sum({<Department = {'IT'}>} Values)

=Sum({<Department = {'CSE'}>} Values)

...

Re: Bar chart

manoranjan_d — Mon, 28 Sep 2015 14:52:23 GMT

yes with single bar , that has to show the count of eact dept.

department	Count per Department
IT	50
CSE	100
MECH	200
EEE	150
ECE	130

Re: Bar chart

MK_QSL — Mon, 28 Sep 2015 14:55:43 GMT

Create a Bar Chart

Add a Calculated Dimension

Untick Show Legend

Lebel

use

department as 2nd Dimension

Expression

Whatever your expression is

Tick Values on Data Points

Go to Style tab and select Stacked..

Go to Presentation tab and tick

Plot Values inside segments

still show total on top

Go to color tab and tick persistent color

Re: Bar chart

manoranjan_d — Mon, 28 Sep 2015 15:13:25 GMT

how to show these data in percentage

Re: Bar chart

manoranjan_d — Mon, 28 Sep 2015 15:16:37 GMT

@manish how to show these single bar in precentage

Re: Bar chart

MK_QSL — Mon, 28 Sep 2015 15:18:24 GMT

COUNT(Department)/COUNT(Total Department)

Re: Bar chart

manoranjan_d — Mon, 28 Sep 2015 15:23:52 GMT

all things good but when i reviewed ur file u r using same fields of department.

but my data is having like this

department	Count per Department
IT	50
CSE	100
MECH	200
EEE	150
ECE	130

Re: Bar chart

manoranjan_d — Mon, 28 Sep 2015 15:24:40 GMT

i m not getting correct output when i went with ur suggestion

Re: Bar chart

MK_QSL — Mon, 28 Sep 2015 15:25:49 GMT

Change the 2nd field name to whatever you want ! I don't know how you got Count per Department so I simply used Department. You can use whatever you want. Use my answer as an example and change according to your need. Without looking into your actual QVW, how can I give you 100% accurate answer with same field names?

Thanks !