Posts

 

These days whether you’re a start-up or a big corporation, every business needs tools to communicate quickly and effectively among its members. Instant Messaging (IM) is flexible: you can maintain chat conversations with different people or you can participate in a group conference session. Your online colleagues can be in the same building or on another continent.

IM tools, like Slack, Microsoft Teams, Flock, Hangouts or Salesforce Chatter, provide organizations more than communication, becoming a collaborative tool with features like file sharing, calls or screen sharing; working as a HUB that helps you to maintain your organization connected so you can get things done.

But if you want to be a Data-Driven organization, you will need the data from the analysis in your favourite IM tool to build a closed loop from data to action and LLodi can help you with this. You can get this data manually or you can enjoy the possibilities of integration and let LLodi work for you.

LLodi can drive your digital transformation by providing a tool that can connect Qlik to REST APIs and get the most of Business Intelligence where you need it.

Because of that, we want to give you the guidelines to work in Slack within Qlik, set notifications and alerts and know how to get the most of the Slack API to build distinctive messages, more useful and effective. All this post will be collect in our blog under the tag “Slack Tips”.

Slack is a cloud-based set of proprietary team collaboration tools and services. The name is an acronym for “Searchable Log of All Conversation and Knowledge”. Slack features include direct-messaging capabilities, document sharing, notifications and alerts, group chat and search.

Connect Qlik with Slack is really easy and we will help you to through the process. You can apply this guidelines to use other similar tools so pay attention although you don’t use Slack.

If you don’t have one yet, create your free LLodi account and join a Slack workspace, make your workflows smarter and save time of your team.

Business changes every day, but there are some answers we need to resolve daily. ¿Do I have some pending Issues? ¿There’s any transaction waiting for my approval?

Streamline your day with Qlik and LLodi, let the information come automatically to your preferred Slack channel, set data alerts and invest your time in what really requires your attention.

In this post, we are going to show you how to achieve that, in an easy and quick way.

Sales Channel in Slack

We are going to use our LLodi Writer Connector that allows you to do actions directly from your Qlik Script anytime the app is reloaded, we can leverage the Qlik logic to make our automatic messages smarter and get the information we need when we need it.

We already show you how to Use Slack as your Qlik Alert Center in a previous video, but today we introduce to you our new feature “Direct Payload”. Enabling Direct Payload sends your Qlik Script as it is, so you can add format, indentations and spaces that won’t be trimmed.

Weekly report Script

We can schedule a weekly report in our sales channel, we get the values directly from our data model and we can even modify our message to the team depending on the results so far. We are going to use only Qlik language therefore you can get the most of Qlik Associative engine and logic capabilities.

Let’s take a look at the Script:

SELECT *

FROM Slack

WITH GUID xxxxx-xxxxx-xxxx

WITH FIELDS ( {

“username”:”LLodi Sales Assistant”,

“icon_url”:”https://pbs.twimg.com/profile_images/836639005387161600/P5WRI7RU_400x400.jpg”,

“channel”:”sales”,

“text”:”Hey Team! Find your Weekly Report. For more info: <www.llodi.com|Sales Dashboard>. $(WeeklyMessage)”,

“attachments”:[

{“fallback”:”Weeklyreport fallback”,

“color”:”good”,

“fields”:[{

“title”:”Global:”,

“value”:”*Outbound Mails:* $(CurrentWeekMail), *Previous:* $(PreMail), *Increment:* $(IncrementMail)%”,

“short”:false},

{“value”:”*New Prospects:* $(CurrentWeekProspects)C, *Previous:* $(PreProspects), *Increment:* $(IncrementProspects)%”,

“short”:false}]

},

{“fallback”:”WeeklyReport fallback”,

“color”:”red”,

“fields”:[{

“title”:”Katy Liss:”,

“value”:”*Outbound Mails:* &(NoMail), *Previous:* $(AggrMail), *Increment:* $(IndividualIncrementMail)%”,

“short”:false},

{“value”:”*New Prospects:* $(NoProspects), *Previous:* $(AggrProspects), *Increment:* $(IndicidualIncrementProspect)%”,

“short”:false}]}]})

WITH CONFIG (directpayload “true”);

You can copy this snippet in your script and begin to use it today as a reporting solution. If you don´t have LLodi yet you can create a Free Account and begin your journey!

We are combining the Direct Payload feature with the formatting options from Slack to add more context to our message, making it more useful and effective. We built the structure of our report and then the connector fills it with updated data directly just before sending it to Slack.

Take your team to the next level and become a Data-Driven company, providing them with the answers they need before they have to ask the question. Automate your reports with Qlik and LLodi Writer connector, working smarter and saving time (and money) in the process.