How to add upper and lower arrow in Qlik sense pivot table expression?

[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 · Accepted solution]

Not an arrow but try this:

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)

[jonathandienst]

Or use the builtin icons (assuming the expression to test is the first on the expression tab):

     =If(Column(1) = 1, 'qmem://<builtin>/Arrow_N_G.png', 'qmem://<builtin>/Arrow_S_R.png')

And set the Representation (on Properties | Expression) to "Image" and the Image Formatting to "Keep Aspect"

[Anonymous]

Hi Jon,

Thanks for your suggestion but it is not working in Qlik Sense:)

[Anonymous]

Hi Robert ,

Thanks for you to share expression ,it is working but if i need arrows like filled colour,i have attached image what i need to represent.

Could you please check and let me know is there any possibility is there ?

[jonathandienst]

>>Thanks for your suggestion but it is not working in Qlik Sense:

I expect the objects don't exist in Sense. You's better go with Robert's suggestion.

[jithu]

change the text color is working based on the condition ... but always shows one symbol ▲ irrespective of condition ..

how to make it work 

Tried this as custom format

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

Then add in Text Color Expression: this is working 

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

do I have add value as a condition in custom format ,, if so can you let me know the syntax please

[sai_12]

when 0 how to ignore arrows