topic Re: Showing a value and a symbol in the same cell in QlikView

Showing a value and a symbol in the same cell

Wed, 30 Sep 2015 08:51:23 GMT

Hello everyone,
Could you please help me to "show a value and a symbol in the same cell" similiar as below;

Re: Showing a value and a symbol in the same cell

settu_periasamy — Fri, 02 Oct 2015 02:40:42 GMT

Hi,

If you want just a symbol to add with your data, you can try like this..

=if(sum(Data1)>=10,'▲ '&sum(Data1),'▼ '&sum(Data1))

Re: Showing a value and a symbol in the same cell

jonathandienst — Fri, 02 Oct 2015 05:43:11 GMT

A cell can either display a text or an image, not both -- the representation applies to the whole cell. You could modify the table style to exclude the vertical lines between cells (Properties | Style), or you can use graphical characters like the previous post.

Re: Showing a value and a symbol in the same cell

jonathandienst — Fri, 02 Oct 2015 05:44:19 GMT

Re: Showing a value and a symbol in the same cell

Tue, 06 Oct 2015 09:52:05 GMT

Thank you so much for answering, but I can not open the file that you send.
Could you please send me the code, you wrote in the edit scipt?

Re: Showing a value and a symbol in the same cell

settu_periasamy — Tue, 06 Oct 2015 10:15:22 GMT

In Script just Inline Load..

LOAD * INLINE [

Check, Data1, Data2

A, 6, 9

B, 11, 15

C, 10, 15

D, 4, 18

E, 8, 6

];

Straight Table:

Dimension : Check

Expression : =if(sum(Data1)>=10,'▲ '&sum(Data1),'▼ '&sum(Data1))

Text Color : =if(sum(Data1)>=10,Green(),Red())