Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 225,930 members
  • 6,180 online
  • 2,007,916 posts
  • 150,646 Solutions
Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Connection String to Mongodb

    Our database team provided the following connection string for connecting to the MongoDB database mongodb://dbhost:27017/Dbase?maxPoolSize=50&appName=... Show More

    Our database team provided the following connection string for connecting to the MongoDB database

    mongodb://dbhost:27017/Dbase?maxPoolSize=50&appName=app1;

    While I am able to establish a connection to the database from Qlik Sense by providing the server details, I am unable to include the appName connection option. They mentioned that this parameter is used to track queries in logs. Is there a way to specify this parameter from Qlik Sense?

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate with target solace PubSub+ Event Broker

    Hi, Its posible use solace PubSub+ Event Broker as a target from Qlik Replicate?   Thanks
  • forum

    App Development

    Load .parquet file in Qlik Sense Enterprise version

    Hello Team, We are using Qlik Sense Nov 2022 enterprise version. We have requirement to load data from .parquet file in load script. May I know what a... Show More

    Hello Team,

    We are using Qlik Sense Nov 2022 enterprise version.

    We have requirement to load data from .parquet file in load script.

    May I know what are the ways we can achieve this?

    Show Less
  • forum

    App Development

    Average not working

    Hello, I am still getting to grips with Qliksense, help is very much appreciated. I want to average a set of data and have it so it shows above the da... Show More

    Hello,

    I am still getting to grips with Qliksense, help is very much appreciated.

    I want to average a set of data and have it so it shows above the data like in the image below:

    Chris_Buck_0-1721740546376.png

     

    I tried the following formula in the measure section, but no luck

    Avg((   
        (24*Count({$}distinct Date)
        -Sum({$<[Excused / Un-Excused]={$(vDTtype)}>}[Downtime Hours])  //   "Un-Excused Downtime","N/A"
        +Sum({1-$<[Downtime Hours]={"*"}>}0))
        /
        (24*Count({$}distinct Date))
     
    ))+ 0.00001
     
     
    Thank you for taking the time to look at this one 
    Show Less
  • forum

    App Development

    How to freeze the title of a sheet

    Hi, How to freeze the title of a sheet, so that it remains visible even when the user scrolls down an extended sheet ?Thanks . Eric
  • forum

    Qlik Replicate

    Replicating Long Object Names exceeding 30 Bytes in Oracle Database

    Hello Experts I have some questions about replicating Long Object Names exceeding 30 Bytes in Oracle Database I've already checked the article below: ... Show More

    Hello Experts


    I have some questions about replicating Long Object Names exceeding 30 Bytes in Oracle Database


    I've already checked the article below:

    https://community.qlik.com/t5/Qlik-Replicate/Limitations-and-considerations-Oracle/td-p/1878009


    However I have some questions regarding the settings and would like to confirm what should I set when we would like to use long object name.

    Questions:

    1. When running LSS Task and Replication Task, do we have to add internal parameter skipValidationLongNames=true to the Oracle source endpoint of not only LSS task, but also Replication task?

    The reason I ask this question is, I noticed that following behavior:

    In v2022.11, it worked fine only by adding the parameter to Oracle source endpoint of LSS task, while in v2023.05, I got the warning message below when running the Replication Task if I didn't add the parameter to the Replication Task.

    Table 'xxxxx' cannot be captured because the name contains 39 bytes (more than 30 bytes)

    Is the behavior of v2023.05 expected and is this an effect of some fixes?

    If some fix changes the behavior, would it be possible to let us know the fix in detail?


    2. As far as I have confirmed in house, if the table name is more than 30 bytes, even if the column name is less than 30 bytes, I thought that ENABLE_GOLDENGATE_REPLICATION=true is required to replicate update statements.
    Is this correct?

    Any advice would be greatly appreciated.

    Regards,

    Kyoko Tajima

     

    Show Less
  • forum

    Security & Governance

    USER CALs and DOCUMENT CALs have disappeared from the System/Licenses/<QLIKVIEW server="">/Assigned </QLIKVIEW>...

    On the "General" TAB, both counts are 0 licenses (of X number) of NAMED CALs     and   0 licenses (of Y number) of DOCUMENT CALs.    How do I get thos... Show More

    On the "General" TAB, both counts are 0 licenses (of X number) of NAMED CALs     and   0 licenses (of Y number) of DOCUMENT CALs.    How do I get those counts correctly reset ??    We tried starting the individual QV services on the server... and then tried a server RESTART. 

     

    Now, after the RESTART, the count of the NAMED CALs is slowly rising; appears to be when someone (who USED to have a NAMED CAL) logs in, the system keeps track on that user.  The DOCUMENT CAL number is NOT increasing now, however...

     

    Show Less
  • forum

    Design and Development

    How to Read Outlook .pst file using tFileInputMail

    Hi AllI am trying to read outlook .pst file using tFileInputMail job but it reads only .msg files not .pst files can any one tell me how to read .pst ... Show More

    Hi All
    I am trying to read outlook .pst file using tFileInputMail job but it reads only .msg files not .pst files
    can any one tell me how to read .pst files with or without attachments

    Show Less
  • forum

    App Development

    Change the total type in expression

    HelloI got a table with 2 dimensions and several expressionsthe expressions got aggregations and they are working well and giving correct resultsthere... Show More

    Hello
    I got a table with 2 dimensions and several expressions
    the expressions got aggregations and they are working well and giving correct results
    there are two options given to the users to show on the chart either the count or the percentage

     
     

    WhatsApp Image 2024-07-23 at 9.55.49 AM.jpeg

    now what is required is that when the user clicks the percentage button, the total should display the average of the results and not the sum but when the count button is selected the total should display the sum

    dbe47fb2-2870-4117-8c75-d5ecee8e693e.jpeg

    I tried to use the dimensionality() and check what the user selected as percentage or count, and added and Avg(my_expression)
    I got an error for nested aggregation not allowed
    is there a way to tackle this issue?

    Show Less
  • forum

    New to Qlik Analytics

    After upgraded to Qlik Sense 2024 Feb, Chrome v79 cannot open app

    Hi,  I have upgraded Qlik Sense server from May 2021 to Feb 2024.  I have a problem,  Chrome version 79 is no longer able to open any app, it shows a ... Show More

    Hi, 

    I have upgraded Qlik Sense server from May 2021 to Feb 2024.  I have a problem,  Chrome version 79 is no longer able to open any app, it shows a blank page. The Hub page is ok. As my company runs some legacy applications that need Chrome v79 browser, I cannot upgrade Chrome to the latest version.

    can anyone tell me how to open the Qlik app with Chrome v79? 

    thanks

    Regards,

    Michael

     

     

    Show Less
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!