Whet is the difference B/W Num and Num#, Interval and interval# functions

[sreeni_qvd]

Give me any one good examples

[tresesco]

In sort, here functions with # reads data in the format you mention, whereas, similar fucntion formats data in the format you mention.

Example:

Num('111.001','####')  gives you 111   // as your format '####' says

num#( A, 'abc#,#' ) where
A=abc123,4 returns:

	Setting 1	Setting 2
String	abc123,4	abc123,4
Number	123.4	1234

[swuehl]

num#() is parsing a text as a number, num() is formatting a number as a text (using the appropriate dual representation in both cases).

=num#('12.6','#.#' , '.')  // parse the string as number with decimal point '.'

=num(num#('12.6','#.#' , '.'),'#,#', ',') // parses the string and create a new text representation with decimal sep ','

edit: forgot the format codes..

[#4]

Hi,

Look into this discussion.

http://community.qlik.com/thread/37295

It may helps.