Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 225,176 members
  • 5,660 online
  • 2,006,944 posts
  • 150,565 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 Replicate

    Column Filter

    I have a table with more than 500 columns. Since Qlik is limited to only 500 columns per table, is it possible to not load and replicate other columns... Show More

    I have a table with more than 500 columns. Since Qlik is limited to only 500 columns per table, is it possible to not load and replicate other columns in Qlik replicate? I am using Oracle as source and target. 

    Show Less
  • forum

    Qlik Replicate

    Replicate Views as Views not as Tables using Qlik Replicate

    Greetings! I tried to replicate views from the Source SQL Server RDS to Snowflake and what I am seeing is that the Views are replicating as Tables. Ca... Show More

    Greetings!

    I tried to replicate views from the Source SQL Server RDS to Snowflake and what I am seeing is that the Views are replicating as Tables.

    Can anyone suggest how to replicate Views as Views and not as Tables in the Target?

    Thanks!

    Satyender

     

    Show Less
  • forum

    App Development

    how to ignore 1 filter value, but keep other 3 filter?

    I have an app, 1st sheet has 4 filters: year, month, type, department. after I selected filters, sheet 1 will jump to sheet 2 , and keep all the filte... Show More

    I have an app, 1st sheet has 4 filters: year, month, type, department. after I selected filters, sheet 1 will jump to sheet 2 , and keep all the filters. and I want to have a line chart to show the score changes by year. 

    but year has selected at the beginning, so the line chart cannot show the X ray with full year. the other 3 filter must keep, then  I will set avg of score. 

    the question is: how can I skip the year filter, and keep others, calculate the avg with the other 3 filters.

    besides, the ray may be year, may be month, depends on the type filtered. could it be possible to change automatically?

    Show Less
  • forum

    Design and Development

    Move files from Box to a Local Drive

    I need to move files from a Box folder to a local drive. This should be an easy process with 3 components: tBoxv2Connection, tBoxv2List, tBoxv2Get. I ... Show More

    I need to move files from a Box folder to a local drive. This should be an easy process with 3 components: tBoxv2Connection, tBoxv2List, tBoxv2Get. I created the integration with configurations to match the components in this example https://help.talend.com/en-US/components/8.0/box/tboxconnection-tboxput-tboxget-configuring-components-standard-component 

    I can run the connection and list to return a list of files in the box folder. I've tried the Get component using the folder path in box or the box file ID. I'm simply dropping the file in "C:/Test".  

    I finally broke down and simply hardcoded the file paths in both fields of the Get component and got this error message: "org.talend.components.box.get.BoxGet- A problem occurred during reading data from Box"

    Any idea what is causing this issue?

     

    Show Less
  • forum

    Integration, Extension & APIs

    SnowSQL in Qlik Sense Enterprise

    I would like to use SnowSQL to put data in a Snowflake stage using Qlik Sense Execute. I have made a script that works in command line from my server,... Show More

    I would like to use SnowSQL to put data in a Snowflake stage using Qlik Sense Execute. I have made a script that works in command line from my server, but when i run it via Execute in a Qlik Sense App's script, the load gets hung. I've come up with a simple example that should be working, but is getting hung. Does anyone have any ideas?

    Here is the simple example with and without double quotes that wont work:

    Execute cmd c/ snowsql -v > d:/output_file.csv;

    Execute cmd c/ "snowsql -v > d:/output_file.csv";

    Here is an example of the PUT command that is also not working:

    snowsql -c my_connection -q "PUT 'file:////fileshare path/data.csv' @snowflake_DB.SNOWFLAKE.SNOWFLAKE_STAGE OVERWRITE = TRUE"

    Please let me know if you've accompished this and have any ideas why its not working.

    Show Less
  • forum

    Qlik Application Automation

    Qlik Sense On Demand App Generation load progress error

    Hello!  I'm getting an error when hitting the generate new app button using the navigation link.  I have the detail template app created, and the sele... Show More

    Hello!  I'm getting an error when hitting the generate new app button using the navigation link.  I have the detail template app created, and the selection high level app created, with the navigation link set up, it's generating the template app but not recognizing the selections made and also throws an error " Reload error : (Connector error:  ERROR [42000] SQL Compilation error:  syntax error line 61 at position 0 unexpected 'AND'.).

    I know it has something to do with my sql in the detail template app but am having no luck fixing it.  Attached is a document with screenshots of everything.  I'm sooooo close to getting this working, please help!  I truly appreciate it.  Thank you in advance!

     

    Show Less
  • forum

    Deployment & Management

    Qlik Audit API for Sheet Usage

    Our team was happy to see recently that Qlik exposed a new Audit API event to reflect user views of individual sheets.  This theoretically gives us th... Show More

    Our team was happy to see recently that Qlik exposed a new Audit API event to reflect user views of individual sheets.  This theoretically gives us the ability track the usage across all our reports to understand user adoption of our BI offerings.  Despite this, we are encountering several problems operationalizing this Audit API event to a useful level.  Our end goal is to have data in a form that lists how many times a sheet was viewed over a period of time along with related dimensions such as app, space, user name, and any other insightful info available. 

    We experimented briefly with adapting the existing community monitoring apps to try and add this Audit event but have little experience with the level of scripting required.  The ideal solution would be a Qlik app like these monitoring apps that would allow us to pull data through a REST connection, store it in QVD form and then aggregate sheet usage events by user/app/timeframe/etc.  

    We are also able to reach this info through the Qlik-CLI, but are apprehensive to start building infrastructure to automate and store this data without exploring other options.

    Has anyone experimented with possible tools/Qlik apps/automations to leverage this new API event?  Does the Qlik product team have plans to release any native functionality to make this data more accessible?

    Any input or suggestions are appreciated!

     

     

    Show Less
  • forum

    Integration, Extension & APIs

    Qlik Cloud Advanced Analytics Connector for invoking Snowpark ML models?...

    Greetings! Does Qlik plan to develop the equivalent of an Advanced Analytics Connector for Qlik Cloud that could be used to invoke ML models deployed ... Show More

    Greetings!

    Does Qlik plan to develop the equivalent of an Advanced Analytics Connector for Qlik Cloud that could be used to invoke ML models deployed in Snowpark ML???

    Cheers,

    ++José

    Show Less
  • forum

    Qlik Application Automation

    Use Data from Sheet in a Condition Loop

    Hi guys. I have a question regarding Qlik Application Automation. I have a sheet that contains a table of two columns, "Name" and "CampaignName". I al... Show More

    Hi guys. I have a question regarding Qlik Application Automation. I have a sheet that contains a table of two columns, "Name" and "CampaignName". I also have a filter button to filter out "Name". If you filter for one "Name", the table updates to five "CampaignNames". Is there a way to use the data found in a sheet inside a condition loop on Qlik Application Automation?

    Show Less
  • forum

    Qlik Replicate

    Interface Change on Version May 2024 (2024.5.0.144)

    I noticed that the table number count is missing on the designer screen from the lower left in the latest release.  Is this by design, or an oversight... Show More

    I noticed that the table number count is missing on the designer screen from the lower left in the latest release.  Is this by design, or an oversight?  This was a quick check on the number of tables per task, and it also provided a quick check to see if all tables selected are present in the database (i.e., selected vs. full table list).

    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!