topic Re: Timestamp value loop question in QlikView

Timestamp value loop question

Thu, 11 Dec 2014 19:38:06 GMT

I have a min/max date and need to create a value loop that I will used to list predefined values in a dropdown menu. It is not displaying the value correctly so I am testing it by outputting to a text box. I can't explain the results I am getting so looking for some assistence:

1. This works as expected:

Expression: = Timestamp(vMaxDate) & ' ' & Timestamp(vMinDate)

Output: 12/11/2014 12:00:00 AM 5/31/2013 12:00:00 AM

2. This works as expected:

Expression: = Concat( Timestamp( Valueloop( Today(1)+2, Today(1), -(1/24) ) ) , ',' )

Output: 12/11/2014 10:00:00 AM,12/11/2014 10:00:00 PM,12/11/2014 11:00:00 AM,12/11/2014 11:00:00 PM,12/11/2014 12:00:00 AM,12/11/2014 12:00:00 PM,12/11/2014 1:00:00 AM,12/11/2014 1:00:00 PM,12/11/2014 2:00:00 AM,12/11/2014 2:00:00 PM,12/11/2014 3:00:00 AM,12/11/2014 3:00:00 PM,12/11/2014 4:00:00 AM,12/11/2014 4:00:00 PM,12/11/2014 5:00:00 AM,12/11/2014 5:00:00 PM,12/11/2014 6:00:00 AM,12/11/2014 6:00:00 PM,12/11/2014 7:00:00 AM,12/11/2014 7:00:00 PM,12/11/2014 8:00:00 AM,12/11/2014 8:00:00 PM,12/11/2014 9:00:00 AM,12/11/2014 9:00:00 PM,12/12/2014 10:00:00 AM,12/12/2014 10:00:00 PM,12/12/2014 11:00:00 AM,12/12/2014 11:00:00 PM,12/12/2014 12:00:00 AM,12/12/2014 12:00:00 PM,12/12/2014 1:00:00 AM,12/12/2014 1:00:00 PM,12/12/2014 2:00:00 AM,12/12/2014 2:00:00 PM,12/12/2014 3:00:00 AM,12/12/2014 3:00:00 PM,12/12/2014 4:00:00 AM,12/12/2014 4:00:00 PM,12/12/2014 5:00:00 AM,12/12/2014 5:00:00 PM,12/12/2014 6:00:00 AM,12/12/2014 6:00:00 PM,12/12/2014 7:00:00 AM,12/12/2014 7:00:00 PM,12/12/2014 8:00:00 AM,12/12/2014 8:00:00 PM,12/12/2014 9:00:00 AM,12/12/2014 9:00:00 PM,12/13/2014 12:00:00 AM

3. This doesn't work as expected:

Expression: = Concat( Timestamp( Valueloop( Timestamp(vMaxDate), Timestamp(vMinDate), -(1/24) ) ) , ',' )

Output: None

Re: Timestamp value loop question

maxgro — Thu, 11 Dec 2014 19:47:38 GMT

it seems your third expression works

see attachment

Re: Timestamp value loop question

Thu, 11 Dec 2014 20:27:50 GMT

Yes, I am able to use yours, and made a few simple changes to help isolate the issue. It appears to depend on the space between Min/Max. I tried the following in the reload script:

// Works

let vMinDate = Timestamp( MakeDate(2014, 8, 1 ) );

let vMaxDate = Timestamp( today(1) );

// Doesn't work

let vMinDate = Timestamp( MakeDate(2014, 7, 1 ) );

let vMaxDate = Timestamp( today(1) );

// Works

let vMinDate = Timestamp( MakeDate(2014, 7, 1 ) );

let vMaxDate = Timestamp( MakeDate(2014, 9, 1) );

Re: Timestamp value loop question

Peter_Cammaert — Thu, 11 Dec 2014 21:05:02 GMT

I think the explanation is simple: ValueLoop works with values, not dual() values (strings are discarded) nor string timestamps. Some constructs will refuse to produce date values and some constructs will refuse to produce anything, although the ValueLoop does work. For example, omit the outer TimeStamp call in your third expression, and suddenly the ValueLoop-Concat combo kicks in...

= Concat( Valueloop( Timestamp(vMaxDate), Timestamp(vMinDate), -(1/24) ) , ',' )

Also take care of not mistaking TimeStamp for TimeStamp# and vice-versa.

Peter

Re: Timestamp value loop question

Thu, 11 Dec 2014 21:23:01 GMT

Yes, the expression you listed does work to show all timestamps as values. Are you saying it is not possible to display each of these as a timestamp?

Re: Timestamp value loop question

Peter_Cammaert — Thu, 11 Dec 2014 21:41:17 GMT

Apparently not. Everything I tried failed, unfortunately.