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

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

sreeni_qvd — Mon, 26 Jan 2026 18:19:17 GMT

Give me any one good examples

tresB — Tue, 10 Sep 2013 09:57:28 GMT

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:

swuehl — Tue, 10 Sep 2013 09:58:02 GMT

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

Tue, 10 Sep 2013 10:41:09 GMT

Hi,

Look into this discussion.

It may helps.