Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
hanna_choi
Partner - Creator

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

SAP Connector.png

 

Should I reinstall the SAP connector? or Should I transform it at the modeling?

 

Best Regard

hanna.choi

Labels (1)
2 Replies
jochem_zw
Employee

seen this before with updating SAP connectors , you have to transform it by using the TEXT function 

TcnCunha_M
Creator III

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

As you think, so shall you become.