How to create arrows

[#1]

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

[#2]

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

[#3]

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...

[#4]

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

[#5]

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

[#6]

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

[#7]

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

[#8]

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.

[#9]

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

Sean

[#10]

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