Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

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
Esteemed Contributor III

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

is the column names are availble in  table2 also? 

paulyeo11
Valued Contributor II

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

Hi Chanty

I though currency sign is control by below code :-

$(vMoneyFormatK))

Not sure what you mean ?

Paul

Chanty4u
Esteemed Contributor III

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

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

Chanty4u
Esteemed Contributor III

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

or else

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

paulyeo11
Valued Contributor II

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

Hi chanty

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

Paul

Sent from my iPhone

paulyeo11
Valued Contributor II

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

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
Esteemed Contributor III

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

did u try with the sample  data  with same exp?

or else u can restrt ur Qvw