topic Re: Display two dimensions on one axis in QlikView

Display two dimensions on one axis

Tue, 14 Jan 2014 02:29:12 GMT

Hi, I am a very new QlikView user, I want a sheet object to apply the same expression to two dimensions (not any combination of such, just putting all items from two separate dimensions on the same axis).

I have struggled with logical operators and all kinds of suggestions found in searches and come up with nothing. Any help would be greatly appreciated.

Re: Display two dimensions on one axis

Anonymous — Tue, 14 Jan 2014 03:43:42 GMT

You can use Calculated dimension as

Dimension1 & Dimension2,

In this way, your two dimension will be on same axis and Expression will be calculated accordingly.

Regards

Nitin

Re: Display two dimensions on one axis

VishalWaghole — Tue, 14 Jan 2014 04:06:55 GMT

Hi Andrew,

You can add that two Dimensions in One Cyclic group.

- Regards,

Vishal Waghole

Re: Display two dimensions on one axis

VishalWaghole — Tue, 14 Jan 2014 04:14:14 GMT

Hi Andrew,

Please Find attached image, hope it will help you.

Go to charts properties, In Dimension tab

and click on Edit group button

then click on New Group, and add whatever Dimension you want and select Group as Cyclic.

Then add such group as your Dimension, Hope it will work for you.

- Regards,

Vishal Waghole

Re: Display two dimensions on one axis

Tue, 14 Jan 2014 04:52:41 GMT

Hi Andrew,

Choose the chart (Ex.Bar Chart) and Add two fields in Dimensions Tab and give the Expression in Expression tab and apply automatically it will aggregate the data according to those two dimensions. One dimension will be shown as horizontal X-Axis another it comes on right hand side as a legend.

Regards,

Santhosh G

Re: Display two dimensions on one axis

Tue, 14 Jan 2014 14:27:27 GMT

Vishal,

"Edit Groups" is grayed out on my screen.

Re: Display two dimensions on one axis

Tue, 14 Jan 2014 14:32:22 GMT

Santhosh, I don't want to aggregate the dimensions. I just want them to appear side-by-side on a chart, e.g., if one is months, and the other is year, like this:

January

February

March

...

December

2013

Re: Display two dimensions on one axis

Tue, 14 Jan 2014 14:43:28 GMT

This helps, but:

It breaks my expression - I am doing Count (one thing) / Count (another thing) and the higher level dimension (this is a hierarchy where one lower dimension is contained within the higher one that I am trying to add side-by-side) says > 100% which I know is wrong.
The labels now appear as "Dim1NameDim2Name" when I need them to still just be "Dim1Name" (or "Dim2Name" for the ones in the second dimension).

Re: Display two dimensions on one axis

Anonymous — Wed, 15 Jan 2014 03:37:38 GMT

Then why not you use drill down expression........

If it not full fills your req, please post a sample qvw , with output required.

May be then I can help you in better way....

Regards

Nitin