topic Arrow Over a Expression. in QlikView

Arrow Over a Expression.

Tue, 27 May 2014 08:30:28 GMT

Dear Friends. I am having Table chart, using expression SUM([Debit Amount] to show Amounts for all months and Year well.

I want to use a Arrow Marks ups and downs to show up that last month Amount is more than current month and vice versa.

I am using this expression on the lable field of Expression

=if(Max([Debit Amount],Month) < max([Debit Amount],Month-1),'qmem://<bundled>/BuiltIn/arrow_n_r.png',)

which is not working. Please help

Re: Arrow Over a Expression.

ashfaq_haseeb — Tue, 27 May 2014 08:35:04 GMT

Hi,

Make sure representation as image is selected as shown in the image attached.

Regards

Re: Arrow Over a Expression.

antoniotiman — Tue, 27 May 2014 08:41:49 GMT

Hi Vivian,

try

num(sum([Debit Amount]),'$ #,##0.00')&' '& if(Above(sum([Debit Amount])) > sum([Debit Amount]),Chr(9660))

Chr(9660) is Char Unicode of Arrow.

Regards, Antonio

Re: Arrow Over a Expression.

Wed, 28 May 2014 06:39:21 GMT

I used this

if(num(sum([Debit Amount]),'$ #,##0.00')&' '& if(Above(sum([Debit Amount])) > sum([Debit Amount]),Chr(9660)),'qmem://<bundled>/BuiltIn/arrow_n_r.png','qmem://<bundled>/BuiltIn/arrow_s_g.png')

Re: Arrow Over a Expression.

Wed, 28 May 2014 06:40:07 GMT

Dear Ashfaq i am used image contained in Qlikview bundle

Re: Arrow Over a Expression.

antoniotiman — Wed, 28 May 2014 07:46:47 GMT

Hy Vivian,

have You solved ?

Regards

Re: Arrow Over a Expression.

Thu, 29 May 2014 04:03:39 GMT

Dear Antonio,

I guess we should try Set Analysis,

My calendar is like this

and Table Like this

I want to display This arrow marks up or down comparing preceding Expense Amount.

Re: Arrow Over a Expression.

antoniotiman — Thu, 29 May 2014 07:26:19 GMT

Hi Vivian,

if You use qmem You must create a column image.

if You use Chr(9660) and Chr(9650) You have single column.

Use function Above(Sum([Expense Amount])) to compare with preceding Column.

See my previous answer.

Regards,

Antonio

Re: Arrow Over a Expression.

Fri, 30 May 2014 07:01:53 GMT

Dear Antonio,

I tested as per your suggession, it doesnt worked me for me

Re: Arrow Over a Expression.

Fri, 30 May 2014 07:06:46 GMT

Give me your personal email, i shall send you qvw

Re: Arrow Over a Expression.

antoniotiman — Fri, 30 May 2014 07:15:37 GMT

Hi Vivian,

my e-mail mancini@teseo.it

Regards

Re: Arrow Over a Expression.

Fri, 30 May 2014 09:09:14 GMT

Dear All.

Thank you for views and support.

I have Followd ANTONIO MANCINI suggession, and its successfully working.

Here is the CODE given by ANTONIO MANCINI for reference

If(RowNo() > 0 and Dimensionality() > 0,

if(Before(sum([Debit Amount])) > sum([Debit Amount]),

'qmem://<builtin>/Arrow_S_R.png','qmem://<builtin>/Arrow_N_G.png'))

Re: Arrow Over a Expression.

Fri, 30 May 2014 09:31:13 GMT

Dear ANTONIO,

I also want to skip arrow if the value is zero,

i tried this, it worked for down arrow, but not up arrow.

If(RowNo() > 0 and Dimensionality() > 0,

if(After(sum([Debit Amount])) > sum([Debit Amount]) and sum([Debit Amount])>0,

'qmem://<bundled>/BuiltIn/arrow_s_g.png'),

If(RowNo() > 0 and Dimensionality() > 0,

if(After(sum([Debit Amount])) < sum([Debit Amount]) and sum([Debit Amount])>0,

'qmem://<bundled>/BuiltIn/arrow_n_r.png')))

Re: Arrow Over a Expression.

antoniotiman — Fri, 30 May 2014 09:38:06 GMT

if(RowNo() > 1 and Dimensionality() > 0 and [Debit Amount] <> 0,...........

Re: Arrow Over a Expression.

Fri, 30 May 2014 10:29:27 GMT

Dear ANTONIO,

Thank you, its working