GetFieldSelections for TimeStamps

[hannessch]

Hi Qlikers,

i have a question regarding the GetFieldSelections function.
Our goal is to extract min and max timestamp of a time selection in a line chart. (So the user has not to use or search in a FilterPane). We use this function:

SubField(GetFieldSelections(TimeStampField, ';' , 5000000) , ';' , 1)

We want to store those values into variables, but nevertheless it doesnt work. So the variables are emtpy an when we try to investigate the results from the GetFieldSelections function there is also no value in it. We also considered different seperator values and had a big enough max_value number.

When we tried the function just with the Time Filed it worked and also with the Date Field.

So is there a special format issue with timestamps in GetFiledSelections? Or do you know a different possibility to get the min and max timestamp value from a graph selection?

[sunny_talwar · Accepted solution]

Did you try MinString and MaxString

MinString(TimeStampField)
MaxString(TimeStampField)

[hannessch]

Hi,
not yet but the i have no problem with the slection of the min and max values but instead getting the GetFieldSelection of the timestamp does not work.

[hannessch]

Ok I tried it and it worked!
So thank you very much