topic Re: Difference in QlikView

Difference

MK_QSL — Thu, 18 Jul 2013 10:01:12 GMT

Hello Communty.

Can someone please explain differences between below with examples....

NUM and NUM#

DATE and DATE#

Re: Difference

er_mohit — Thu, 18 Jul 2013 10:03:50 GMT

see the attached file for date And date #

and go to this link for num and num#

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

Re: Difference

MK_QSL — Thu, 18 Jul 2013 10:05:17 GMT

attchment?

Re: Difference

Thu, 18 Jul 2013 10:07:24 GMT

The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format set in the operating system is used.

Example:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Number format	# ##0,#	#,##0.#

num( A, '0.0' ) where A=35648.375 returns:

	Setting 1	Setting 2
String	35 648 375	35648.375
Number	35648375	35648.375

num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:

	Setting 1	Setting 2
String	35,648.00	35,648.00
Number	35648	35648

The num# function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the default number format set by script variables or in the operating system is used.

Examples:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Number format	# ##0,#	#,##0.#

num#( A, '#' ) where A=35,648.375 returns:

	Setting 1	Setting 2
String	35,648.375	35648.375
Number	-	35648.375

num#( A, '#.#', '.' , ',') where A=35,648.375 returns:

	Setting 1	Setting 2
String	35,648.375	35,648.375
Number	35648.375	35648.375

The date function formats the expression as a date according to the string given as format-code. If the format code is omitted, the date format set in the operating system is used.

The date# function evaluates the expression as a date according to the string given as format-code. If the format code is omitted, the default date format set in the operating system is used.

example--

date(date#(Month,'MMM'),'MMM')as Monthes;

here date#() function tells the format of your datefield.

and date() function tells the in which format you want the datefield.

Re: Difference

nizamsha — Thu, 18 Jul 2013 10:43:10 GMT

Date

it will display the format what u want

= Date( max(FiscalYear),'YYYY-DD-MM')

date(expression [ , format-code ])

The date function formats the expression as a date according to the string given as format-code. If the format code is omitted, the date format set in the operating system is used.

DAte#

date#(expression [ , format-code ])

The date# function evaluates the expression as a date according to the string given as format-code. If the format code is omitted, the default date format set in the operating system is used

num

num(sum(Line_Total)/100000,'#,##0' & ' L')

sum(linetotal) ..............> expression

#,##0.00 ........> format code

.00 ..........>decemimal seprator

L.........> indicating lakhs

##0 after 3 value , willl be the seprator

eg,like this 12,345,678,982