topic Re: Pivot Table with conditional image in QlikView

Pivot Table with conditional image

marco_puccetti — Tue, 21 Apr 2015 10:39:18 GMT

Hello, i need to insert in a pivot table a graphic image that show the trend of two period (if the percentage is >0 upper arrow, if the percentage <0 down arrow).

Can you show me the sintax to use?

Thanks

Marco

Re: Pivot Table with conditional image

sunny_talwar — Tue, 21 Apr 2015 10:44:46 GMT

Have a look at the attached picture

I hope this will help.

Best,

Sunny

Re: Pivot Table with conditional image

sunny_talwar — Tue, 21 Apr 2015 10:46:10 GMT

Make sure you use a expression like

If(Percentage > 0, Image1, Image2)

Best,

Sunny

Re: Pivot Table with conditional image

jonathandienst — Tue, 21 Apr 2015 10:50:42 GMT

1. Use something like this for the expression:

=If(percentage > 0, 'qmem://<bundled>/BuiltIn/arrow_n.png', 'qmem://<bundled>/BuiltIn/arrow_s.png')

(replace the condition with correct expression for your application)

2. Set the Representation for the expression to 'Image' and adjust the Image Formattting options to your taste.

HTH

Jonathan

Re: Pivot Table with conditional image

jonathandienst — Tue, 21 Apr 2015 10:52:03 GMT

You can also select coloured arrows if you like, eg green for up and red for down. The built in images are available in the expression editor and you can paste the image's text from there.