Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Highlighted
Not applicable

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.

Highlighted

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.
Highlighted
Not applicable

Ok,

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

First2.jpg

Thanx

Highlighted
Not applicable

no we can not change the color of column line

Highlighted

Hi,

Did you try with '&'

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Not applicable

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.

Highlighted
Partner
Partner

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

Highlighted
Not applicable

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