Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

6 Replies
kuba_michalik
Partner - Specialist
Partner - Specialist

Could you perhaps post an example qvw?

Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

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

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

Not applicable
Author

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

Not applicable
Author

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