displaying two dimensions in the same level

[#1]

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

[jerem1234]

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

FirstName & ' ' & LastName

Hope this helps!

[Clever_Anjos]

What kind of object you want to use?

[#4]

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

[chiru_thota]

Can you upload sample QVW or picture of it ?

[Clever_Anjos]

A picture of what you want may help

[#7]

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

[Clever_Anjos]

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

[chiru_thota]

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.

[Clever_Anjos · Accepted solution]

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