topic Re: Pivot table merge expression column ? in QlikView

Pivot table merge expression column ?

Tue, 30 Dec 2014 08:58:07 GMT

Hi,

Is it possible to merge two columns expressions?

For example, I have this tab :

I would like this result :

I tried to concat image with value in a same expression but it's doesn't work.

Do you have an idea to do this?

Thanx

Re: Pivot table merge expression column ?

francoiscave — Tue, 30 Dec 2014 09:07:43 GMT

Hi Mathieu,

You can't merge properly image and expression result.

You can trick with a image column (.png and color background) and tour expression column to "mislead"...

François

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 09:14:07 GMT

Hi Beaulieu,

We can not merge two columns because for image we choose Image representation there we can not display text and chart both.but

you can do one thing decrease the cell width and change the data orientation from right to left,then it will look aside to each other.

Re: Pivot table merge expression column ?

PrashantSangle — Tue, 30 Dec 2014 09:28:28 GMT

Hi,

Yes You can.

Write both expression in one columne use '&' to concat result of two expression.

Expr1 & ' ' &Expr2

Regards

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 09:34:32 GMT

Ok,

Is it possible to change the color of this column line ? (red box below) :

Thanx

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 09:36:57 GMT

no we can not change the color of column line

Re: Pivot table merge expression column ?

PrashantSangle — Tue, 30 Dec 2014 09:37:10 GMT

Hi,

Did you try with '&'

Regards

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 09:37:11 GMT

Ok, but i haven't two real expressions. I have 1 picture and 1 expression.

I had already tried with " & " and it doesn't work.

Re: Pivot table merge expression column ?

francoiscave — Tue, 30 Dec 2014 09:43:24 GMT

Hi Mathieu,

Have you try to get Wingdings as Font to have the tumb icon... This the link below:

Use of Icons in Design

That's not possible unfortunately for just one expression. You get to choose only one font for the entire straight table. But it could be useful...

François

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 09:44:23 GMT

Do you think i could draw a picture mask with Gimp and add this to background ?

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 09:53:23 GMT

see I arranged the orientation of the Value field and change the cell background color,and cell border,

only this can be achieved

Re: Pivot table merge expression column ?

aveeeeeee7en — Tue, 30 Dec 2014 10:51:52 GMT

Instead of Thumbs Up & Down, I've used Up and Down Pointing Triangles.

See the Snapshot:

Will that Solution work for you.

Regards

Av7eN

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 11:32:37 GMT

Hi,

Try to do increase or discrease the backgroung contrest in properties

Re: Pivot table merge expression column ?

PrashantSangle — Tue, 30 Dec 2014 11:38:36 GMT

Hi,

Can you post your expression and how do you adding that picture?

It is based on expression ??

'&' should work.

Regards

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 11:42:19 GMT

How can i do that?

I've tried Chr(129) but it doesn't work...

Re: Pivot table merge expression column ?

Tue, 30 Dec 2014 11:55:21 GMT

find sample solution in attached application

Re: Pivot table merge expression column ?

aveeeeeee7en — Wed, 31 Dec 2014 04:40:29 GMT

Use chr(9660). Like this:

if(Annee='2014' AND Sum(Livraisons)>=10,Chr(9650),chr(9660))&' '&Sum(Livraisons)

Change the expression according to your requirement and after writing the expression change the Background color like this:

if(Annee='2014' AND Sum(Livraisons)>=10,RGB(255,0,0),RGB(0,255,0))

Hope that helps you.

Regards

Av7eN