topic Re: How to create arrows in QlikView

How to create arrows

Tue, 04 Sep 2012 14:08:42 GMT

Hi All,

How to create arrows like below one.. ...

If the value decrease is (-1) colored as red and decreases is Zero or positive number the color will be Green. The direction of the arrow will be downward if the value is negative- will be a block if the value is zero and it will be upward if the value is positive.

I dnot want display these arrows in staright table or any other table as a column, i want to display these arrows as separate chart like below one.

Is this req possible in qlikview?... I was searching some earlier posts for this but didn't find reliable one. so please help me how can we do this.

Regards,

Anil

Re: How to create arrows

Tue, 04 Sep 2012 14:12:10 GMT

Right click on your sheet and create a new sheet object and select Line Arrow object. Then you can set an action within this object.

Sean

Re: How to create arrows

Tue, 04 Sep 2012 14:18:55 GMT

Thanx for your quick replay sean i have tried the arrow object but how can we display the values on middile of the arrow and how can we make to dynamic for -ve and +ve values...

Re: How to create arrows

Tue, 04 Sep 2012 14:29:21 GMT

I want change the below bar chart to arrows like above one.

Re: How to create arrows

Tue, 04 Sep 2012 14:34:19 GMT

Now that I have tested it a bit further I am not seeing where text can be added to the arrow. However, what I have done in the past is set a text object over the arrow and then make the text object transparent (no background), so the arrow will change color based on your script and then the text box will change values based on your script or the field that it displays. So it will appear that the value in the arrow is part of the arrow but it is 2 seperate objects, one overlaying the other.

Hope this helps,

Sean

Re: How to create arrows

Tue, 04 Sep 2012 15:04:29 GMT

Sean i was trying to use the set variable option from Actions to display the value in text object but i dnt have luck so can you please provide any example....

Anil

Re: How to create arrows

Tue, 04 Sep 2012 15:22:07 GMT

See the attached. I have each object created seperatly and then overlaid them at the end. I did not use a varaible, I just set them based on the field value.

Sean

Re: How to create arrows

Tue, 04 Sep 2012 15:37:24 GMT

Another way is to use a text object, set the background as an arrow image, and add the text as usual. Then you can set the conditional layout to show the Green arrow when your value is >=0 and the Red when <0. Here is an example.

Re: How to create arrows

Tue, 04 Sep 2012 15:41:32 GMT

Yes, that is a bit easier, thanks for suggesting.

Sean

Re: How to create arrows

Tue, 04 Sep 2012 15:56:41 GMT

Its much helpfull thank you so much......

Re: How to create arrows

Wed, 05 Sep 2012 09:53:49 GMT

if the value is zero(0), instead of arrows it should be a block , can we do this..

Re: How to create arrows

kouroshkarimi — Wed, 05 Sep 2012 10:03:22 GMT

Yes you can, you just need a third text (image) object with conditional show where value is zero.

Re: How to create arrows

Wed, 05 Sep 2012 13:03:33 GMT

Example.

Re: How to create arrows

Wed, 05 Sep 2012 14:13:29 GMT

Perfect!!! thnx so much