topic Re: Two dimensions in Bar Chart in QlikView

Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 06:52:37 GMT

Hi,

I have countries and cites in two fields. and want to have a graph with countries and cities as dimensions and sales as expression.

I want to have a bar chart with both dimensions in X-Axsis. I have created calculated dimension as 1 and then i can do that.

But my x-asis shows all the cities for all counties.

Eg- I have two countries, USA and ENGLAND

and cities as Newyork, Florida, London , Liverpool.

so my x axis show Newyork, Florida, London , Liverpool for both cities.

But i want to have it as Newyork, Florida under USa and London , Liverpool under London

Re: Two dimensions in Bar Chart

Chanty4u — Thu, 12 Nov 2015 06:58:18 GMT

u can use grouping...

Re: Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 07:00:02 GMT

In Script?

Re: Two dimensions in Bar Chart

Anonymous — Thu, 12 Nov 2015 07:01:35 GMT

If you are having relationship b/w Country and City, then you can create a Drill Group of both Dimension.

like Country->City

Is this sufficient?

Re: Two dimensions in Bar Chart

tresB — Thu, 12 Nov 2015 07:03:10 GMT

Create a dummy expression (say, =1) and then make it invisible, you would get your second dimension values grouped on axis.

Re: Two dimensions in Bar Chart

Chanty4u — Thu, 12 Nov 2015 07:04:32 GMT

in bar chart..u hve to create drill down group.. country---> city

by that it will helps you

Thanks

Suresh

Re: Two dimensions in Bar Chart

jagan — Thu, 12 Nov 2015 07:05:40 GMT

HI,

Do you have mapping between Country & City, if not derive a mapping table like belo

LOAD

INLINE [

City, Country

Newyork, USA

Florida, USA

London , London

Liverpool, London];

Now use Country and City dimensions. Hope this helps you

Regards,

Jagan.

Re: Two dimensions in Bar Chart

Anonymous — Thu, 12 Nov 2015 07:06:08 GMT

See the attached Image,

In Dimension Tab of Chart,

Click on Edit Group->New->Select DRill Group from Top Left->Give The Name of Group->Add dimension, in your case , 1st Dim is Country then City->ok

And then add this drill group name as a dimension in your chart..

Re: Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 07:16:48 GMT

I Have done it, but the problem i have is all the 2nd dimenssion values available under both 1st dimenssion

Re: Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 07:23:12 GMT

drill down doesn't show both dimenssion in one time

Re: Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 07:24:10 GMT

drill down doesn't show both dimenssion in one time

Re: Two dimensions in Bar Chart

sasikanth — Thu, 12 Nov 2015 07:24:21 GMT

That Depends on the data relation between these two fields CITY and COUNTRY,

If possible post your qvw or sample data

Re: Two dimensions in Bar Chart

Anonymous — Thu, 12 Nov 2015 07:27:13 GMT

You can use Grid chart for same as it take two dimension

Re: Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 07:59:52 GMT

Please see attached

Re: Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 08:00:46 GMT

see attached

Re: Two dimensions in Bar Chart

Mark_Little — Thu, 12 Nov 2015 08:14:31 GMT

HI,

I am not sure I understand what you are wanting? I have had a look at the data and created the graph and break down with the cities above the countries. Could you please explain what you want differently on the screen capture below.

Mark

Re: Two dimensions in Bar Chart

anuradhaa — Thu, 12 Nov 2015 08:27:17 GMT

No, I want both deminsons in x axsis

Re: Two dimensions in Bar Chart

Anonymous — Thu, 12 Nov 2015 08:35:28 GMT

In Bar chart, Its not possible to plot both the value on same axis at same time.

You can try Block/Mekko chart..

Re: Two dimensions in Bar Chart

Mark_Little — Thu, 12 Nov 2015 08:48:45 GMT

Hi,

There are, You have the country and cities on the x-axis and then sum of sales on the y-axis?

Are you meaning you want to to see separate bars for the sum of sales for the counties on the same graph?

I think like Balraj below says it is not possible.

Mark

Re: Two dimensions in Bar Chart

tresB — Thu, 12 Nov 2015 08:56:13 GMT

May be like in attached sample. A workaround.