Trend Indicators - up or down arrows

[torraroger]

Hi all, 

I have a table with users activity data as following: 

Date (D-M-YY)	User	Resource	Elapsed Time
1-1-19	User 1	Resource 1	1
1-2-19	user 2	Resource 1	2
1-1-19	User 3	Resource 2	2
1-2-19	User 4	Resource 2	1

I want to build a pivot table as the following and ADD A TREND INDICATOR ARROW (If trend is up=red up arrow / If trend is down=green down arrow)

Resource	January (Average Elapsed T)	February (Average Elapsed T)	Trend arrow
Resource 1	1	2	UP RED ARROW
Resource 2	2	1	DOWN GREEN ARROW

How can I build this???  I NEED A FORMULA OR SOMETHING THAT ANALYSE THE TREND (I will have many resources and I want to have the monthly average elapsed time and the arrow should take into account the months showed in the table and indicate the trend)

Thank you all

[JordyWegman]

Hi,

Check this post from today: https://community.qlik.com/t5/New-to-Qlik-Sense/Arrows-in-Straight-table-with-Values-Qlik-sense/m-p/...

Here I give the solution for your question.

Jordy

Climber

[torraroger]

Don't know how to scalate it

[JordyWegman]

What do you mean with 'scalate'?

Jordy

Climber

[torraroger]

How apply it to my data