Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
francoiscave
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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.

PrashantSangle

Hi,

Yes You can.

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

Like

Expr1 & '    ' &Expr2

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

Ok,

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

First2.jpg

Thanx

Not applicable
Author

no we can not change the color of column line

PrashantSangle

Hi,

Did you try with '&'

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

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.

francoiscave
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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