Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

GetFieldSelections for TimeStamps

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?

1 Solution

Accepted Solutions

Re: GetFieldSelections for TimeStamps

Did you try MinString and MaxString

MinString(TimeStampField)
MaxString(TimeStampField)
3 Replies

Re: GetFieldSelections for TimeStamps

Did you try MinString and MaxString

MinString(TimeStampField)
MaxString(TimeStampField)
Partner
Partner

Re: GetFieldSelections for TimeStamps

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.

Partner
Partner

Re: GetFieldSelections for TimeStamps

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