topic How to get a first possible value form list box in QlikView

How to get a first possible value form list box

Mon, 01 Oct 2012 11:55:05 GMT

Hi all,

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

For Ex:

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.

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

Miguel_Angel_Baeyens — Mon, 01 Oct 2012 12:04:21 GMT

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

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

Anonymous — Mon, 01 Oct 2012 12:06:59 GMT

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

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

Mon, 01 Oct 2012 12:07:04 GMT

Hi Miguel,

Thank You,

Regards,

Kabilan K.

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

Mon, 01 Oct 2012 12:14:22 GMT

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.

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

Anonymous — Mon, 01 Oct 2012 12:35:33 GMT

Hi Kabilan,

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

Best Regards,

Skumar