Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if(RowNo() > 1 and Dimensionality() > 0 and [Debit Amount] <> 0,...........
Hi,
Make sure representation as image is selected as shown in the image attached.
Regards
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
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')
Dear Ashfaq i am used image contained in Qlikview bundle
Hy Vivian,
have You solved ?
Regards
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.
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
Dear Antonio,
I tested as per your suggession, it doesnt worked me for me
Give me your personal email, i shall send you qvw