topic Re: Difference between # and normal functions in QlikView

Difference between # and normal functions

Wed, 12 Nov 2014 05:50:27 GMT

Hello all,

Can anybody explain in the following in brief:

time vs time#

date vs date#

num vs num#

timestamp vs timestamp#

Thanks in advance

Re: Difference between # and normal functions

tresB — Wed, 12 Nov 2014 05:53:21 GMT

Basically,

Num() - changes format only (without making any change in the original backend data)

Num#() - parses/reads the data according to mentioned format.

Read this: Re: Num vs num #

The rest are similar.

Re: Difference between # and normal functions

danieloberbilli — Wed, 12 Nov 2014 05:56:38 GMT

time() is only about the format (kind of 'layouting' the value)

time#() is about interpreting...telling QlikView that this string is actually a Time/Date/Timestamp... only if QlikView interprets a field/value correctly you can use it properly and formatting it with time()

Re: Difference between # and normal functions

Wed, 12 Nov 2014 06:02:55 GMT

num()chnages the format,num#()changes the data according given format

Re: Difference between # and normal functions

Wed, 12 Nov 2014 06:08:17 GMT

time() changes the time format

Re: Difference between # and normal functions

ashfaq_haseeb — Wed, 12 Nov 2014 06:18:08 GMT

Check this too.

http://community.qlik.com/message/553459#553459

Regards

ASHFAQ

Re: Difference between # and normal functions

MK_QSL — Wed, 12 Nov 2014 07:31:52 GMT

Date#() is used to convert a Text/String into a Number with a specific format

Date( ) is used to format a number to specific format

Look at the below example...

Considering you have below Default Date Format in you script

SET DateFormat='DD/MM/YYYY';

Now Take an example of below sample code

Load * Inline

[

InvoiceDate

14-05-2014

];

Create a Text Box in your UI and write below

=NUM(InvoiceDate)

You will get - even though QlikView consider InvoiceDate as Number

Because your default date format is DD/MM/YYYY and QlikView can't match DD-MM-YYYY and DD/MM/YYYY. So we need either to change the Default Date Format or need to tell QlikView that InvoiceDate is actually a Date.. How?

Use below in your Script

Load

Date(Date#(InvoiceDate,'DD-MM-YYYY')) as InvoiceDate

Inline

[

InvoiceDate

14-05-2014

];

This will convert InvoiceDate to the Date Format as per your Script... i.e. 14/05/2014

Now if use =NUM(InvoiceDate) in you text box you will get actual number corresponds to the InvoiceDate

We can directly use as below in your Text Box

=NUM(Date#(InvoiceDate,'DD-MM-YYYY'))

============================================

Same way we can use TimeStamp, Time and Num....

Hope this would be helpful...