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
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rajeshlingutla1
Creator
Creator

How can put upper and lower arrow indicators in qlik sense?

Hi ,

I have to add expression as value in pivot table.

expression should be 1 or -1 value(like value=1,-1).I need to show in expression if value is 1 then i need show upper arrow with green colour ,if the value is -1 need to show down arrow with red colour.

please explain me how can put arrows in qlik sense?

Thanks,

Rajesh

9 Replies
robert_mika
Master III
Master III

Try this custom format

Try this as custom format

▲ #,##0;▼ #,##0

Then add in Text Color Expression:

if(Value=1,Green(),Red())

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Not applicable

Rajesh,

U can use chr(9650) for upper arrow and chr(9660) for down arrow based on your conditions.

Ex - if(value=1,chr(9650)

if(value=(-1), chr(9660)))

For color again you can create an expression as Robert has indicated.

Alternately u can follow robert's method.

mrutyunjaya
Contributor III
Contributor III

Hi Robert,

I feel it's a good solution.

Can you please let me know how to add colors(Red / Green) to only ▲ & ▼, excluding Numbers.

I can sense two options;

- Write expressions in Text box (?)

- Add Colored Unicode (if any)

111.png

I am trying to avoid coloring numbers here.

Reg

Mrutyunjaya

qlikviewforum
Creator II
Creator II

Hi Robert,

Please help me out for the below where i use Valuelist. It is very urgent...

https://community.qlik.com/t5/New-to-QlikView/Up-Down-arrow-based-on-pivot-table-which-is-using-Valu...

qlikviewforum
Creator II
Creator II

Hi Robert,

Any update on the above please?

qlikviewforum
Creator II
Creator II

???

qlikviewforum
Creator II
Creator II

I want to change color of up/down arrow only not the numbers. How can I do that?

 

qlikviewforum
Creator II
Creator II

Did you find anything? I am also looking for the same...

carlcimino
Creator II
Creator II

I accomplished the coloring like so...

1) Create a master item with the measure and add segment coloring for <>0 red/green.

Master Item Segment ColoringMaster Item Segment Coloring

 

 

 

 

 

2) Add that Master Item Measure to a KPI Object and turn off the Use Master Measure Formatting

KPI SettingsKPI Settings

 

 

 

 

 

 

3) Click finish and your object should have the conditional up down arrow with the coloring.
Green ArrowGreen Arrow

Red ArrowRed Arrow