Arrow Over a Expression.

[#1]

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

[ashfaq_haseeb]

Hi,

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

Regards

[antoniotiman]

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

[#4]

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

[#5]

Dear Ashfaq i am used image contained in Qlikview bundle

[antoniotiman]

Hy Vivian,

have You solved ?

Regards

[#7]

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.

[antoniotiman]

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

[#9]

Dear Antonio,

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

[#10]

Give me your personal email, i shall send you qvw