Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
vignesh_s
Creator
Creator

hi

Can any 1 give the expression for below image,i.e., i need expression for optaining up and down arrows in green and red respectivly

if sum(Revenu)-Sum(BudgetAmount)>0 green up arrow (or) red down arrow

1.png

9 Replies
Anil_Babu_Samineni

May be this?

if((sum(Revenue)-Sum(BudgetAmount))>0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vignesh_s
Creator
Creator
Author

'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')  what is this?

vignesh_s
Creator
Creator
Author

1.png

im geting like ths

Anil_Babu_Samineni

You could change "Representation" from Text to Image.

And here we go -- Replacing images with Geometric Shapes as visual cues

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vignesh_s
Creator
Creator
Author

no im nt geting it

Anil_Babu_Samineni

Okay

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Colin-Albert

Hi Vignesh,

It would be helpful in getting a quick response and for others searching for answers, if you gave your post a meaningful title rather than just "Hi".

Qlik Community Tip: How to Get Answers to Your Post

vishsaggi
Champion III
Champion III

Did you try what Anil suggested changing Representation to Image? If not could you please share a sample app you are having issues with?

Capture.PNG

imrasyed
Partner - Creator II
Partner - Creator II

Hi,

Try this expression in Expression textbox in qliksense

if(SUM(Revenue)< Sum(Budget),SUM(Revenue)&'▲',SUM(Revenue)&'▼')