Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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?
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"
Hi Jon,
Thanks for your suggestion but it is not working in Qlik Sense:)
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 ?
>>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.
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
when 0 how to ignore arrows