Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table merge expression column ?

Hi,

Is it possible to merge two columns expressions?

For example, I have this tab :

First.jpg

I would like this result :

Result.jpg

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

16 Replies
Not applicable
Author

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

only this can be achieved

aveeeeeee7en
Specialist III
Specialist III

Hi

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

See the Snapshot:

Community Answer.png

Will that Solution work for you.

Regards

Av7eN

Not applicable
Author

Hi,

Try to do increase or discrease the backgroung contrest in properties

PrashantSangle

Hi,

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

It is based on expression ??

'&' should work.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

How can i do that?

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

Not applicable
Author

find sample solution in attached application

aveeeeeee7en
Specialist III
Specialist III

Hi

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