Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to get a first possible value form list box

Hi all,

I want to get first value of possible value form list box.

For Ex:

Capture14.PNG

Here I have a two possible value(2:45:44 AM and 2:45:46 AM)

And I want to get Value 2:45:44 AM.

Could u please help me.

Thanks in advance.

Regards,

Kabilan K.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens
Not applicable

Re: How to get a first possible value form list box

Hi,

You can either use the Min() function or the FirstSortedValue() function. In this case, I think that the Min() function will be enough, as you want to get the earliest time in the day:

TimeStamp(Min(StartTime))

Hope that helps.

Miguel

5 Replies
Miguel_Angel_Baeyens
Not applicable

Re: How to get a first possible value form list box

Hi,

You can either use the Min() function or the FirstSortedValue() function. In this case, I think that the Min() function will be enough, as you want to get the earliest time in the day:

TimeStamp(Min(StartTime))

Hope that helps.

Miguel

shubham_kumar
Not applicable

Re: How to get a first possible value form list box

Hi Kabilan,

Use peek function, If I have understood your problem correctly.

 

Peek('Timefield', 0, 'table'));

Or refer peek function from help menu.

Thanks,

Skumar

Not applicable

Re: How to get a first possible value form list box

Hi Miguel,

Thank You,

Regards,

Kabilan K.

Not applicable

Re: How to get a first possible value form list box

Hi  Skumar,

I think, We can use the peek() function in Edit script dialog box.

And we can't use it in a Edit expression dialog box.

If, I am wrong Please let me know.

Regards,

Kabilan K.

shubham_kumar
Not applicable

Re: How to get a first possible value form list box

Hi Kabilan,

You are right, peek() function is script function, hence can't be used in expression in UI.

Best Regards,

Skumar