Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Partner
Partner

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
Highlighted
Contributor II

Re: Conditionnal Formatting

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
Highlighted
Contributor III

Re: Conditionnal Formatting

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

 

Highlighted
Contributor II

Re: Conditionnal Formatting

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

Highlighted
Partner
Partner

Re: Conditionnal Formatting

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

 

Highlighted
Contributor II

Re: Conditionnal Formatting

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

Highlighted
Partner
Partner

Re: Conditionnal Formatting

Yeaaah !!!

Greats,

Thanks a lot ! 🍺

Highlighted
Contributor II

Re: Conditionnal Formatting

Hi

Glad to be a help.

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

Cheers

Adrian