topic Re: Column() in a text object in QlikView

Column() in a text object

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

Hi all,

I'm using a text object to show the Actual for the month selected. I'm including arrow icons to show if they are negative of positive. Now i need to color it red or green accordingly.

I could do this in a chart table using column() function in background property of the expression. Could you please help me in doing the same in a text box as well.

I understand that the formula could be repeated, however i'm concerned about the maintenance issue it might pose in the future.

Regards,

Anagha

Re: Column() in a text object

prasadcm — Fri, 10 Jun 2016 06:43:45 GMT

Hi,

Have a look at this links,it will help.

Replacing images with Geometric Shapes as visual cues

Geometric shapes.qvw

Geometric Shapes - Wikipedia, the free encyclopedia

Regards,

Prasad

Re: Column() in a text object

arasantorule — Fri, 10 Jun 2016 06:48:55 GMT

Hi,

The option is shown below. Thanks

Re: Column() in a text object

prasadcm — Fri, 10 Jun 2016 07:07:20 GMT

Hi,

Check if it is right.

Regards,

Prasad

Re: Column() in a text object

pho3nix90 — Fri, 10 Jun 2016 07:30:29 GMT

In a text object you will have to repeat the expression, however that being said rather put the expression in a variable and then use it in the text object. This way will make maintenance the same as using Column() in a chart.

Remember when using variables, never include the equal '=' in the variable expression, otherwise it will be calculated without dimensions, when leaving the equal out it will calculate on the object.

Please see attached.

Re: Column() in a text object

susovan — Fri, 10 Jun 2016 07:44:51 GMT

Hi Anagha'

Try this attachment,

Re: Column() in a text object

anagharao — Fri, 10 Jun 2016 07:53:25 GMT

Thank you!