topic Re: Urgent - creating simple bar chart in QlikView

Urgent - creating simple bar chart

sayadutt — Wed, 29 Jul 2015 08:40:41 GMT

Hi All,

I am new to Qlikview.

I am trying to create a very simple bar chart.

I am loading below data from an excel.

Name Skills Location

A 1 xx

B 2 yy

C 1 yy

Now my bar chart should show like below:

Can you please help me how to do this. I have successfully loaded the data from excel into qlikview.

Thanks

Re: Urgent - creating simple bar chart

sushil353 — Wed, 29 Jul 2015 08:45:38 GMT

Hi,

You need to use two dimension, first is skill and then Name

Write your expression and use style as stacked.

Re: Urgent - creating simple bar chart

qlikmsg4u — Wed, 29 Jul 2015 08:47:42 GMT

Create Bar chart

1.Use Dimensions Skill and Name

2.Create Expression Count(Location)

3.Bar Chart Style : Orientation Landscape and Subtype : Stacked

Re: Urgent - creating simple bar chart

Wed, 29 Jul 2015 08:51:46 GMT

Hey Sayantan Dutta

I hope this solves your problem.

Here you can use Skills in the dimension and do 'count(Location)' in the expression of a bar chart.@Sayantan Dutta

PFA the example qvw as well.

Thanks

Ganesh

Re: Urgent - creating simple bar chart

Anonymous — Wed, 29 Jul 2015 08:52:20 GMT

Hi,

try with this.

Regards.

Re: Urgent - creating simple bar chart

antoniotiman — Wed, 29 Jul 2015 08:52:51 GMT

Maybe like this

Re: Urgent - creating simple bar chart

awhitfield — Wed, 29 Jul 2015 08:57:46 GMT

Hi Sayantan,

Simple example attached

HTH - Andy

Re: Urgent - creating simple bar chart

Anonymous — Wed, 29 Jul 2015 09:06:07 GMT

Sorry, this.

Best regards.

Re: Urgent - creating simple bar chart

veidlburkhard — Wed, 29 Jul 2015 09:41:31 GMT

Hi, Sayantan,

see the below picture:

This is done with a stacked bar chart in QlikView.

In the dimension tab enter Skills and then Location as dimensions.

In the expression tab enter one expression: Count(Skills). Please mark the check box 'Values on Data Points' and enter

your expressen label. I used 'Skills in Location'.

In the style tab mark the horizontal bars and mark 'Stacked'.

In the presentation tab mark the check box 'Plot Values Inside Segments' and uncheck the 'Show Legend' check box.

Add a text in chart named 'Location'- you certainly have to arrange this text with ctrl+shift in the chart to get it aligned with the dimension label 'Skill', later.

At last go to the axis tab and mark the 'Hide Axis' check box.

That's all.

Happy qliking

Burkhard