topic Re: How to execute two dimension in a single expression in QlikView

How to execute two dimension in a single expression

Thu, 18 Jul 2013 06:39:53 GMT

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..

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 06:53:30 GMT

Create chart like below.

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

Expression = Sum(ordersalesamount)

Regards,

Kabilan K.

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 07:20:41 GMT

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

Re: How to execute two dimension in a single expression

Sokkorn — Thu, 18 Jul 2013 07:25:30 GMT

Hi,

Try this

=Customer &

'(' & Country & ')'

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

Regards,

Sokkorn

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 07:39:45 GMT

Thanks..

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

Re: How to execute two dimension in a single expression

Sokkorn — Thu, 18 Jul 2013 07:43:03 GMT

Hi,

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

Regards,

Sokkorn

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 08:07:53 GMT

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).

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 08:16:45 GMT

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..

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 08:24:59 GMT

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

Re: How to execute two dimension in a single expression

Sokkorn — Thu, 18 Jul 2013 08:29:35 GMT

Hi Nigel,

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

Regards,

Sokkorn

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 08:32:12 GMT

I am asking for an bar chart

Re: How to execute two dimension in a single expression

Thu, 18 Jul 2013 08:51:45 GMT

Sathiyanc

I found a way to do this on a bar chart, using the above suggestions of a calculated dimension with the chr(13) or chr(10 added in the middle, you must then also change the direction of the labels. It doesn't work on a bar chart when the labels are horizontal, but if you change the axis labels to diagonal or vertical then it will work, see below image.

You can do this at the bottom of the Axes tab as shown below:

Re: How to execute two dimension in a single expression

nizamsha — Thu, 18 Jul 2013 09:10:03 GMT

=Date( Country,'YYYY') & chr(10) & chr(13)& Customer