Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

why currency sign can display on table 1 but not display on Table 2 USING SAME EXPRESSION ?

Hi All

I have below expression from table 1 it can display currency sign :-

Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))

When i apply the above expression to Table 2 , the currency sign does not appear.

I have check on Table 2 expression  :-

1.Make sure the expression at number tab set to expression default.

2. I don't know why table 1 expression with Dimension 601 select not work ?

Paul

7 Replies
Chanty4u
MVP
MVP

is the column names are availble in  table2 also? 

paulyeo11
Master
Master
Author

Hi Chanty

I though currency sign is control by below code :-

$(vMoneyFormatK))

Not sure what you mean ?

Paul

Chanty4u
MVP
MVP

SET MoneyFormat='$#,##0.00;-$#,##0.00';

Chanty4u
MVP
MVP

or else

in chart properties,on number tab, right down, you can define the symbol for pound, dollar..etc....

paulyeo11
Master
Master
Author

Hi chanty

Mine currency is dynamic depend my source data from each country.

Paul

Sent from my iPhone

paulyeo11
Master
Master
Author

In my expression I already set the currency sign , I use same expression but it display on one table but not table 2

Sent from my iPhone

Chanty4u
MVP
MVP

did u try with the sample  data  with same exp?

or else u can restrt ur Qvw