How to execute two dimension in a single expression

[#1]

Hai,

Any one pls help me with this fix..?

I have an example here ..pfa

In that I am taking top 10 customers based on order sale amount

I have taken customers as dimension and sum(ordersaleamount) as my dimension.

but I want customers respective country also in a same bar chart near to a customer or near to a value in bracket().

Thanks in advance..

[#2]

Create chart like below.

Calculated Dimension = Customer&'('&Country&')'&

Expression = Sum(ordersalesamount)

Regards,

Kabilan K.

[#3]

Thanks for your reply ..

I have an another doubt If I want country in a new line means ..what calculated dimensions I want to wrote..?

thanks in Advance

[Sokkorn]

Hi,

Try this

=Customer &

'(' & Country & ')'

or

=Customer & Chr(13) & '(' & Country & ')'

Regards,

Sokkorn

[#5]

Thanks..

But its not coming in a new line instead of its coming in the sameline

[Sokkorn]

Hi,

What new line you refer to? Is it enter line? Can you give a sample result that you looking for?

Regards,

Sokkorn

[#7]

IF you are using V11 and the Ajax client then for whatever reason, best known to QlikTech, I have found that chr(13) no longer works, I've had to change every one of my expressions that use this.

Sokkorn's solution is correct up to V10 and on the IE Plugin and/or desktop client, for V11 on Ajax you should use.

=Customer & Chr(10) & '(' & Country & ')'

But also, if you have a dimension that runs over two lines you need to ensure that your table is setup to allow cells to be over two lines (on thepresentation tab).

[#8]

Hai I want customers country name just below.

for eg : I want Ireland below Robert Bolero..what settings I want to change in presentation tab..Please give clear explanation..

[#9]

I cannot see your image I'm afraid, so I don't know what chart type you are using.

This works on a straight table and pivot table.

I thought my explanation was pretty clear, but here goes again.

Go to the presentation tab

Find the box next to Wrap cell text

check the box

click ok

[Sokkorn]

Hi Nigel,

FYI, I'm using v11 SR2 and Chr(13) is working find for me.

Regards,

Sokkorn