topic Re: GetFieldSelections for TimeStamps in App Development

GetFieldSelections for TimeStamps

hannessch — Sat, 16 Nov 2024 05:05:07 GMT

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?

Re: GetFieldSelections for TimeStamps

sunny_talwar — Mon, 05 Aug 2019 13:52:02 GMT

Did you try MinString and MaxString

MinString(TimeStampField) MaxString(TimeStampField)

Re: GetFieldSelections for TimeStamps

hannessch — Fri, 09 Aug 2019 10:44:59 GMT

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.

Re: GetFieldSelections for TimeStamps

hannessch — Fri, 09 Aug 2019 10:50:48 GMT

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