Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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?
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?
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.
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!
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!
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é
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?
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).
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!