Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 225,623 members
  • 4,983 online
  • 2,007,548 posts
  • 150,611 Solutions
Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Reporting Service

    Tabular Reporting - On-demand - now available

    Since releasing Qlik Cloud Tabular Reporting in late 2023 a common Qlik Community question has been - what about On-demand reporting?  The wait is ove... Show More

    Since releasing Qlik Cloud Tabular Reporting in late 2023 a common Qlik Community question has been - what about On-demand reporting? 

    The wait is over - integrated into the native navigation flow, report developers can now make report templates available for users in app.  See:

    Now users can use their own selections to immediately download a tabular report that has been made available in app.   

    Show Less
  • forum

    Qlik Replicate

    Is it possible to disable foreign key checks using MySQL as target endpoint

    I am replicating from MySQL source into MySQL 8.0 target endpoint. We have to disable foreign_key_checks=0 at target to avoid FK related issues during... Show More

    I am replicating from MySQL source into MySQL 8.0 target endpoint.

    We have to disable foreign_key_checks=0 at target to avoid FK related issues during CDC. Is there a fix where we can workaround this? Otherwise is there an option or parameter we could set at Qlik replicate so that we can disable the foreign_key_checks?


    I am using the target endpoint as a replica server for MySQL.

    Thank you.
    Desmond

    Show Less
  • forum

    Deployment & Management

    Upgrading to Qlik Sense Enterprise May 2024 SR3

    Hi all, I was recently upgrading from November 2023 SR8 to May 2024 SR3 version. I am doing this in our Dev/Test environment to prepare for Production... Show More

    Hi all,

    I was recently upgrading from November 2023 SR8 to May 2024 SR3 version. I am doing this in our Dev/Test environment to prepare for Production implementation.

    I completed the May 2024 IR install and my enterprise environment/apps/etc. were running great. 

    Then I installed Patch 3 and none of my visualizations showed up. They were all showing like this:

    Jaden_0-1721333463199.png

     

    I restarted the box that Qlik Sense ran on and everything was fixed. I wanted to make sure this wasn't just a coincidence, so I reverted to my backup and tried again. The same thing happened so I left it for about 2 hours. When I checked back, all of my visualizations were back and everything looked normal. I am going to let this run for a few days to see what happens.

    Does anyone have any insight on this? It just seems weird that every single visualization is invalid.

    Thanks in advance.

    Show Less
  • forum

    Qlik Application Automation

    Loops and Number of Runs

    Hello guys! If I am looping over a List Values of Field, and manually pressed run on the Qlik Application Automation, is the number of runs equivalent... Show More

    Hello guys! If I am looping over a List Values of Field, and manually pressed run on the Qlik Application Automation, is the number of runs equivalent to the number of items in the field? 

    My main question is: what counts as a run in Qlik Application Automation?

    Show Less
  • forum

    New to Qlik Analytics

    Get Max of Period

    Hi  I'm new Qlik and developing dashboard and i'm stuck with below task I have dimension called period consists values (FY22, FY23, 1H22, 1H23) and wa... Show More

    Hi 

    I'm new Qlik and developing dashboard and i'm stuck with below task

    I have dimension called period consists values (FY22, FY23, 1H22, 1H23) and want to take max of period column value. 

    The desired output should be FY23

    Is there a way to achieve this in Qlik sense

     

    Show Less
  • forum

    Administering and Monitoring

    TAC 8.0.1 - Not able to download task execution logs

    Hello All, Recently I moved to TAC8 and the deploy is done via script in bulk mode.Everything was fine.The jobs were triggered externally by an orches... Show More

    Hello All,

    Recently I moved to TAC8 and the deploy is done via script in bulk mode.
    Everything was fine.
    The jobs were triggered externally by an orchestration tool. When I tried to download the log (Job Conductor > Display last execution details > download entire log ) I faced two weird behaviors:


    1. As shown in the image below, there was already a last run time and when I tried to display last execution details I got the message "Task has not been executed yet) which is not the case.

    IPF_0-1721404392853.png

    2. As shown in the image below, there was also a scheduled run and I was able to access the execution details but I was not able to download the log file as it was disabled.

    IPF_1-1721404897619.png

    I noticed that I have to run the jobs manually at least once in order to be able to access the execution details and download the log file.

    Am I missing something here? (As it would not be a good idea to run all migrated jobs manually)
    Any help would be appreciated. 

    BR.

    Show Less
  • forum

    New to Qlik Analytics

    Qlik Sense Desktop white page when loggin in

    Hi all,I installed the QS Feb 2022 version my colleagues are using, while for them it's working normally, the first time I installed the application a... Show More

    Hi all,

    I installed the QS Feb 2022 version my colleagues are using, while for them it's working normally, the first time I installed the application and logged in it asked me to update the version.

    I updated the version, now when I open the app and click (1) on "the connection"  it goes to an empty page (2) where I have no more actions:

    (1)Manuel93_0-1721404180091.png

    (2) Manuel93_2-1721404228816.png

    I also tried to access it via browser using "http://localhost:4848/hub/my/work"

    and asks me to update the version (done multiple times):

    Manuel93_3-1721404446580.png

    I already un-installed and tried again but it doesn't work. I have no special settings and used QS on my PC 2 years ago without problems. 

     

    Any kind of support is appreciated

    THX 


    Manuel

     

     

    Show Less
  • forum

    Qlik Application Automation

    How to get an e-mail adress of a user invoking an automation

    Hello everyone, I would like to link an automation, creating a report and sending it to an e-mail address to an app. By invoking the automation, the c... Show More

    Hello everyone,

    I would like to link an automation, creating a report and sending it to an e-mail address to an app.

    By invoking the automation, the current users mail address should be retrieved and inserted as receiving address in the Send mail block.

    Is that possible? I'm having trouble to find something about this for Qlik Enterprise SaaS.

     

    Thanks for you response.

    Show Less
  • forum

    New to Qlik Analytics

    Crosstable Dates disappear

    Hi,  I have an existing Dates table and I also have some data from an excel file that contains dates which im trying to align with my main dates table... Show More

    Hi, 

    I have an existing Dates table and I also have some data from an excel file that contains dates which im trying to align with my main dates table to interact dynamically and pull the right data for the required dates. 

    The date field in my main Dates table is called DatesTrans - when i look at my model both tables are joined by the DatesTrans but i dont see any dates in the Data table - Example below:

    BlockID, DatesTrans, Blocks

    101             -                  2

    103             -                  5

    tmpdata:
    Crosstable (Date, Block,1)
    LOAD
    *
    FROM XYZ
    ;

    Data:
    NoConcatenate
    LOAD

    BlockID, 
    date(num#(Date)) AS DateTrans,
    Blocks
    Resident tmpdata;
    Drop Table tmpdata;
    Exit Script;

    I'm not sure if it has anything to do with the fact that the DateTrans field in my Dates table is an Interger in the DW formatted as 20240131. This is the main field used across all tables/reporting.

     

     

    Show Less
  • forum

    QlikView Administration

    Connection name in task log

    Hi!Is the any way to log connection name instead of asterisks?Now in the logs I seeOLEDB CONNECT TO *** (XPassword is ***)
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!