This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi everybody 😎,
I want in a chart to show a conditionnal formatting for some values like this .
If A - B > 0, then show a green arrow
If A = B, then show a gray arrow
If A - B < 0, then show a red arrow
I've seen the image of the arrow and In my chart, i put the formula :
=If(A- B > 0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_e_r.png')
But it doen't work 🙄
Anybody has a idea ?
You need to set Representation to "Image" and Image Formatting to Fill as below
Hope this helps
View solution in original post
have you tried something like
IF(Sum(A-B) > 0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_e_r.png')
Also expression must be represented as "Image".
Pls see image attached
Try the following
=IF(Sum(A-B) > 0,'qmem://<bundled>/BuiltIn/arrow_n_g.png',If(Sum(A-B) = 0,'qmem://<bundled>/BuiltIn/arrow_w.png','qmem://<bundled>/BuiltIn/arrow_e_r.png'))
Also as stated above make sure the expression is set to Image and you may have to change the Image Formatting option to get a decent image.
Yes, i've tried this solution. but instead of putting my arrows doing by conditionnal formatting, i have the formula like a string characters 😲
Thanks a lot ! 🍺
Glad to be a help.
So that this helps others please mark the solution as correct.