topic Re: Valueloop to Time Format in QlikView

Valueloop to Time Format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qlikers,

I need to convert

=Valueloop($(Start), $(End), $(Step))

into time format...

I tried with Time# and Time combination but no success...

Any suggestion?

Re: Valueloop to Time Format

Kushal_Chawda — Wed, 16 Mar 2016 07:28:23 GMT

I am not sure but you can try this

=Valueloop(frac(time#('$(Start)','hh:mm:ss')), frac(time#('$(End)','hh:mm:ss')), 1)

Re: Valueloop to Time Format

Gysbert_Wassenaar — Wed, 16 Mar 2016 07:31:28 GMT

A step of 1 would mean steps of 1 day. Perhaps a different interval is more useful: hour - 1/24, minute - 1/1440, second - 1/86400

Re: Valueloop to Time Format

Kushal_Chawda — Wed, 16 Mar 2016 07:33:35 GMT

Yeah gwassenaar‌. thanks for correction

Re: Valueloop to Time Format

Anonymous — Wed, 16 Mar 2016 07:34:05 GMT

Kush,

I have already tried like what you suggested but thing is what when

I use inside valueloop() it gives me blank '-'

Re: Valueloop to Time Format

Anonymous — Wed, 16 Mar 2016 08:34:40 GMT

Did not work...

Attaching the Sample....

Need Value as per Slider Time in Straight table instead of numeric value in Valueloop Sheet

Re: Valueloop to Time Format

marcus_sommer — Wed, 16 Mar 2016 12:56:12 GMT

AFAIK there is no way to format a valueloop which required always pure numeric values. I have earlier tried some things even with $-sign expansion and dual-functions but nothing seems to work. Easier is to emulate this with normal date/time-fields, see the example within the attachment.

- Marcus

Re: Valueloop to Time Format

Anonymous — Wed, 16 Mar 2016 13:18:13 GMT

Marcus,

Thanks for clearing on Valueloop formatting!!

In my scenario, Customer is looking for 11:30 - 11:30 window where

11:30 - 23:59 represent current selected date data for 2nd half

00:00 - 11:30 represent next date of current selected date for 1st half

From my earlier post, Bill gave me almost what I am looking for with your inputs but it is with Field Value......(see the attached)

I want same in ValueLoop sheet but with the Custom slider option..

Any other way instead of using Valueloop(), Can I get functionality like Class() with Custom slider option?

Re: Valueloop to Time Format

Gysbert_Wassenaar — Wed, 16 Mar 2016 13:26:59 GMT

The class function works, but the problem is that your first time doesn't start at exactly a half hour interval. But perhaps a better solution is to create a new time field in the script based on for example half hour intervals:

Time(Floor(T_SEG, 1/48),'hh:mm') as T_SEG_30MIN_INTERVAL

Re: Valueloop to Time Format

Anonymous — Wed, 16 Mar 2016 13:28:55 GMT

Meanwhile I am trying on your suggestion with simple date/time fields, will let you know if it works

Re: Valueloop to Time Format

Anonymous — Wed, 16 Mar 2016 13:37:08 GMT

Gysbert,

Creating a new field at script will make it hard coded but here in this case this interval would be dynamic...

And what about this?

'The class function works, but the problem is that your first time doesn't start at exactly a half hour interval."

Are you pointing to slider time representation?

Re: Valueloop to Time Format

marcus_sommer — Wed, 16 Mar 2016 14:07:43 GMT

Here a small adjustment to the example from yesterday with variables instead of field within the slider. The change now is that a trigger is set by changing the VInput variable which changed then the T12 variable which then changed also the slider-area - maybe it comes a bit nearer to what you want.

- Marcus