Arrows Variations

[maycolbrandao]

Good morning people Does anyone know if Qlik Sense makes it possible to create variation indicative arrows like the one shown below in Qlik View?

[mikaelsc]

use a dual() value as a measure (containing your chr() + measure you want in text, and the measure of your chart as numeric value)

then in the number format, select "measure expression"

[maycolbrandao]

mikaelsc‌ thanks!

Can you demonstrate?

I took an example

[mikaelsc]

demonstrate?

this is my expression :

dual(hash128(RoomName) & ' ' & sum([_Op_Counter])  & chr(9660) & ' ' & chr(9650)  & sum([_Session]),Sum([_Op_Counter]))

[mikaelsc]

[mikaelsc · Accepted solution]

dual(

num(Sum({<ANO={"$(=max(ANO))"}>}[MOVIMENTAÇÃO])/1000000,'#.##0M') & ' (' & num(Sum({<ANO={"$(=max(ANO))"}>}[MOVIMENTAÇÃO])/Sum({<ANO={"$(=max(ANO-1))"}>}[MOVIMENTAÇÃO]) -1,'+#.##0,00%;-#.##0,00%') & ' ' &

if(Sum({<ANO={"$(=max(ANO))"}>}[MOVIMENTAÇÃO])/Sum({<ANO={"$(=max(ANO-1))"}>}[MOVIMENTAÇÃO]) -1>0,chr(9660),chr(9650)) & ')',

Sum({<ANO={"$(=max(ANO))"}>}[MOVIMENTAÇÃO]))