topic Re: Conditionnal Formatting in QlikView

Conditionnal Formatting

Fanch — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Conditionnal Formatting

mato32188 — Wed, 18 Sep 2019 10:18:12 GMT

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

Re: Conditionnal Formatting

atoz1158 — Wed, 18 Sep 2019 10:24:48 GMT

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

Re: Conditionnal Formatting

Fanch — Wed, 18 Sep 2019 11:15:23 GMT

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

Re: Conditionnal Formatting

atoz1158 — Wed, 18 Sep 2019 11:35:47 GMT

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

Hope this helps

Cheers

Adrian

Re: Conditionnal Formatting

Fanch — Wed, 18 Sep 2019 11:41:10 GMT

Yeaaah !!!

Greats,

Thanks a lot ! 🍺

Re: Conditionnal Formatting

atoz1158 — Wed, 18 Sep 2019 11:53:57 GMT

Glad to be a help.

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

Cheers

Adrian