- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The result is different after SAP Connector was changing
Dear.
I need your help.
SAP repository is changed from Oracle to SAP HANA.
Qlik SAP Connector has been reinstalled to suit the environment.
SAP repository was changed from Oracle to SAP HANA.
Qlik SAP Connector has been reinstalled to suit the environment.
And then, The result is different after SAP Connector was changing
The Month, Quarter, Week field include zero(0) at the first of value.
CALDAY : 20220430
CALMONTH : 0202204
CALQUARTER : 020222
CALWEEK : 0202217
Should I reinstall the SAP connector? or Should I transform it at the modeling?
Best Regard
hanna.choi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
seen this before with updating SAP connectors , you have to transform it by using the TEXT function
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is because of Upgrade on SAP + connection, i believe inside of is an Numeric field with 7 characters and Qlik must to add a extra zero at the end of
you can try to use:
Right(CALMONTH ,6)
Right(CALQUARTER ,5)
Right(CALWEEK ,6)
Or Trim(Num('YourField'))
should be removing the zero