Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text and Arrow in One Column for Straight Table

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.

4 Replies
sundarakumar
Specialist II
Specialist II

I guess u should go for 2 col..

JonnyPoole
Employee
Employee

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.

konstantin
Creator III
Creator III

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

sundarakumar
Specialist II
Specialist II

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