Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional Arrows in a table in QlikSense

Hi All,

I have a requirement of a table which will have conditional arrows in each row.

Example:

Let us consider a table with four columns:

Country, Previous Year Sale, Current Year Sale, Profit/Loss

US,10000,20000,XXX

UK,15000,10000,YYY

In place of 'XXX' there should be a green up arrow and in place of 'YYY' there should be a red down arrow.

The shades of the color will differ based on condition - from dark red for down arrow to dark green for up arrow.

I searched many forums but couldn't find any solution .

Any help on this is appreciated.

1 Reply
Ivan_Bozov
Luminary
Luminary

Hi! Use this expression for your Profit/Loss column: If([Current Year Sale]>[Previous Year Sale], '▲', '▼')

Then set color as expression as follows: If([Current Year Sale]>[Previous Year Sale], Green(), Red())


You can adapt the color condition based on your requirements.

vizmind.eu