Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please, can anyone explain or send me a link that explain step by step on how to us VB Script Macros to Send email through Outlook In QlikView?
Thanks
So far, in Talend, we have been using tDBOutputBulk to insert around 1 million records into a MySQL database with version 5.7. The MySQL database has been updated to version 8 and tDBOutputBulk is not supported in this version. What component do you use instead to ensure that the loading process is not slow?
Hi All,
Please can anyone explain to me how to amend my code below to open outlook app on desktop before sending the report. If the Outlook Desktop App is not opened, the report would be in outbox until the day you open outlook on your desktop before it would send.
Sub mSendMail(pdfFilePath)
Dim objOutlk
Dim objMail
Const olMailItem = 0
' Create a new instance of Outlook application
Set objOutlk = CreateObject("Outlook.Application")
' Create a new mail item
Set objMail = objOutlk.createitem(olMailItem)
' Recipient's email address
objMail.To = "abcd@example.com"
' Subject of the email
objMail.Subject = "Testing " & Date()
' Body of the email
objMail.HTMLBody = "Body of the email, This is an automatic generated email from QlikView."
' Add attachment (use the generated PDF file)
objMail.Attachments.Add pdfFilePath
' Send the email
objMail.Send
' Release resources
Set objMail = Nothing
Set objOutlk = Nothing
End Sub
What should I add to open the desktop App if it has not opened?
Thanks.
Hello
Can anyone suggest how to get this ?
In Qliksense VizLib Line Chart, we can display the negative values in red color where as with Qlik Native Line Chart,there is no provision to display the negative values in red color , Something Like Below
Hi,
I need to show the output highlidhted below in red().
If the difference review date-today() >0 I need to show the difference in the format as highlighted in red().
And one addon like if review date-today() < 365 I need to show like 2 months 11 days instead of 0 years 2 months 11 days.
ref | review date | =today() | review date-today() | difference | Required output |
000AL2 | 01/07/2024 | 21/04/2024 | 71 | <365 | 2 months 11 days |
000AL2 | 01/07/2026 | 21/04/2024 | 801 | >365 | 2 Years 2 months 11 days |
000AL2 | 01/07/2029 | 21/04/2024 | 1897 | >365 | 5 Years 2 months 12 days |
000AL2 | 01/07/2032 | 21/04/2024 | 2993 | >365 | 8 Years 2 months 13 days |
000AL2 | 01/07/2035 | 21/04/2024 | 4088 | >365 | 11 Years 2 months 13 days |
Hello Everyone, I am new to Qlick and use trial version since yesterday. Following tutorial, it is requested to select "auto ML experiment" from the "Add New" drop down menu. But, This field is missing. I am wondering whether this is because I am using a trial version of Qlick...?
Does someone know about it ?
Thank you for your help
Hi,
I am trying to get zero value to be shown in the line chart. I have created a pivot table for the same data that I want to show in line chart. For the year 2024, 2023, 2022 i have created columns and the 2024 column contains zero value for the region for specific month. The same is done in line chart but the zero value for not shown in the line chart.
I have tried toggling all the options under missing data, but nothing worked.
Qlik Enterprise Feb 2024
Is this possible. I see in the documentation that 365 is possible. Currently we get some of our data via email with no source. It is manually entered on a company shared document via SharePoint, of which several data points are input this way. I would really love to be able to connect it. Long term wise we are set to move to 365, but may be done later down the line as there are bigger projects in the works already.
I thought about having a computer with OneDrive Business sync the file, and then share that script to an internal ftp or network drive. But seems a bit excessive for a work around (though it would be very easy to do.)
Hi All,
We were trying to upgrade our QlikSense enterprise version from August 2022 to February 2024.
Steps:
- All services related to QlikSense were stopped (PostgreSQL was running).
- Installed Feb 2024 version, Installation window was success. Pls see below screen.
- Clicked on Finish.
All the Services which was stopped before the installation was running post this installation. But we were not able to launch/use/ QlikSense.
The Server was not reachable post installation. we captured details from the logs folder and restored the Windows server version with the snapshot.
Please suggest what might be the issues due to which the the server was not reachable post installation.
Thanks in advance.
Hi!
I have a dashboard with 2 excel tables in the contents (Table 1 and Table 2). I need to do some KPIs, summarizing, values from table 2, but just the ones that belongs to a list of people in Table 1. The field that I need to use to compare between 2 tables is the "key" between the tables. Is there any way or formula I can use to do that conditional exercise.
Is it clear? Can maybe I build a new table from the 2 existing ones?
Thank you!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!