How to Use Timestamp field as a filter in Qlik Gold Client?

[Miguelsantunes]

How to Use Timestamp field as a filter in Qlik Gold Client?

In Qlik Gold Client version 8.7.3 and prior releases the following Timestamp issues were reported:

1. Timestamp fields are populating (with minor discrepancies), but the number of records is not calculated. Number of records is displaying 0 (zero) in Export Control screen.
2. Timestamp fields are populating with initial values, and the number of records is not calculated. Number of records is displaying 0 (zero) in Export Control screen.
3. The timestamp value is also not correct:
   Example:  1.12.2022 to 29.12.2022 should be calculated as 01.12.2022 00:00:00 to 29.12.2022 23:59:59.
   o but it is calculated as 30.11.2022 21:00:00 to 29.12.2022 20:59:59.
4. Timestamp fields are unavailable as primary date fields in Data Framework.

If you are facing any of these issues, please upgrade to the latest version of Gold Client. All these fixes related to Timestamps were included in Gold Client 8.7.4 and later versions.

Regarding Timestamp fields not being available as a primary date field (4) in Data Framework, a specific configuration needs to be added in Gold Client:

1- Identify the corresponding domain for the field(s):

For example, table SCMG_T_CASE_ATTR has 3 timestamp fields, all with the same domain:

Field name	Data Element	Domain
CREATE_TIME	SCMG_CREATE_TIME	SCMG_TIMESTAMP
CHANGE_TIME	SCMG_CHANGE_TIME	SCMG_TIMESTAMP
CLOSING_TIME	SCMG_CLOSING_TIME	SCMG_TIMESTAMP

2- Add the corresponding field domain(s) in the Gold Client Configuration:

Gold Client > Configuration > Administration > Maintain Timestamp Types

Domain/Dtel/ConvExit: SCMG_TIMESTAMP

TimSt/DM: Timestamp

Active: 

Save

After that, the Timestamp fields should be available in the search help of Primary Date Field in Gold Client’s Data Framework:

If you are unable to resolve the issue, Please contact our Support.

Tags:

• Timestamp
• SAP
• Qlik Gold Client

Labels  

• Qlik Gold Client