Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,527 members
  • 9,369 online
  • 1,995,305 posts
  • 149,525 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Initial Data Load Too Large - alternatives???

    I'm new to Qlik sense -  I'm a new Qlik Sense business analysis and I'm building a Qlik Sense app for analysis to replace excel VBA code to pull histo... Show More

    I'm new to Qlik sense - 

    I'm a new Qlik Sense business analysis and I'm building a Qlik Sense app for analysis to replace excel VBA code to pull historical purchases for one or more items - IT will no longer support the excel VBA :(. My organization is large and the total number of records in my PO data warehouse exceeds over well over 100M records. Requirement is that I use Qlik Sense to pull the same data as the excel VBA code.

    My only search criteria is item number. There is no limit to time, geography or entity. 

    When i build the SQL to the data warehouse, I write the SQL in the Data Load Editor and it pulls all PO data... over 100M+ records. Couple of challenges:

    1/ When Qlik Sense users attempt to use the app, they often run into Out of Memory errors.

    2/ When the App works, it takes more than 20min for the sheet to display and users can enter item numbers. 

    Questions:

    1/ is this expected behavior for Qlik Sense to frequently result in errors for such large data sets? I filtered the data sets to return about 50M records and it still results in error, sometimes. 

    2/ Is there a way in Qlik Sense to allow users to enter the item numbers BEFORE the initial data load and have only the required item number PO history be pulled? 

    3/ I tried building a QVD file but it takes 20 min to load the data then another 30 minutes to index. Waiting nearly an hour to run a report doesn't seem to make sense. 

    What other options, if any, do i have in Qlik Sense to limit the initial data load? 

    Show Less
  • forum

    Qlik Application Automation

    How to change github credentials in automation

    Hi, I have an automation to push apps into GitHub - we have set up a connection to a private GitHub account and all is working fine, but now we want t... Show More

    Hi,

    I have an automation to push apps into GitHub - we have set up a connection to a private GitHub account and all is working fine, but now we want to use a different account but the connection properties don't allow a change because other automations are using it. I tried changing connection properties on the other automations but that disallows it for the same reason. 

    In the connection properties there is an option to add a Git connection but on selecting this, it flashes up an empty browser window and says 'Connection is linked' and cannot be changed. 

    Other people have suggested the only way to change the connection is to delete the dependent automations and start again but this seems like a bit of harsh solution.

    So is there a way to change the connection properties?

    Thanks

    Show Less
  • forum

    Qlik Enterprise Manager

    Error While Applying Licensed Key in QMC

    Hi, we are not able to apply the license key in QMC, while applying it we are getting below error.Please help us.   Regards Ediyakula Varaprasad.   Show More

    Hi,

    we are not able to apply the license key in QMC, while applying it we are getting below error.Please help us.

     

    Regards

    Ediyakula Varaprasad.

     

    Show Less
  • forum

    Deployment & Management

    Qlik Cloud cannot access script or duplicate app

    Hi, My client has a Qlik Cloud tenant and some apps that they want to export as qvf-files. For some reason it's not possible to copy them, export them... Show More

    Hi,

    My client has a Qlik Cloud tenant and some apps that they want to export as qvf-files. For some reason it's not possible to copy them, export them or access the script in them. They were published to a managed space and I followed the Qlik CLI instructions in this forum post: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Cloud-How-to-Export-apps-from-Managed-spaces-or-unpublish/ta-p/1761101
    However it is still not possible to do any of the actions mentioned above. I have tried making myself (and the client) the owner of the apps and moved them to both shared and personal spaces. Nothing seems to help.
    What might be wrong and how do I solve it?

    Show Less
  • forum

    New to Qlik Analytics

    Where i download princing list on partner portal

    Hello, Where i download princing list on partner portal Thanks, Sophie
  • forum

    App Development

    Show PDF (Base64) as Picture in App

    Dear all,   I have a T-SQL table with a list of PDFs. Each PDF is a 1 single page encoded in varbinary max.   I was able to convert this varbinary to ... Show More

    Dear all,

     

    I have a T-SQL table with a list of PDFs.

    Each PDF is a 1 single page encoded in varbinary max.

     

    I was able to convert this varbinary to a base64 but I cannot display the result with 'data:image/jpg;base64' into a table.

    Is there some other balise or viewer that can display base64 PDF in QlikSense ?

    Or any way to convert a PDF to PNG Base64 ?

     

    Thanks,

    Sébastien

    Show Less
  • forum

    New to Qlik Analytics

    Get selected field values using QlikSense.NetSDK

    Hello I would like to get the selected values of an app field using the .NET SDK. Using the capability API, I can use the following code:        var a... Show More

    Hello

    I would like to get the selected values of an app field using the .NET SDK.

    Using the capability API, I can use the following code:

           var app = qlik.openApp('55d31b81-55c5-4620-95f5-7d4b95faced9');
            var genericObject = {
                date: {
                    qStringExpression: '=GetFieldSelections([Datum performance])',
                },
            };
            app.createGenericObject(genericObject, result => {
                console.log(
                    `GetFieldSelections([Datum performance]) = ${result['date']}`            );
            });

    Which outputs the correct selected value(s):

    GetFieldSelections([Datum performance]) = 19/04/2024

    Update 13:03: Suddenly, the above code also returns -, probably meaning that no value has been selected, although when I open the app in the hub, a value is selected.

    However, I must move the logic from extension to a C# backend. I found very little documentation, but assume the following code should work.

    var app = await location.AppAsync("55d31b81-55c5-4620-95f5-7d4b95faced9");
    var date = await app.EvaluateAsync("=GetFieldSelections([Datum performance])");

    _output.WriteLine($"GetFieldSelections([Datum performance]) = {date}");

    However, this snippet outputs:

    GetFieldSelections([Datum performance]) = -

    Which means no fields are selected.

    Removing the = sign before the expression did not help.

    I also tried to get the selected values using the (GetAllFieldValues Method | Qlik Sense for developers Help) method, both by specifying the StateEnumType.SELECTED or testing the state when requesting all values, to no avail.

    Can anybody please help me pointing out what I am doing wrong?

    Thanks in advance,

    Henk-Jan.

    Show Less
  • forum

    Qlik Application Automation

    How to Open Outlook App using VBScript Macros in QlikView

    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 Ap... Show More

    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.

    Show Less
  • forum

    Qlik Application Automation

    How to Use VB macros to send Email through Outlook in QlikView

    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... Show More

    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 

    Show Less
  • forum

    Design and Development

    The tDBOutputBulk does not support Amazon Aurora Amazon Aurora and MySQL 8.0

    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 ... Show More

    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?

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!