Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,669 members
  • 7,462 online
  • 1,995,569 posts
  • 149,556 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Data Quality, Preparation & Stewardship

    Talend open studio for data quality

    Hey ! I'm on the lookout for Talend for Data Quality software, but I'm having trouble finding it. Can anyone confirm if it's still available for insta... Show More

    Hey !

    I'm on the lookout for Talend for Data Quality software, but I'm having trouble finding it. Can anyone confirm if it's still available for installation? Any help would be greatly appreciated! Thanks in advance! 🙏

    Show Less
  • forum

    QlikView Administration

    Gerenciamento de Documents cal

    Olá a todos,  sou novo aqui e não tenho muita experiencia,  ouvi falar que existe uma feramenta para gestão de documents cal  mas não a encontrei para... Show More

    Olá a todos,  sou novo aqui e não tenho muita experiencia,  ouvi falar que existe uma feramenta para gestão de documents cal  mas não a encontrei para baixar... alguém tem o instalador?  na licença da empresa que trabalho diz que todas estão em uso mas só consigo ver 15. as outras devem estar perdidas/alocadas em algum lugar. poderiam me ajuda?

    Show Less
  • forum

    App Development

    PUSANTE SELEZIONE

    Buongiorno, Come eseguire una selezione multipla su più elementi in un campo mediante un Pulsante ? (Azione: Seleziona nel Campo...) Con Sense si mett... Show More

    Buongiorno,

    Come eseguire una selezione multipla su più elementi in un campo mediante un Pulsante ? (Azione: Seleziona nel Campo...)

    Con Sense si mette il punto e virgola tra un elemento e l'altro, tra apici...ma in View non funziona...

    Grazie, Maurizio

    Show Less
  • forum

    New to Qlik Analytics

    Default selection in Qlik senses

    Hi guys,I am new in Qlik sense.I have a year and quarter filters, when I open the application, default selection is year 2021 and quarter Q2(previous ... Show More

    Hi guys,

    I am new in Qlik sense.

    I have a year and quarter filters, when I open the application, default selection is year 2021 and quarter Q2(previous quarter),how to do that,also I need to reflect 3 charts when selections applied.

    Please help me anyone.

    Thanks in advance 🙏

    Regards,

    Subba

     

     

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    MS SQL server or ODBC or OLEDB

    Hi There   when connecting to a sql server is there any logic when one shoudl use a ODBC or a OLE DB or a MS sql serverconnector? Best Indrani Show More

    Hi There 

     when connecting to a sql server is there any logic when one shoudl use a ODBC or a OLE DB or a MS sql serverconnector?

    Best

    Indrani

    Show Less
  • forum

    App Development

    Format dimension Inline table script

    I have a QV report that I inherited.  It uses an Excel template to read in the left side row labels and the expressions for each cell.  Then there is ... Show More

    I have a QV report that I inherited.  It uses an Excel template to read in the left side row labels and the expressions for each cell.  Then there is an inline table

    This is the excel template-

     

    Brip51_0-1713970985888.png

     

    Then the inline table -

    LOAD
    IF(Match(RowNo(), 1, 4, 6, 10, 15, 17, 20, 22, 26, 29, 31, 34), '<b>') AS _Formatting,
    RowNo() AS _Index,
    _Metric,
    _ExpectedPVCashFlow,
    _Expression2,
    _Expression3,
    _Expression4,
    _Expression5,
    _Expression6,
    _Expression7,
    _Expression8,
    _Expression9,
    _Expression10,
    _CSMLessLRC,
    _Expression11,
    _Expression12,
    _Expression13
     
    FROM $(v_ExcelSource)ToaRe Tracking IFRS PAA.xlsx
    (ooxml, embedded labels, table is IFRSRD);

     

    Then the table uses _metric as a dimension.  Here is the QV report

    Brip51_1-1713971390270.png

     

    I am trying to format the row labels with indentation.  I can make them bold by including

    <b> in the _Format column.

     

    I want to indent particular rows like such –

    CHANGES IN THE STATEMENT OF PROFIT OR LOSS & OCI

        Modified Retrospective

        Fair Value

    Other

    Insurance Revenue

          Incurred claims and other insurance service expenses

          Amortization of insurance acquisition cash flows

              Losses and reversal of losses on onerous contracts

              Adjustments to liabilities for incurred claims

    Insurance Service Expense

        Investment components

    Insurance Service Result

     

     

     

    I have tried to use the format column and &nbsp to insert spaces, but that did not work

    Is this possible to do ?

    Any thoughts on this would be greatly appreciated.

    Thanks,

    Brian

     

    Show Less
  • forum

    Qlik Enterprise Manager

    Qlik sense logging services

    Dear All, I have recently installed Qliksense Feb 2024 version.  After installng I unable to start Qlik Logging servcies and getting below error.  I w... Show More

    Dear All,

    I have recently installed Qliksense Feb 2024 version. 

    After installng I unable to start Qlik Logging servcies and getting below error. 

    I would appreciate if you coud have any suggestion on this ?

     

    aruneshgupta_0-1713970280188.png

    Best Regards,

    Arunesh 

    Show Less
  • forum

    QlikView Integrations

    Sending Email to More than Two Recipients Using Qlikview Macros through Outlook

    Dear All, Anytime I am sending emails to more than two recipients, the macros would give this error "that "Outlook does not recognize one or more name... Show More

    Dear All,

    Anytime I am sending emails to more than two recipients, the macros would give this error "that "Outlook does not recognize one or more names. " and it would highlight objMail.Send in my code. here is my  code: 

    Sub mSendMail(pdfFilePath)
    Dim objOutlk
    Dim objMail
    Const olMailItem = 0

    ' Check if Outlook is already running
    On Error Resume Next
    Set objOutlk = GetObject(, "Outlook.Application")
    On Error GoTo 0

    ' If Outlook is not running, start it
    If (objOutlk = "") Then
    StartOutlook
    ' Wait for 5 seconds for Outlook to start
    ActiveDocument.GetApplication.Sleep 5000

    ' Create a new instance of Outlook application
    Set objOutlk = CreateObject("Outlook.Application")
    End If


    ' Create a new mail item
    Set objMail = objOutlk.createitem(olMailItem)

    ' Recipient's email address
    objMail.To = "example@yahoo.com"

    objMail.Cc = "example2@gmail.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

    if I add BCc to the ' Recipient's email address it would complain : 

    ' Recipient's email address
    objMail.To = "example@yahoo.com"

    objMail.Cc = "example2@gmail.com"

    objMail.BCc = "example3@abc.com" or I added two email to the cc like this 

    Recipient's email address
    objMail.To = "example@yahoo.com"

    objMail.Cc = "example2@gmail.com, example7@abc.com" it would say  "Outlook does not recognize one or more names. " and it would highlight objMail.Send in my code. here is my  code, 

    Please, what can I do to be sending emails to more than 10recipients at the same time .

    Thanks

    Show Less
  • forum

    Qlik Application Automation

    Automation stucked

    Hi, we have an automation in our Qlik Cloud tenant. Untill yesterday 23:00 CET it was stable. But then we facing wierd issue with very begining block.... Show More

    Hi,

    we have an automation in our Qlik Cloud tenant.

    Untill yesterday 23:00 CET it was stable. But then we facing wierd issue with very begining block.

    It should run every hour reload aplication called "SAP checker" (it takes about 11 seconds), if reload is sucessfull then do next. If not stop. Automation properly realoading "SAP checker" but it seems it can not get information that reload was successful or not. Automation is running 4 hours and then failed. I have checked this in chronological and whole of 4 hours it was waiting for this info (succeed or not succeed). There was not any changes within automation. One run was succesfull in between of occuring this issue. What could be the problem here ? 

    {"block":"condition5","index":1,"in_count":1,"timestamp_start":1713905940544382,"timestamp":1713905940544519,"memory_usage":6807456,"out_count":1,"out":true,"in":[{"Argument 1":"2","Condition":"less than or equal to","Argument 2":5,"Result":true}]}
    {"block":"DoReload3","index":1,"in_count":8,"timestamp_start":1713905940544570,"loading":true,"in":{"blendr_on_error":"stop","datasource":"5bf358e0-9ac0-11ec-b635-abf0d828fbef","app_id":"5fd44cda-d1b1-4a02-b446-073b8cac0e08","run_mode":"Wait for reload to complete","timeout":null,"partial":null,"blendr_snippet_guid":"b5dbb7a0-e715-11ea-b2bf-43bb35adee19","blendr_connector_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c"}}

    MT4T_0-1713970537932.png

    Below is screen how should look successful run:

    MT4T_1-1713970697101.png

     

     

     

    Show Less
  • forum

    QlikView Administration

    Getting error for relaoding a task

    Hi,   I am getting an error for reloading a task(in attachment). Could anyone help?   Thanks in advance!
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!