Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes"
the tables are huge and by nature there is heavy DML operations.
My target is Snowflake "Extra Small Size", I see significant amount of latency when i tried replicating audit tables.
Is there a way I can limit the date range to be at most 24 months of history data in the replicate task ?
Thank you.
Hi,
I am trying to reload a Qlik Replicate task using QEM Python API.
I am using reload_table method to achieve my goal.
However, I do not see any option to define filters using the above method.
I have tried the below:
reload_table(server, table, filters:{col1:value1,value2})
but that doesn't work.
Is there any way to achieve my said requirement using the above method or is there any other method which I can use to reload the task with table filters.
Kindly assist.
Dear All
The include variable is located behind the exit clause.
This script is not interrupted in the exit clause.
Why is the include variable executed?
*********** Script new *****
*************** Script end
Qlik Sense Version : Nov 2023 patch 7
Best Regard
Hanna.choi
Hi, Could use some help targeting a solution for an odbc azure error when running jobs in the QMC.
The full error is:
C:\ProgramData\Qlik\Custom Data\QvOdbcConnectorPackage\Log
azure_sql EXCEPTION IN Server.Run(): Invalid connector configuration file - can not find azure_sql-reading-strategy key
This occurred after a QS upgrade from a 2022 version to November 2023 Patch 3.
2 servers were upgraded with only one having the issue with jobs running in the QMC.
In that troubled server, the Azure connections in Qlik Sense will alloy selection of data (connection is apparently fine) but changes to the connection can not be made.
Hi,
We are migrating from Qlik Sense Windows to Cloud.
When running the migration scipt for migrating apps, it gives error. Tried each line in qlik cli. The line that fails is
qlik qrs app export create $appid --skipdata $SS --exportScope all --output-file $exportAppFile
Error: 400 - Bad Request (empty response)
But when i run the command without the --exportScope all option in qlik-cli it works.
qlik qrs app export create $appid --skipdata $SS --output-file $exportAppFile
Are there any permissions or setup that i am missing?
Thanks,
Anuradha
Bonjour
On me demande de créer un graphique combiné avec des aires et des lignes.
Dans Qlik Sense je n'ai trouvé que la composition barres et lignes.
D'avance merci de votre aide
Hello!
I am trying to create some reports in Qlik Sense using the Stories functionality.
Is there any way that I am able to automatically update the reports?
I mean, I create some screenshots and stories in my dashboard, and I would like to have a report with the same tables and graphs each 2 weeks. Is it possible to get the information updated, or should I create the snapshots every time I want to see them?
Thank you in advance!
Hi everyone,
i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set analysis, but this is not working as expected when i want to filter, based on this result field.
So, consider having the following Table:
CreditorNr | Type | BankNr
010001 | 200 | 12345200
010001 | 200 | 12345200
010001 | 200 | 12345200
010001 | 200 | 12345100
010001 | 100 | 12345100
Using the following formula, i obtained the following MatchField:
=aggr(If(
Count(Distinct Type ) = 1 and
Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear'), CreditorNr , BankNr)
i get following results, that are also correct:
CreditorNr | Type | BankNr | MatchField
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345100 | Partner bank is not clear
010001 | 100 | 12345100 | Partner bank is not clear
Anyway, when trying to implement this in the Script, i dont get the correct result. In the Script i use the following code:
TEMP:
NoConcatenate
Load CreditorNr,
If(Count(Distinct Type) = 1 and
Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear') as ScriptMatch
Resident BankTab
Group by CreditorNr, BankNr;
And i get the following result:
CreditorNr | Type | BankNr | MatchField | ScriptMatch
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345100 | Partner bank is not clear | Partner bank is clear
010001 | 200 | 12345100 | Partner bank is not clear | Partner bank is not clear
010001 | 100 | 12345100 | Partner bank is not clear | Partner bank is clear
010001 | 100 | 12345100 | Partner bank is not clear | Partner bank is not clear
So it basically goes through every BankNr and duplicates the data, once bank is clear, and once bank is not clear...
Can anyone please give me a hint on what im i doing wrong in the script?
Thank you for the support. 🙂
Bonjour,
Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ?
Y a-t-il une extension autre que celle du bundle ? Car celle du bundle permet de sélectionner qu'une seule valeur.
Merci d'avance,
Waïl
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
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!