topic Re: Text and Arrow in One Column for Straight Table in QlikView

Text and Arrow in One Column for Straight Table

Tue, 16 Sep 2014 17:20:08 GMT

Hello,

Is there a way to concatenate text and an arrow in a single column for a straight table?? or do you need to make them as two different columns?

As far as i can tell, the 'Representation' part of the 'Display Options' enables only with or

Thank you for your input.

Re: Text and Arrow in One Column for Straight Table

sundarakumar — Tue, 16 Sep 2014 17:24:14 GMT

I guess u should go for 2 col..

Re: Text and Arrow in One Column for Straight Table

JonnyPoole — Tue, 16 Sep 2014 17:28:02 GMT

if you need 2 expresions with the same formula, consider turning the formula into a variable . That way you can control the formula in one place and not have it duplicated for any future maintenance.

Re: Text and Arrow in One Column for Straight Table

Anonymous — Tue, 16 Sep 2014 17:53:43 GMT

If(([Invoice Amount YTD]-[Invoice Amount Previous YTD])/[Invoice Amount YTD] < 0,

Num(([Invoice Amount YTD]-[Invoice Amount Previous YTD])/[Invoice Amount YTD],'#,##0.00%') & ' ▼',

Num(([Invoice Amount YTD]-[Invoice Amount Previous YTD])/[Invoice Amount YTD],'#,##0.00%'))

and font color for the value:

if(Column("column number in chart") < 0,RGB(255,0,0)) // will be in red

Re: Text and Arrow in One Column for Straight Table

sundarakumar — Tue, 16 Sep 2014 18:23:26 GMT

u could use CHR(9650) for up arrow and CHR(9660) for down arrow. but i would recommend 2 different columns. since that will perform better when compared to a complicated if statement.

-Sundar