Qlik Application Automation select report values greater than timestamp

[p_verkooijen]

I want to select all values >= a giving timestamp using Add Selections to Sheet

Got a timestamp formatted in the correct way however it does not select values as expected.

[AfeefaTk · Accepted solution]

Hi @p_verkooijen 

Thanks for reaching out

Can you try using the 'Select Field Values By Query' endpoint to make selection and then use the 'List Current Selections' endpoint from Qlik Cloud Services connector to get active selections of the specified app.

Within the 'List Current Selections' endpoint use the Loop block to loop over all the active selections and  then map the field name and values to the 'Add Selection to Report' endpoint in the Qlik Reporting connector

Please find the attached workspace and let us know if that solves your issue

Please check the following article for information about how to add DateTime: https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/date-time-...

For the "Select Field Values By Query" block, please use the 'do lookup' functionality in the 'Field Value Search String' input parameter to get the date serial number value corresponding to a Date/DateTime

Thanks!!

Afeefa TK