topic Re: displaying two dimensions in the same level in QlikView

displaying two dimensions in the same level

Wed, 26 Feb 2014 20:31:54 GMT

Hi ,

I am trying to display two dimensions at the same level, is it possible? if so how do I do it appreciate your inputs on this.

Regards,

Anusha

Re: displaying two dimensions in the same level

jerem1234 — Wed, 26 Feb 2014 20:34:13 GMT

Do you mean like concatenating two dimensions? If so try like as a calculated dimension:

FirstName & ' ' & LastName

Hope this helps!

Re: displaying two dimensions in the same level

Clever_Anjos — Wed, 26 Feb 2014 20:34:45 GMT

What kind of object you want to use?

Re: displaying two dimensions in the same level

Wed, 26 Feb 2014 20:41:46 GMT

Jerem,

I tried that but no luck,

What I am trying to do is display two dimension labels at my first level itself, now one dimension label displays at first level and second dimension at the second level, I want both the labels in first level , I am using Bar chart my y axis is sum of budget , my x-axis is reason code level1 and reason code level 2 , and I want both the reasons to be shown at the same level

Please help me on how can I do this

Re: displaying two dimensions in the same level

chiru_thota — Wed, 26 Feb 2014 20:44:42 GMT

Can you upload sample QVW or picture of it ?

Re: displaying two dimensions in the same level

Clever_Anjos — Wed, 26 Feb 2014 20:47:22 GMT

A picture of what you want may help

Re: displaying two dimensions in the same level

Wed, 26 Feb 2014 20:51:01 GMT

This was done in excel I want something like this in Qlikview

Re: displaying two dimensions in the same level

Clever_Anjos — Wed, 26 Feb 2014 20:53:42 GMT

Very hard of achieving this into QlikView, maybe impossible exactly like

Re: displaying two dimensions in the same level

chiru_thota — Wed, 26 Feb 2014 21:04:35 GMT

It is difficult to achieve.you can have them in same line.(see attached)

I don't know how to get them in two lines.

Re: displaying two dimensions in the same level

Clever_Anjos — Wed, 26 Feb 2014 21:07:57 GMT

Using =CountryName&chr(10)&CountryCode as dimension and rotating 45 degress (Axes Tab)

Re: displaying two dimensions in the same level

Wed, 26 Feb 2014 22:04:21 GMT

That worked thank you so much,

but I couldnt find the rotate opotion?

Re: displaying two dimensions in the same level

Wed, 26 Feb 2014 22:07:04 GMT

Could you please also explain why we are using chr(10)?

Re: displaying two dimensions in the same level

chiru_thota — Wed, 26 Feb 2014 22:19:41 GMT

to force the second dimension value to new line

Re: displaying two dimensions in the same level

Wed, 26 Feb 2014 22:26:18 GMT

is there a way to force it to the new line in a such a way it starts at the same point as the first dimension now the second dimension starts at the middle

Re: displaying two dimensions in the same level

Clever_Anjos — Thu, 27 Feb 2014 19:54:56 GMT

Re: displaying two dimensions in the same level

Clever_Anjos — Thu, 27 Feb 2014 19:55:15 GMT

CHR(10) forces a linebreak