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

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