Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,950 members
  • 6,993 online
  • 1,997,585 posts
  • 149,756 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Impact on SourceDB side when CDC using LogMiner is executed

    Impact on SourceDB side when CDC using LogMiner is executed I would like to check how much load CDC using LogMiner is putting on SourceDB.Please tell ... Show More

    Impact on SourceDB side when CDC using LogMiner is executed

    I would like to check how much load CDC using LogMiner is putting on SourceDB.
    Please tell us about the impact of LogMiner on the performance of Oracle (SourceDB) CPU/IO, etc.

    Best regards,
    Hironori Fujihira

    Show Less
  • forum

    Deployment & Management

    Qlik Sense Upgrade Failed at ServiceDispatcher Step

    Hi, Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on prod... Show More

    Hi,

    Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on production servers. We had to restore production servers with backed up AMI. Now we are investigating the reason why it failed. We have realized that we made a mistake when upgrading QS production which has two nodes: We stopped services on both nodes and then ran installation on two nodes at the same time. We know it is incorrect. But why did it cause problem? I am writing a report and need to gather deeper information.

    Based on installation log files, I can tell the failure occurred at ServiceDispatcher step. Error occurred when it tried to create schema 'qlik_notifier_service'. I checked the log file for the successful installation on DEV server. When it tried to create schema 'qlik_notifier_service' there, it skipped this step because "Schema 'qlik_notifier_service' already exists" (the sentence in log). Why did the installation not skip it during production installation?

    The attached ServiceDispatcher_installation_logs.txt contains related content from log files.

    We need to make sure there is nothing else which caused installation failure. Please advise.

    Thanks

    Show Less
  • forum

    Qlik Reporting Service

    Creating a Measure from a Dimension

    I have a dimension that I created called Proposed Bucket. Here is my if statement: =If(Excp_Category='6-Attempted','2-CUSTOMER ACTION', if(Excp_Categ... Show More

    I have a dimension that I created called Proposed Bucket.

    Here is my if statement:

    =If(Excp_Category='6-Attempted','2-CUSTOMER ACTION',
    if(Excp_Category = '1-Manifest','5-APPLE ACTION',
        If(Excp_Category='5-Out for Delivery','3-OUT FOR DELIVERY',
        if(Current_Scan_Activity_Record_Type='Out For Delivery','3-OUT FOR DELIVERY',
        IF(Excp_Category='7-Delivery','1-DELIVERED', [Exception_Resolution_Proposed_Bucket])))))
     

    I want to create a measure that adds up certain elements of this proposed bucket. 

    Show Less
  • forum

    New to Qlik Analytics

    Pop Up Dialog box for Qlik Cloud

    Hi All, I am trying this popup extension in QlikSense Cloud but not able to load Error is Cannot Be Processed https://developer.qlik.com/garden/5ddcd5... Show More

    Hi All,

    I am trying this popup extension in QlikSense Cloud but not able to load Error is Cannot Be Processed

    https://developer.qlik.com/garden/5ddcd57cf62b220018fd28dc

    Please suggest possible solutions or other extensions which work in Qlik Cloud.

     

    Regards

    Show Less
  • forum

    Qlik Replicate

    repctl checkpoint "task name" for downstream task (source: log stream task & tar...

    repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp.    D:\bin>repc... Show More

    repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp. 

     

    D:\bin>repctl getcheckpoint "TASK_INGCDC_02"

    command getcheckpoint response:

    {

            "checkpoint":   "checkpoint:V1#33512#1271;638506460899807820;20240120221751514712#0#0#*#0#137"

    }

    [getcheckpoint command] Succeeded

    Regards

    Dipankar

     

    Show Less
  • forum

    App Development

    Show all Value from a Pivot Table even if a cell is selected

    Hello,   i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell. What must I do to... Show More

    Hello,

     

    i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell.

    What must I do to be able to select a cell and in the same time show all the pivot table and the value.

     

    thanks for helping

    Show Less
  • forum

    New to Qlik Analytics

    Calculate the month to date value

    Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that cal... Show More

    Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that calculates the month to date quantity. 

    I am attaching an Excel file that has those 2 columns and also the column of the MTD that I need to calculate as a master item

    Can you please Help ?. Thanks

     

    Show Less
  • forum

    App Development

    Fuzzy Matching with Variable Input Field

    I have an application that is essentially a flat table. The columns are name, user_id, company, city, state. I want users to be able to input a list o... Show More

    I have an application that is essentially a flat table. The columns are name, user_id, company, city, state. I want users to be able to input a list of names in the variable input and then fuzzy match those names with the names in my data set. I believe there isnt an actual tool but would love a creative way someone solved this problem

    Show Less
  • forum

    App Development

    Embedded charts in Mashup shows no data but title & placeholder is visible

    Hi Mashup experts,I am working on responsive mashup with expandable sidebar feature to show/hide charts on button selection (each button selection sho... Show More

    Hi Mashup experts,

    I am working on responsive mashup with expandable sidebar feature to show/hide charts on button selection (each button selection shows respective charts). When the page is loaded first time it shows all the charts (lets say all the charts from button A and all the charts from button B). If page is loaded/reloaded and then I select any button then show hide functionality works fine. 

    To solve this issue I have used different Javascript ways to show only charts for Home button (lets say button A) whenever page is loaded/reloaded. BUT EACH WAY RESULTS SAME, When I select button B, I see the QLIK SENSE CHART TITLE  WITH PLACEHOLDER BUT NOT THE QLIK SENSE CHART (for button B only, button A charts are shown properly).

    Note: 1. I am calling javascript function on button selection using onclick events.

                 2. Issue is only with qlik sense charts not with html elements like <img> tags works fine.

    I have tried to check this issue online but no positive. I hope it will be answered here.

    please check once and let me know for any related inputs/solution.

    Edit:

    Update:  one more point to share, even when I change the % zoom size to any other value OR minimize screen, charts start showing data also for button B charts otherwise they show a charts title and placeholder only.

            

    Show Less
  • forum

    New to Qlik Analytics

    Qlik PostgreSQL Installer doesn't detect database

    Hi, I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the Po... Show More

    Hi,

    I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the PostgreSQL 9.6 database. So I want to use the Qlik PostgreSQL Installer to upgrade and unbundle the PostgreSQL database.

    I stopped all Qlik services except the Qlik Sense Repository Database. Then I start the QPI tool and at the first screen it displays 'No supported existing Qlik Sense PostgreSQL database found. This program will install a new PostgreSQL v14.8 database".

    Why doesn't this QPI tool detect my existing database?

    When I press next and fill out all fields, field 'database port' becomes red with message 'Database port already used by an external service in the system'. Port 4432 is used by the postgres.exe so then it detects?!

    I have attached the pg_hba.conf and the postgresql.conf from folder "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6". Files are renamed with .txt to be able to upload.

    Also I have tried to change the 'listen_addresses' line to 'listen_addresses = '*' without any luck.

     

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