Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
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?
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
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.
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
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 , -
But nothing worked, please help if anyone can provide suggestions
@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!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
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 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.
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.
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!