topic Re: Generating a list using GetFieldSelections() with Transformation in App Development

Generating a list using GetFieldSelections() with Transformation

Sazabi — Fri, 10 May 2019 22:46:00 GMT

Greetings Qlikers,

I am looking to use GetFieldSelections() to generate a list of selected timestamps in their numeric form separated by commas.

=GetFieldSelections(num(timestampField),', '))

^- Does not do the trick 😞

Use Case:

User Selections the Dates: 5/8/2019, 5/9/2019

GetFieldSelections(num()) Returns: 43593, 43594

Any other way to do this?

Regards,

Re: Generating a list using GetFieldSelections() with Transformation

Vegar — Sun, 12 May 2019 05:41:29 GMT

I have not seen or heard of use like this, but you could try to do something like the code expression below.

Concat( NUM( subfield( GetFieldSelections(timestampField), ',')), ', ')

Re: Generating a list using GetFieldSelections() with Transformation

Vegar — Sun, 12 May 2019 05:44:58 GMT

If you can live without the criteria that it had to be selected and accept to include all associated timestampField then you could simplify your expression to this:

=Concat(NUM(timestampField), ', ')