Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to use some header columns of metadata like $AR_H_USER that works fine in qlik replicate but in Qlik Talend Cloud Data Integration not work, there are some equivalent?
thanks,
Moin,
kann man beim Balken Chart beim count-Befehl mehrere Bedingungen setzen?
Also: Count({<Artikel={'Buch'} and Seite={'<100'}>} [Gegenstand])
Der Befehl funktioniert jedenfalls nicht
Hello
I have a pivot table with several expressions
I will show you 2 expressions 1 and 2 written in two different ways but they return the same correct result
expression 1 is not distributed on any dimension
while expression 2 is distributed on any dimension
but expression 2 is very slow when used with the remaining expressions in the pivot table
while expression 1 is much faster
Expression1:
{
$
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>
}
sum(SPENT_MANDAYS)
Expression 2:
(
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>}
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>}
sum(SPENT_MANDAYS)
)
kindly advise on why expression 1 is alwys under null scenario type
Hi all,
Yes an other Unparsable date/time question here. I know, there are a lot out there, but I could not find any suitable for my case.
I get date/time values. In a tExtractJSONFields I'm able to get most of them with format
"yyyy-MM-dd'T'HH:mm:ss.SSSSSS"
But. . . . . this fails when a date/time has (for example) the following value :
2025-11-12T17:29:36
No miliseconds, no dot what so ever.
How to handle vlaues like these ???
Thanks in advance.
Jacco
Hello,
I've been searching and testing different things, but I can't seem to get it!
I have a report set up, with a graph showing values by year. Now, I've been askded to filter the values by fiscal month, a year-to-date type thing. I have fiscal month field (MOIS_FISCAL), that is 0 to 11 for each month based on our fiscal year start date (Sept = 0, oct = 1....). And I have a variable that gives the current fiscal month vMoisCourantFiscNum.
I would like to filter MOIS_FISCAL < vMoisCourantFiscNum.
In qlik sense, I set up a button to test my expression, and this works perfectly as expected :
Now to Npriting, I've set up a filter to try and select my MOIS_FISCAL < vMoisCourantFiscNum.
I've tried it as above, with the syntaxe in Qlik (='<$(vMoisCourantFiscNum)'), chosing other options in the drop down list. But my report won't render. I get an invalid selections error.
What am I missing ?
Thanks for your help!!
Bonjour,
J'espère être dans la bonne rubrique 🙂
J'ai créé sur Qliksence dans un rapport une mesure, mais la formule ne fonctionne pas correctement.
Mon besoin :
Avoir le CA réalisé sur la société A sur l'offre A + CA réalisé sur la société A sur la BU AB.
Formule actuelle :
({<[DimSociete] = {'A'},
[DimBusinessUnit] = {'AB'},
[DimDateYear] = {"$(=Max([DimDateYear]))"}>}
[CA net])
+
({<[DimOfficeInvoice.Name] = {'A'},
[DimOffre] = {'OffreA'},
[DimDateYear] = {"$(=Max([DimDaterYear]))"}>}
[CA net])
Exemple : si j'ai 500€ en CA sur DimBusinessUnit 'AB' et je n'ai pas de CA sur DimOffre 'OffreA', au lieu de faire 500+0 =500 => il me met tout le CA de la société A, quand il ne trouve pas de données pour une dimension, il ne met pas 0 mais tout le CA de la société.
POuvez vous m'aider à adapter cette mesure pour qu'elle fonctionne.
Merci
Hi all,
I would like to have a custom sort on a dimension, but I would like to have it permanently, so users don't have to configure the sorting each time they use the field on a graph.
I checked all possibilities, but all except one require to configure the graph each time with a sort by expression.
However I found one solution with the SortCriterias in the Qlik Sense knowledge base, but I am a bit confused on how to use it.
Do I have to change something in a parameter file to use it (with qSortCriterias) ?
Do I use the
IEnumerable<SortCriteria> SortCriterias { get; set; }formula in an app script next to the field I want to sort ?
And, if SortCriterias is not easy to use, is there some other way to indeed permanently put a custom sort on a field so the field is automatically sorted everywhere in the app ?
Best regards.
Hi Team,
While we are replicating data such as "JbnttyFrmt.TNmbCretr NULL 826GB001244450 NULL Task sr NULL" from Oracle to Kafka is loading as "JbnttyFrmt.TNmbCretr826GB001244450Tasksr". Seems like the Nulls are getting omitted. Is it because of the limitation of Qlik ?
Please help
Thanks
Sreekanth
Hello,
On Qlik Cloud, I have QVD files stored in subdirectories, themselves located in subdirectories of a data space. Is there a simple script loading syntax to dynamically browse this tree structure to retrieve certain QVDs? Thank you.
Best regards,
HI Team,
Currently Qlik replicate child task is enabled with Stored changes only for CDC processing.
We are keeping global policy from Apply conflicts and using Upsert mode(for duplicates and inserts not found).Can we change this to Task policy for Stored changes.
Incase Global handling policy is needed, then still do we need upsert mode to be existed.
Will it cause delay(latency) while writing entries to attrep_changes table in Databricks.
Currently we are seeing latency while writing cdc data through Insert/SQL merge queries from Qlik->to s3->Databricks.
From error handling perspective between qlik-> databricks delta, Please let us know the recommendation for Apply Conflicts in this case.
Source:MS Sql server(MS-CDC)
Target:Databricks Delta
Thanks,
Sudarsan K
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different.
The Qlik Product Recap spotlights the latest features, plus a short demo and shareable resources to help you stay current and make the most of Qlik.
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader.
With Qlik Public ILT Passport, embark on live sessions with our top trainers — helping you grow faster and get the most out of Qlik. See where your passport can take you.
Take advantage of this ISV on-demand webinar series that includes 12 sessions of detailed examples and product demonstrations presented by Qlik experts.
Your journey awaits! Join us by Logging in and let the adventure begin.
Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.
Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.
Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.
Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.
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!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.