Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

seoco_be
New Contributor III

Input Box Currency Format

Hello,

I created an input box linked to a variable vMyVar with as constrain Num#(vMyVar,'#.##0,00', ',' , '.')

My default format looks like:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00;(#.##0,00)';

I created an input box linked to vMyVar.

In a chart/table I have an expression:

 

((sum([Hours1])+sum([Hours2]))*$(vMyVar))/sum([total_books])

The Hours1 and Hours2 are displayed like 1.000,50

In QVD they look like 1000.50

When I enter 1.5 in the input box then the calculation is correct.

When I add 1,5 in the input box then I don't get any result.

Does anybody know why?

Thx

1 Solution

Accepted Solutions
Not applicable

Re: Input Box Currency Format

Or use Replace function to allow entering both 1.5 and 1,5.

4 Replies

Re: Input Box Currency Format

Try $(=num#(vMyVar,'#.###,00',',','.')) in your expression instead of $(vMyVar)


talk is cheap, supply exceeds demand
Not applicable

Re: Input Box Currency Format

Or use Replace function to allow entering both 1.5 and 1,5.

seoco_be
New Contributor III

Re: Input Box Currency Format

Thx, this iw working perfect

seoco_be
New Contributor III

Re: Input Box Currency Format

Thx, is working perfect

Community Browser