topic Re: hi in QlikView

hi

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

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

Anil_Babu_Samineni — Mon, 11 Dec 2017 11:29:05 GMT

May be this?

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

vignesh_s — Mon, 11 Dec 2017 11:33:44 GMT

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

vignesh_s — Mon, 11 Dec 2017 11:35:47 GMT

im geting like ths

Anil_Babu_Samineni — Mon, 11 Dec 2017 11:38:20 GMT

You could change "Representation" from Text to Image.

vignesh_s — Mon, 11 Dec 2017 11:47:15 GMT

no im nt geting it

Anil_Babu_Samineni — Mon, 11 Dec 2017 11:48:32 GMT

Okay

Colin-Albert — Mon, 11 Dec 2017 12:07:40 GMT

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

vishsaggi — Mon, 11 Dec 2017 12:24:46 GMT

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

imrasyed — Mon, 11 Dec 2017 12:57:30 GMT

Hi,

Try this expression in Expression textbox in qliksense

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