topic Re: num,timestamp? in QlikView

num,timestamp?

Anonymous — Wed, 24 Dec 2014 08:14:25 GMT

Can any one explain example with

num,num#, time ,timestamp# function.

i dont want the examples from help document

give me some general examples?

amit_saini — Wed, 24 Dec 2014 08:16:25 GMT

Hi,

Check below:

Thanks,
AS

MK_QSL — Wed, 24 Dec 2014 08:16:32 GMT

Date and Date# is explained here.. The same way other works.

tresB — Wed, 24 Dec 2014 08:16:57 GMT

its_anandrjs — Wed, 24 Dec 2014 08:22:32 GMT

Hi,

Read this posts

For Num and Num#

For Time and TimeStamp#

Ex:- Assume this example

Load Date,

TimeStamp(TimeStamp#( Date,'MM/DD/YYYY hh:mm'),'MM/DD/YYYY hh:mm') as TimeStampField,//For TimeStamp

Time(TimeStamp#( Date,'MM/DD/YYYY hh:mm'),'hh:mm') as TimeField; //For Time

Load * Inline [

Date

12/24/2014 10:20

];

TimeStamp# :- This converts any string into timestamp number format

Time :- This convert any timestamp into Time.

Regards

Anand