Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,394 members
  • 6,269 online
  • 1,998,278 posts
  • 149,822 Solutions
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    any better to fetch Qlik task log from replicate server ?

    we are working on building some solution around qlik task log. We want to analyze qlik task log at some interval and parse all qlik task log. Parse lo... Show More

    we are working on building some solution around qlik task log. We want to analyze qlik task log at some interval and parse all qlik task log. Parse log and if there's any failure or warning, we want to highlight on dashboard that will be built on some other tools.

    Is there way we can fetch from replicate server (window server), do parsing ?

    Show Less
  • forum

    Qlik Replicate

    Create new tasks using QEM Python API

    Hi team, using QEM's Python API is it possible to create new task using a previous task's export file. I want to create 10 tasks using a previous task... Show More

    Hi team,

    using QEM's Python API is it possible to create new task using a previous task's export file. I want to create 10 tasks using a previous task's export file. I want to know if there is any function called create_task() or someway using which I can create task using python.

    Show Less
  • forum

    Featured Members

    Qlik sense connect snowflake

    hello everyone, An error occurred when I was creating a snowflake connection : "Connections are only allowed to *.snowflakecomputing.com hosts. " . It... Show More

    hello everyone,

    An error occurred when I was creating a snowflake connection : "Connections are only allowed to *.snowflakecomputing.com hosts. " .

    It seems that the official snowflake driver does not support ".cn" ending hosts.

    How can I avoid this problem? Do I need to modify the driver configuration file?

    Show Less
  • forum

    Qlik Replicate

    Requirement of NW direction

    Hi Team I'd like to know the requirements of network direction (e.g. from the source to Qlik, or bidirectional flow) between the source and Qlik Repli... Show More

    Hi Team

    I'd like to know the requirements of network direction (e.g. from the source to Qlik, or bidirectional flow) between the source and Qlik Replicate and also the target and Qlik Replicate to configure the firewall rule between them, but I couldn't find any information about it. Could anyone let me know what kind of traffic flow should be necessary for the source and the target?  

    Thank you

    Show Less
  • forum

    Alerting

    Question about to Qlik Alerting

    1.where are alerts stored in DB when alert gets triggered from Qlik alerting tool? 2.if stored can we integrate in SQL DB?
  • forum

    New to Qlik Analytics

    Custom Visualization

    Hi Team, Could please confirm, if we could develop( exactly like the same) the below view using Qlik sense or not?? Its little urgent as we need to pr... Show More

    Hi Team,

    Could please confirm, if we could develop( exactly like the same) the below view using Qlik sense or not??

    Its little urgent as we need to propose the view, Please respond ASAP.

    amala2020_0-1715666991742.png

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Load data from excel from specific rows

    Hi There I want to load the excel data from specific rows, however i am getting an error stating not able to find the column names. At the moment i am... Show More

    Hi There I want to load the excel data from specific rows, however i am getting an error stating not able to find the column names. At the moment i am using the below code to read the file. Appreciate your help.

    custodian_list:
    Load
    "col 1" AS "column1",
    "col 2" AS "column2",

    "col 3" AS "column3",

    "col 4" AS "column4",

    "col 5" AS "column5",

    "col 6" AS "column6",

    "col 7" AS "column7",


    FROM excelsheet.xlsx', ooxml, embedded labels, table is [CUSTODIAN LIST])
    where RecNo()>=5
    ;
    exit Script;

    The error i am getting is 

    The following error occurred:
    Field 'col 1' not found. 
    If i use as Load * it is not recognising the col 1 at all and it read from second column.

    I have uploaded the dummy file here.
    Show Less
  • forum

    App Development

    Can I use the new version of the visualization bundle without a QS upgrade?

    Hi, I'm using the November 2023 version of QS.And I want to use the February 2024 version visualization bundle without a QS upgrade.Is it possible?
  • forum

    Qlik Cloud Data Integration

    Synced users not able to authenticate

    I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached) and successfully synced then using user directory connector ,  But... Show More

    I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached)
    and successfully synced then using user directory connector , 

    But these synced users are failing to authenticate / login to Qlik hub and  QMC

     

    Tried different ways to resolve this , - 

    1. allocated license to user (Analyser and Professional)
    2.  allocated the role (root admin)
    3.  tried to check/uncheck "Sync user data for existing users" option
    4. create and modify security rules and license allocation rules.

     

    But nothing worked, please help if anyone can provide suggestions 

     

    Show Less
  • forum

    New to Qlik Analytics

    Calculating Current and Previous Month Sales in Pivot Table

    @Dataintellinalytics I am trying to create a pivot table that shows "Current Sales" and "Previous Month Sales" for each "month year"  Data: SalesDa... Show More

    @Dataintellinalytics 

    I am trying to create a pivot table that shows "Current Sales" and "Previous Month Sales" for each "month year" 

    Data:

    SalesDate Product Amount
    10/1/2023 Chair 50
    15/1/2023 Fan 100
    24/2/2023 Chair 82
    23/2/2023 Fan 72
    14/3/2023 Chair 132
    13/3/2023 Fan 56
    10/1/2024 Chair 50
    15/1/2024 Fan 100
    24/2/2024 Chair 82
    23/2/2024 Fan 72
    14/3/2024 Chair 132
    13/3/2024 Fan 56

     

    Expected outcome in Pivot Table

    Product Jan-23 Feb-23 Mar-23 Jan-24 Feb-24 Mar-24
    Current Month Previous Month Current Month Previous Month Current Month Previous Month Current Month Previous Month Current Month Previous Month Current Month Previous Month
    Chair 50 0 82 50 132 82 50 0 82 50 132 82
    Fan 100 0 72 100 56 72 100 0 72 100 56 72


    Hope you can help me to solve this requirement 🙂 

    Thank you very much for your assistance!

    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!