Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 241,114 members
  • 2,215 online
  • 2,023,867 posts
  • 152,205 Solutions
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Welcome to Qlik Community

Recent Discussions

  • forum

    Deployment & Management

    Log file not getting archieved

    Due to some reason in recent months we are getting alot of error entries in C:\ProgramData\Qlik\Sense\Log\AppDistributionService\Trace which increased... Show More

    Due to some reason in recent months we are getting alot of error entries in C:\ProgramData\Qlik\Sense\Log\AppDistributionService\Trace which increased the size and count of the log file and also these log files are not getting archieved to our D drive causing storage issues in C drive.


    what is causing this error and why is it the log is not getting archived ?


    error content is given below
    # Timestamp LogLevel MachineName Thread ThreadId ServiceUser Message Exception ProcessId TransactionId DeploymentId
    12610 20250118T000025.736+09:00 WARN HQLIK01 83 HQLIK01\manager01 Could not "POST" on "https://localhost:4242/qrs/log/rolled/AppDistributionService?xrfkey=ichbineinberlinR" - Response code: "Forbidden" Reason phrase: "Forbidden" 2912
    12611 20250118T000025.738+09:00 ERROR HQLIK01 83 HQLIK01\manager01 Exception caught sending request to : "https://localhost:4242/qrs/log/rolled/AppDistributionService?xrfkey=ichbineinberlinR" Message: "Response status code does not indicate success: 403 (Forbidden)." System.Net.Http.HttpRequestException: Response status code does not indicate success: 403 (Forbidden).↵↓ at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()↵↓ at AppDistributionService.Model.WorkflowExceptionStrategy.ThrowException(HttpResponseMessage response)↵↓ at AppDistributionService.Sense.QrsRestClient.HandleHttpResponse(Func`1 clientCall, String uri, HttpStatusCode[] ignoreExceptions) 2912
    12612 20250118T000025.740+09:00 ERROR HQLIK01 83 HQLIK01\manager01 Cannot rotate file. Response status code does not indicate success: 403 (Forbidden). System.Net.Http.HttpRequestException: Response status code does not indicate success: 403 (Forbidden).↵↓ at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()↵↓ at AppDistributionService.Model.WorkflowExceptionStrategy.ThrowException(HttpResponseMessage response)↵↓ at AppDistributionService.Sense.QrsRestClient.HandleHttpResponse(Func`1 clientCall, String uri, HttpStatusCode[] ignoreExceptions)↵↓ at AppDistributionService.Sense.QrsRestClient.ArchiveLogs(String[] fileNames)↵↓ at AppDistributionService.Configurations.LogsRotationService.ExecuteAsync(CancellationToken stoppingToken) 2912
    12613 20250118T000025.835+09:00 WARN HQLIK01 83 HQLIK01\manager01 Could not "POST" on "https://localhost:4242/qrs/log/rolled/AppDistributionService?xrfkey=ichbineinberlinR" - Response code: "Forbidden" Reason phrase: "Forbidden" 2912

    Show Less
  • forum

    Qlik Replicate

    Is there a tuning guide for Azure Synapse target?

    Hi, I'm wondering if there is a similar PDF guide for tuning to an Azure Synapse target as there is for the Databricks guide that I found online (atta... Show More

    Hi,

    I'm wondering if there is a similar PDF guide for tuning to an Azure Synapse target as there is for the Databricks guide that I found online (attached)

    Regards,

    Mohammed

    Show Less
  • forum

    Qlik Cloud Data Integration

    Application performance

    hello guys.  i'm just wondering how do you guys deal with large datasets that require multiple aggregations and treatements cause for me the loading t... Show More

    hello guys. 

    i'm just wondering how do you guys deal with large datasets that require multiple aggregations and treatements cause for me the loading time takes forever and sometimes fails to complete and using the application becomes quite laggy i tried to resort to making views for the aggregations and import them but the more i make the slower app becomes for example: 
    Marque_Tom:
    LOAD
    [Marques],
    Q35_DES,
    Marques_TOM;
    SELECT
    Q35 as Marques,
    Q35_DES,
    Count(Q35) as Marques_TOM
    FROM DataShare.dbo.FAIT_Q35
    Group By Q35_DES,Q35;
    became like this 
    [Marque_TOM]:
    SELECT Marque,
    Vague,
    Code,
    "Marques_TOM"
    FROM "Market_Study".dbo."Marque_TOM";

    it's just an example i removed aggregations from the data loading part and yes if it was this alone it would not be a problem but i have plenty more and it made it very slow cause it keeps creating correspondence keys  and basically impossible to use i hope you help me 

    Show Less
  • forum

    Qlik Replicate

    What exactly does Timestamp represent in a message created by Qlik Replicate?

    Hi, I'm looking at the documentation for Amazon Kinesis and I am confused as to what exactly this timestamp represents. My assumption is that it repre... Show More

    Hi,

    I'm looking at the documentation for Amazon Kinesis and I am confused as to what exactly this timestamp represents. My assumption is that it represents the time at which the change occurred on the source database. Is this correct?

    MoeyE_0-1736740619670.png

    Furthermore, can someone please help me understand the ChangeSequence field. Is this field only created by Qlik Replicate for each change that the task needs to apply? If I was to replay changes by timestamp, would they have the same change sequence or would it change?

    MoeyE_0-1736743542337.png

    Regards,

    Mohammed

    Show Less
  • forum

    App Development

    Qlik sense Business analyst certification

    Hello All,   I'm planning to pass the QSBA certification. However, I found a simulator on the Qlik site with only 10 questions. Do you have any idea w... Show More

    Hello All,

     

    I'm planning to pass the QSBA certification. However, I found a simulator on the Qlik site with only 10 questions. Do you have any idea where I can find good test exam examples with recent topics and questions? Any tips or guidance to help orient my preparation would be greatly appreciated.

    Is there any questions about Qlik Cloud SAAS ?

     

    Thank you in advance.

    #QSBA #QLIKSENSE #Certification

    Show Less
  • forum

    Qlik Reporting Service

    PixelPerfect reporting and beyond!

    With the turn of the calendar, it's a great time to recap the exciting reporting updates from 2024 and look forward to 2025 and the continued expansio... Show More

    With the turn of the calendar, it's a great time to recap the exciting reporting updates from 2024 and look forward to 2025 and the continued expansion of reporting capabilities on Qlik Cloud Analytics.  

    We packed 2024 with enhancements in reporting capabilities, featuring sought-after additions to both enterprise reporting and interactive distributions.  

    Quick recap: 

    • Dynamic Subscriptions: Subscriptions can now utilize dynamic expressions, and users can preview them. You can perform an ad hoc multi-sheet download, and if you like it, you can schedule it for future delivery. 
    • On-Demand Reports: Report developers can make Tabular or PixelPerfect reports available on-demand within an app, allowing users to set their selections and download reports immediately.  
    • Cycling Feature: Developers have increased control with the addition of cycling (repeating a report per dimension) within task configurations. 
    • Task History: Developers can now see up to 90 days of report task execution history. 
    • PDF Output: PDF output for Tabular reporting has been introduced. 
    • Integrated PixelPerfect Editor: An in-app integrated PixelPerfect report editor is now available, enabling users to create visually stunning, highly customized reports with pixel-level precision. Reminder - Developers can enhance their editing skills through a free e-learning module. 
       

    For details on the 2024 releases, check out the "What's New" section and filter on Analytics > Reporting and Alerting. 

    Reporting from Qlik Cloud Analytics on the help site should be your starting point for understanding the power and flexibility of reporting on Qlik Cloud Analytics.  Take the time to review it in detail, it is very comprehensive!

     

    Looking ahead to 2025* 

    Work is already underway on some exciting capabilities: 

    • New Report Authoring Tools: In addition to PixelPerfect, an embedded in-app HTML editor is in development to support authoring of HTML report templates. These templates can serve as the email body for task distributions when using the email channel; HTML attachments will also be supported. 
    • Multi-Template Distribution: The report task will expand to allow multi-template report distribution. Developers will manage tasks that include HTML report bodies and attachments for Tabular, PixelPerfect, and HTML templates. 
    • Enhanced Reporting Guardrails: We will also expand some of our reporting guardrails in line with customer reporting growth. 
    • New Straight Table - download column totals: The new straight table is getting a boost with some ad hoc download controls including the inclusion of column totals.  
       

    We are also investigating other areas of customer feedback, such as dynamic filter import, and dynamic filename definition. Please continue sharing your ideas on our community ideation portal - the status of reporting topics in ideation is up to date as of this post.  Stay tuned and start planning for Qlik Connect!!! 

     

    *Disclaimer: This post includes Qlik® roadmaps statements to provide a general overview of our anticipated product direction as of the date hereof. Qlik undertakes no intention or obligation to update or revise any forward-looking statements contained herein, whether as a result of new information, future events or otherwise.  

    Show Less
  • forum

    New to Qlik Analytics

    Date filter selections based on Measure

    Hi Everyone, I have a requirement, Can you please help me with the same, I have a data as shown below here,    Below is the pivot table, I have create... Show More

    Hi Everyone,

    I have a requirement, Can you please help me with the same,

    I have a data as shown below here, 

     

    Below is the pivot table, I have created, Cost as a category and year with the sum of data, the requirement here is  based on the selection in single measure only has to be filtered

    Dimension1 Dim2 Capex Cost Running Cost Operation Cost
        2024 2025 2026 2027 2028 2024 2025 2026 2027 2028 2024 2025 2026 2027 2028
    abc bcd 0 12 23 34 0 0 0 0 0 0 5 17 28 39 50
    ZXC cve 0 13 24 35 0 0 0 0 0 0 5 18 29 40 51
    wes qws 0 14 25 36 0 0 0 0 0 0 5 19 30 41 52
    tvs xsz 0 15 26 37 0 0 0 0 0 0 5 20 31 42 53
    tre dfv 0 16 27 38 0 0 0 0 0 0 5 21 32 43 54

     

     

    For example if a user has selected 2024 in Capex cost only 2024 for capex has to be filtered and remaining should be as is the output should be as shown below

    Dimension1 Dim2 Capex Cost Running Cost Operation Cost
        2024 2024 2025 2026 2027 2028 2024 2025 2026 2027 2028
    abc bcd 0 0 0 0 0 0 5 17 28 39 50
    ZXC cve 0 0 0 0 0 0 5 18 29 40 51
    wes qws 0 0 0 0 0 0 5 19 30 41 52
    tvs xsz 0 0 0 0 0 0 5 20 31 42 53
    tre dfv 0 0 0 0 0 0 5 21 32 43 54

     

    if a user has selected 2024 in Capex cost, 2024,2025,2026 in running cost the output should be as shown below

    Dimension1 Dim2 Capex Cost Running Cost Operation Cost
        2024 2024 2025 2026 2024 2025 2026 2027 2028
    abc bcd 0 0 0 0 5 17 28 39 50
    ZXC cve 0 0 0 0 5 18 29 40 51
    wes qws 0 0 0 0 5 19 30 41 52
    tvs xsz 0 0 0 0 5 20 31 42 53
    tre dfv 0 0 0 0 5 21 32 43 54

     

    if a user has selected 2024,2028 in Capex cost, 2024,2025,2026 in Running cost the output should be as shown  and 2027,2028 in Operation cost the output should be as shown below

    Dimension1 Dim2 Capex Cost Running Cost Operation Cost
        2024 2028 2024 2025 2026 2027 2028
    abc bcd 0 0 0 0 0 39 50
    ZXC cve 0 0 0 0 0 40 51
    wes qws 0 0 0 0 0 41 52
    tvs xsz 0 0 0 0 0 42 53
    tre dfv 0 0 0 0 0 43 54

     

    based on the selection in that particular year the data has to be filtered for that particular category,

    can you please help me with this requirement, Appreciate your help

    thanks in advance, Even alternate states works

    Show Less
  • forum

    App Development

    Display each name and latest status by time

    I have a table with these columns: name, category, status, dtime. I want to get latest status for each name from the same category even if I filter sp... Show More

    I have a table with these columns: name, category, status, dtime. I want to get latest status for each name from the same category even if I filter specific dtime and latest name’s status dtime is before filtered dtime. For example name - jack, category - worker, status - available, dtime - 2025-01-19 20:00:00, name - jack, category - worker, status - unavailable , dtime - 2025-01-19 21:00:00, name - mike, category - worker, status - available, dtime - 2025-01-19 20:00:00. So if I filter to 2025-01-19 21:00:00 I want to get name - jack, category - worker, status - unavailable , dtime - 2025-01-19 21:00:00, name - mike, category - worker, status - available, dtime - 2025-01-19 20:00:00

    Show Less
  • forum

    App Development

    rolling 6/4 months in bar /pivot table with multiple or 2 diemsnion

    Hi Team,   PFA  of my sample data and QVF, I want to show the rolling 6 months data as default with monthyear dim and if there is no data for the roll... Show More

    Hi Team,

     

    PFA  of my sample data and QVF, I want to show the rolling 6 months data as default with monthyear dim and if there is no data for the rolling months it has to show zero in the bar chart and  if user select any timeframe monthyear  dim has to be changed accordingly as per the selected timeframe example week or year or date, All these are achieved.

    now the issue is if i add another dim in the chart and disable the include null value , i am not getting the zero value. bar chart has to  show allways rolling 6 bars, if no data then it shd be zero and similarly pivot shd show the rolling 4 months.

    manoranjan_321988_0-1737139703982.png

     

     

    Show Less
  • forum

    Qlik Replicate

    data is not updating correctly using QLIK Replicate

    I exported a job from my old qlik server into my new qlik server. The source is DB AS400 and the target is PostGres.  The data record is not showing u... Show More

    I exported a job from my old qlik server into my new qlik server. The source is DB AS400 and the target is PostGres.  The data record is not showing up correctly. It is showing zero instead of 100. 100 is on the old server. the new server is showing 0. I went through all the configurations for both servers and they are the same. I have enabled verbose on the problem server. 

    Error:

    0004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]T: get_capture_table_list: fetched table XXXX.XXX (db2i_endpoint_imp.c:1369)
    00004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]V: Construct statement execute internal: 'select CARDINALITY from SYSIBM.SQLSTATISTICS where TABLE_SCHEM='XXXX' and TABLE_NAME='XXXX' and TYPE=0' (ar_odbc_stmt.c:4040)
    00004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]T: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3976)

     

    0004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: sqlite_step_ex_stmt: (rc == SQLITE_DONE || rc == SQLITE_ROW) failed (at_sqlite.c:525)
    00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: SQLite general error. Code <19>, Message <UNIQUE constraint failed: load_status.seq_num>. [1000505] (at_sqlite.c:525)
    00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]V: sqlite_step_ex_stmt:525: Failed (at_sqlite.c:545)
    00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: sqlite_do_immediate: rc == SQLITE_DONE failed (at_sqlite.c:990)
    00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: SQLite general error. Code <1>, Message <cannot start a transaction within a transaction>. [1000505] (at_sqlite.c:990)
    00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]V: sqlite_do_immediate:990: Failed (at_sqlite.c:994)

     

    00005956: 2025-01-15T16:43:44:157964 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:2784)
    00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]T: Retrieved system names 'XXXX '.'XXXX ' for 'XXXX'.'XXXX' (db2i_endpoint_util.c:961)
    00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]V: Construct statement execute internal: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:4040)
    00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]T: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3976)
    00005956: 2025-01-15T16:43:44:649307 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:2784)

     

     

    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!