Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jackvier
Partner
Partner

Qlik Web Connector - SugarCRM

How i extract Revenue data from SugarCRM using Qlik Web Connector?

5 Replies
Darren_Ball
Employee
Employee

Hi,

Thanks for your question.

Due to the structure of SugarCRM, I believe that the revenue lines are part of an opportunity, which would have it's 'sales stage' set to 'Closed Won'.

As such, if you run the Opportunities table in the Qlik SugarCRM Connector, you'll find a field called 'sales_stage' with the opportunities at various states such as 'Closed Won', 'Closed Lost' etc.

Bringing this table into Qlik you'll be able to identify and calculate your revenues.

I hope this helps. If you have further questions, please let me know.

jackvier
Partner
Partner
Author

No, i need to read variables in the module "Revenues".

I think is read CustomModule, but y don't have how call this module.

sugar-error.png

Darren_Ball
Employee
Employee

Hi,

Can you confirm if the 'Revenues' module is a custom module that you've set up, as I can't see a Revenues Module in our SugarCRM development environment.

Thanks

jackvier
Partner
Partner
Author

sugarcrm-revenues.png

fredlee33
Partner
Partner

Hi,

Have you tried to configure the Web Connector for SugarCRM to pull data from a Custom Module?


Based on the screenshot you've provided, the custom module name is Z0001_Revenues (i.e. the name after the # in the URL).


Regards,


Fred


Note: As of the current release, SugarCRM does not include an out-of-the-box Revenue module.