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
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rajeshlingutla1
Creator
Creator

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
robert_mika
Master III
Master III

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)

View solution in original post

6 Replies
robert_mika
Master III
Master III

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)

View solution in original post

jonathandienst
Partner
Partner

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"

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rajeshlingutla1
Creator
Creator
Author

Hi Jon,

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

rajeshlingutla1
Creator
Creator
Author

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 ?

jonathandienst
Partner
Partner

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jithu
Contributor III
Contributor III

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