Discussion board where members can get started with QlikView.
I want to get first value of possible value form list box.
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.
Go to Solution.
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:
Hope that helps.
Use peek function, If I have understood your problem correctly.
Peek('Timefield', 0, 'table'));
Or refer peek function from help menu.
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.
You are right, peek() function is script function, hence can't be used in expression in UI.