Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rajeshlingutla1
New Contributor II

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

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

1 Solution

Accepted Solutions

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

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)

5 Replies

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

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)

MVP
MVP

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

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"

rajeshlingutla1
New Contributor II

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

Hi Jon,

Thanks for your suggestion but it is not working in Qlik SenseSmiley Happy

rajeshlingutla1
New Contributor II

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

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 possibilityarrow.PNG is there ?

MVP
MVP

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

>>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.

Community Browser