Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

Mini chart arrows in expression columns

Hi Guys

How do i include small arrows that go up and down next to my values in my expressions.

My dimensions are months so i want the arrow to be alongside the text and to show up or down to say if the value has gone better or worse since the following month

Image result for mini chart table arrows

Similar to %variance

1 Solution

Accepted Solutions
Anil_Babu_Samineni

We have inbuilt images for Qlik. Just maximize the expression and bottom side we have bucket called Images. There You have to select as needed. It works like charm if you use below

if( ([Acutal]- ) <100,'qmem://<bundled>/BuiltIn/arrow_s_r.png'),

     If( ([Acutal]- ) >1,'qmem://<bundled>/BuiltIn/arrow_n_g.png'))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

7 Replies
Anil_Babu_Samineni

We have options these all in single object. Check attachment

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
aaronnayan
Creator III
Creator III
Author

could you help rectfy this statement Anil?

if([Acutal]- <100,'qmem://<bundled>/BuiltIn/arrow_s_r.png'), ([Acutal]- >1,'qmem://<bundled>/BuiltIn/arrow_n_g.png')

Anil_Babu_Samineni

We have inbuilt images for Qlik. Just maximize the expression and bottom side we have bucket called Images. There You have to select as needed. It works like charm if you use below

if( ([Acutal]- ) <100,'qmem://<bundled>/BuiltIn/arrow_s_r.png'),

     If( ([Acutal]- ) >1,'qmem://<bundled>/BuiltIn/arrow_n_g.png'))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

aaronnayan
Creator III
Creator III
Author

That actually does not work i have tried using it

Anil_Babu_Samineni

Does Actual and B are two fields?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
aaronnayan
Creator III
Creator III
Author

no they are  expression column names

Anil_Babu_Samineni

Okay, Then i would suggest you to share MOC application to help. Try with whole expression and then check whether it is working or not

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)