Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

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

Tags (2)
9 Replies
Highlighted

Re: hi

May be this?

if((sum(Revenue)-Sum(BudgetAmount))>0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.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)
Highlighted
Contributor

Re: hi

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

Highlighted
Contributor

Re: hi

1.png

im geting like ths

Highlighted

Re: hi

You could change "Representation" from Text to Image.

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

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)
Highlighted
Contributor

Re: hi

no im nt geting it

Highlighted

Re: hi

Okay

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)
Highlighted

Re: hi

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

Highlighted
Esteemed Contributor III

Re: hi

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

Highlighted
Contributor II

Re: hi

Hi,

Try this expression in Expression textbox in qliksense

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