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

[Anonymous]

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

[robert_mika]

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)

[#3]

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.

[Anonymous]

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)

I am trying to avoid coloring numbers here.

Reg

Mrutyunjaya

[qlikviewforum]

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]

Hi Robert,

Any update on the above please?

[qlikviewforum]

???

[qlikviewforum]

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

[qlikviewforum]

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

[carlcimino]

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 Coloring

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

KPI Settings

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

Red Arrow