topic Re: How can put upper and lower arrow indicators in qlik sense? in Visualization and Usability

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

Anonymous — Tue, 06 Oct 2015 19:34:28 GMT

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

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

robert_mika — Tue, 06 Oct 2015 22:48:07 GMT

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)

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

Wed, 07 Oct 2015 05:51:18 GMT

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.

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

Anonymous — Fri, 18 Aug 2017 12:34:01 GMT

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

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

qlikviewforum — Sat, 13 Jul 2019 08:52:40 GMT

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-Valuelist/m-p/1601915/highlight/false#M377890

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

qlikviewforum — Sun, 14 Jul 2019 14:24:55 GMT

Hi Robert,

Any update on the above please?

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

qlikviewforum — Mon, 15 Jul 2019 06:51:57 GMT

???

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

qlikviewforum — Wed, 17 Jul 2019 05:42:07 GMT

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

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

qlikviewforum — Wed, 17 Jul 2019 05:43:50 GMT

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

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

carlcimino — Mon, 31 Jan 2022 18:03:17 GMT

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

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

RicKozar — Tue, 23 May 2023 09:03:38 GMT

This does not work anymore