Skip to main content

New to Qlik Sense

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

Announcements
New navigation header in progress. Thank you for your patience: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
torraroger
Contributor III
Contributor III

Trend Indicators - up or down arrows

Hi all, 

I have a table with users activity data as following: 

Date (D-M-YY)UserResourceElapsed Time

1-1-19

User 1

Resource 11
1-2-19user 2Resource 12
1-1-19User 3Resource 22
1-2-19User 4Resource 21

 

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)

ResourceJanuary (Average Elapsed T)February (Average Elapsed T)Trend arrow 
Resource 112UP RED ARROW
Resource 221DOWN 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

Labels (5)
4 Replies
JordyWegman
Partner - Master
Partner - Master

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

Work smarter, not harder
torraroger
Contributor III
Contributor III
Author

Don't know how to scalate it

JordyWegman
Partner - Master
Partner - Master

What do you mean with 'scalate'?

Jordy

Climber

Work smarter, not harder
torraroger
Contributor III
Contributor III
Author

How apply it to my data