Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

sreeni_qvd
New Contributor III

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

Give me any one good examples

Labels (2)
3 Replies
MVP
MVP

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

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



MVP
MVP

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

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..

Not applicable

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

Hi,

Look into this discussion.

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

It may helps.

Community Browser