Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Fanch
Partner - Creator
Partner - Creator

Conditionnal Formatting

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 ?

1 Solution

Accepted Solutions
atoz1158
Creator II
Creator II

Hi

You need to set Representation to "Image" and Image Formatting to Fill as below

clipboard_image_0.png

Hope this helps

Cheers

Adrian

View solution in original post

6 Replies
mato32188
Specialist
Specialist

Hi Fanch,

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

 

ECG line chart is the most important visualization in your life.
atoz1158
Creator II
Creator II

Hi

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.

Regards

Adrian

Fanch
Partner - Creator
Partner - Creator
Author

Yes, i've tried this solution. but instead of putting my arrows doing by conditionnal formatting, i have the formula like a string characters 😲

Conditionnal.PNG

 

atoz1158
Creator II
Creator II

Hi

You need to set Representation to "Image" and Image Formatting to Fill as below

clipboard_image_0.png

Hope this helps

Cheers

Adrian

Fanch
Partner - Creator
Partner - Creator
Author

Yeaaah !!!

Greats,

Thanks a lot ! 🍺

atoz1158
Creator II
Creator II

Hi

Glad to be a help.

So that this helps others please mark the solution as correct.

Cheers

Adrian