Skip to main content

Welcome to
Qlik Community!

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

Welcome to Qlik Community

Recent Discussions

  • 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
  • forum

    Qlik NPrinting

    Dynamic tables with calculated dimensions,org chart extension objects are not re...

    I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in e... Show More

    I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in excel, objects or tables are not rendering properly ,Do you have any solution?

    Show Less
  • forum

    App Development

    Expression (Average) that calculates based on selected/filtered value as well as...

    Greetings.  I have the below data: Name Gender Class Subject Grade John M A1 Math 5 John M A1 Science 4 John M A1 French 3 John M A1 Misc 2... Show More

    Greetings. 

    I have the below data:

    Name Gender Class Subject Grade
    John M A1 Math 5
    John M A1 Science 4
    John M A1 French 3
    John M A1 Misc 2
    Jane F A1 Math 4
    Jane F A1 Science 5
    Jane F A1 French 3
    Jane F A1 Misc 3
    Joe M A2 Math 4
    Joe M A2 Science 1
    Joe M A2 French 4
    Joe M A2 Misc 2
    Janice F A2 Math 4
    Janice F A2 Science 3
    Janice F A2 French 1
    Janice F A2 Misc 1

     

    I would like to create a Table chart that will display the Average Grade by Person Name. In addition, for that person it will also display the average Grade by gender as well as Class.

    Output chart with Average values is as per below:

      Average Grade Overall average grade by gender Overall average grade by Class
    John 3.5 3.125 3.625
    Jane 3.75 3.000 3.625
    Joe 2.75 3.125 2.500
    Janice 2.25 3.000 2.500

    Eg: Overall average grade by gender will consider John's grade as well as all grades that match his gender. So Overall average grade by gender for John = Average(5, 4, 3, 2, 4, 1, 4, 2) = 3.125

    Further if user selects a name say John, the output should be as per below:

      Average Grade Overall average grade by gender Overall average grade by Class
    John 3.5 3.125 3.625

     

    Thus far, i have not been able to get the correct expression for the last 2 expressions.

    Thank you for your time.

    Show Less
  • forum

    New to Qlik Analytics

    Simplifying a table structure

    I have a spreadsheet to load into Qlik in the following format: Order ID Org1 OrgType1 Amount1 Org2 OrgType2 Amount2 Org3 OrgType3 Amount3 1000... Show More

    I have a spreadsheet to load into Qlik in the following format:

    Order ID Org1 OrgType1 Amount1 Org2 OrgType2 Amount2 Org3 OrgType3 Amount3
    10001 AAA Internal 1000 BBB Internal 300 CCC External 600
    10002 DDD Internal 1500 AAA Internal 200 EEE External 900
    10003 EEE External 800 FFF Internal 700 AAA Internal 1200

    ...and so on.

    But what I really want to work with in Qlik is a table like this:

    Order ID Org OrgType Amount
    10001 AAA Internal 1000
    10001 BBB Internal 300
    10001 CCC External 600
    10002 DDD Internal 1500
    10002 AAA Internal 200
    10002 EEE External 900
    10003 EEE External 800
    10003 FFF Internal 700
    10003 AAA Internal 1200

     

    Can anyone tell me how to get my data into that format?

    Thanks in advance,
    Dan

    Show Less
  • forum

    Integration, Extension & APIs

    Embedded Sheets Qlik on Web Site

    Hello, Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error mess... Show More

    Hello,

    Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error message "connection denied nametenant.eu.qlikcloud.it"

    Is there any setting to set up?

    In practice: I made the sheet public, I took the embedded, I pasted it on my web page www.dominio.it/qlik.html and I pop up the notice described.

    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!