Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 230,803 members
  • 4,260 online
  • 2,013,438 posts
  • 151,141 Solutions
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Application Automation

    How do I get the qlik sense filter to do or operate on a condition of filter 1 o...

    We now have 3 bars of data: the first is ID 1,name aaa,gender:boy, the second is ID 2,name bbb,gender:boy, and the third is Id 3,name ccc,gender: gril... Show More

    We now have 3 bars of data: the first is ID 1,name aaa,gender:boy, the second is ID 2,name bbb,gender:boy, and the third is Id 3,name ccc,gender: gril, now I want to use the filter provided by qlik sense to filter all the data whose name is aaa or gender is girl. How can I achieve this? Normally you should get data with ID 1 and ID 3

    Qlik Cloud

    Show Less
  • forum

    Connectivity & Data Prep

    Random store error with Google Drive connector Saas

    Hello guys, I am facing since the 6th december 2022 a problem with applications using Store instruction on a Google Drive folder. Everything worked fi... Show More

    Hello guys,

    I am facing since the 6th december 2022 a problem with applications using Store instruction on a Google Drive folder.

    Everything worked fine until this date. Applications runned hourly without any problems and all my QVDs were generated correcly.

    Since the 6th december at 08:00 PM CEST, my reload tend to fail on a random Store instruction. By random, I mean that it is not especially one QVD.

    I have 2 types of error thatI am facing

    Data has not been loaded. Please correct the error and try loading again.
    The following error occurred:
    Cannot open file: 'lib://Google drive connector/<idfolder>/accounts.qvd' (Connector error: Error completing job: Object reference not set to an instance of an object.)
    The error occurred here:
    Store accounts into [lib://Google drive connector/<idfolder>/accounts.qvd] (qvd)
    Data has not been loaded. Please correct the error and try loading again.
    The following error occurred:
    Cannot open file: 'lib://Google drive connector/<idfolder>/projet .qvd' (Connector error: Exception in reading response chunk for upload: Status(StatusCode="Unknown", Detail="Error during upload: Object reference not set to an instance of an object."))
    The error occurred here:
    Store projet into [Google drive connector/<idfolder>/projet .qvd] (qvd)

     Do you guys have an idea about why do I have this errors? Are you facing the same problem since the 6th december too?

     

    Show Less
  • forum

    New to Qlik Analytics

    Data loading fails for License Monitor app after the upgrade to version Feb 2024

          hello All,   Hello All, Does anyone facing the dataloading issues with license monitor app in qlik sense?    License app error: I/O error   The ... Show More

     

     

     

    hello All,

     

    Hello All,

    Does anyone facing the dataloading issues with license monitor app in qlik sense? 

     

    License app error:

    I/O error
     
    The error occurred here:
    LogContent: NoConcatenate Load * FROM lib://ServerLogFolder/governanceLicenseLog_7.19.0_file.qvd (qvd) WHERE LogTimeStamp >= '2023-04-23'
     
     
    Thanks
    Vamsi
     
     
    Show Less
  • forum

    Deployment & Management

    download QSEoW older versions

    we are in the process of migrate (new hardware) & upgrade a QSEoW Nov 2019 infrastructure.  i need to install QS from scratch with same version into t... Show More

    we are in the process of migrate (new hardware) & upgrade a QSEoW Nov 2019 infrastructure. 

    i need to install QS from scratch with same version into the new provided hardware but Nov 2019 Initial Release setup.exe is not available into download page or Github download page.

    Any direct link or a way to get the Setup for this version?

    Thank you

     

    Show Less
  • forum

    New to Qlik Analytics

    Pivot table with hipen instead 0

    Team, In below table i want to display 0 instead -, how to do, i tried with multiple options including Alt but still no luck. Current expression : if(... Show More

    Team,

    In below table i want to display 0 instead -, how to do, i tried with multiple options including Alt but still no luck.

    Current expression : if(count({<name= $::name,[Doctor State]=$::[Doctor State]>}[Doctor State])> 0,1,0)

    Any suggestions to sort this issue. Thanks in advance

    Farsana_0-1726234502295.png

     

    Show Less
  • forum

    New! Qlik Answers

    QlikView Uograde from MAY 2022 patch to Qlikview May 2024

    Hi Folks, Did any one faced major challenges while upgrading from QlikView May 2022 patch2 to QLIKVIEW MAY 2024.   Kind Regards, Raju
  • forum

    Integration, Extension & APIs

    A simple mashup goes slow

    Greetings, A simple mashup with the most basic template with about 10 records that has 2 graphs and 2 kpis on initial load takes about 10 seconds. It ... Show More

    Greetings,

    A simple mashup with the most basic template with about 10 records that has 2 graphs and 2 kpis on initial load takes about 10 seconds.


    It is running on a central node server with a real two core processor with 4 virtual cores at 2.39 ghz and 32 gb of ram.

    Can it be due to the low specs of the server ?

    Because if not I don't understand why it is hard to load such a simple mashup.

    The server does not have any other service installed and looking at the task manager does not seem to suffer the server on the contrary it goes quite well.


    Is there any kind of configuration to make it work better ?

    Thanks.

    Show Less
  • forum

    App Development

    Previous year sales with Month in Dimension

    Hi, I need to show "Same Month Previous Year" Sales numbers (As shown below in Column E) in a table. The month itself is in the dimension. My current ... Show More

    Hi,

    I need to show "Same Month Previous Year" Sales numbers (As shown below in Column E) in a table. The month itself is in the dimension. My current expressions are:

    Sales: Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales)

    Sales Previous Month: Above (Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales)) 

    Need help with the expression for "Sales Prev Year".  

    BhaskarSharma_0-1726157796376.png

    Appreciate any help!

    Regards,

    Bhaskar

    Show Less
  • forum

    Integration, Extension & APIs

    Field API SelectValues method check if result exist

    I'm using Field API to filter some tables. However if the value I'm filtering doesn't exist it returns all of the results in the table. I want it to s... Show More

    I'm using Field API to filter some tables. However if the value I'm filtering doesn't exist it returns all of the results in the table. I want it to show a message like "no results" or whatever it doesn't matter. How can I achieve this?

     

    app1.field("testFilterID").selectValues(["test"], false);

     

    Show Less
  • forum

    QlikView App Dev

    Load a variable file name

    Hi  I am trying (in vain) to get a dynamic file name loaded. The file is located at  C:\Temp\SEPA\Pending Upload I have a variable vFolder C:\Temp\SEP... Show More

    Hi 

    I am trying (in vain) to get a dynamic file name loaded.

    The file is located at 

    C:\Temp\SEPA\Pending Upload

    I have a variable vFolder C:\Temp\SEPA

    Mu script which worked until we moved servers...

    For Each vFolder in DirList('Pending Upload*')
     
    FOLDER:
    Load
    '$(vFolder)' As Folder
    Autogenerate(1);
     
    For Each vFile in FileList('$(vFolder)\*.xml')
    FILE:
    Load
    '$(vFile)' As File
    Autogenerate(1);
    trace $(vFile);
     
    Templates:
    First 1
     
     
    PmtInf:
    LOAD PmtInfId,
        PmtMtd,
        NbOfTxs,
        CtrlSum,
        ReqdExctnDt,
        PmtInfId & CtrlSum as JNL_KEY,    
        [CdtTrfTxInf/CdtrAcct/Id/IBAN] as [CdtrAcct/Id/IBAN],
        [CdtTrfTxInf/Cdtr/Nm] as [Cdtr/Nm],
        [CdtTrfTxInf/Amt/InstdAmt] as InstdAmt,
        [CdtTrfTxInf/Amt/InstdAmt/Ccy] as Ccy,
        [CdtTrfTxInf/PmtId/EndToEndId] as EndToEndId,
        [DbtrAgt/FinInstnId/Othr/Id] as [FinInstnId/Othr/Id],
        [DbtrAcct/Id/IBAN],
        [Dbtr/Nm],
        %Key_Document_5537B40932C780D8,    // Key to parent table: Document
        '$(vFile)' as Key
    FROM $(vFile) (XmlSimple, Table is [Document/CstmrCdtTrfInitn/PmtInf]);

     

    The load appears to do nothing.so obviously I have something wrong. Any thoughts or suggestions would be appreciated.

    Thanks

     

    Rob

     

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!