Create Dymanic Arrows which show if a balances go up/down for a specific Period

[#1]

Hi all,

I have a Straight Table Chart which displays balances for a specific measure periodically for month end.

What i am trying to do is create an arrow shows if the balances have gone up or down since the previous month. With 'Show conditional'  Line Arrows,  i am cuurently inserting the following;

=if(Measure='Trend' and Period='2012-02-29',1,0)

However this only works if i actually Select 'Trend' and the 'Period'. I basically want the logic to work where it meets those requirements and not to have to select them? I fairly new to this so could be missing something here.

thanks

[kuba_michalik]

Could you perhaps post an example qvw?

[Jason_Michaelides]

A quick community search found:

http://community.qlik.com/message/149552#149552

There will be loads of other solutions for this common task.  Have a look around...

[#4]

thanks for coming back to me. Example is attached below.

What im trying to do is show the red arrow when the Feb bal is greater than Feb actual. And show the green when its less.
So its an target Vs Actual balance scenario.

I was trying to do it by 'hardcoding' feb minus feb actual etc, but i suppose it would be more dynamic if i could get the most recent Actual and use that in the calculation.

howpe this makes sense!
thanks

[Larry_Aaron]

Is this what you are trying to accomplish?

See Expressions > Definition, Display Options > Representation Image, and Image Formatting.  To change the direction of the arrows see Expression Editor > Images > Image Folder > BiltIn

arrow_s_r.png - The s in the filename is for south, the r is for red

[#6]

Thanks for that laaron, I think i can use your way. Initially i was thinking of using the 'Line Arrow' objects separately to display movements up and down, but i can use the arrow images that are prestored.

thanks very much

[#7]

Thanks for that laaron, I think i can use your way. Initially i was thinking of using the 'Line Arrow' objects separately to display movements up and down, but i can use the arrow images that are prestored.

thanks very much