Hi all,

I would like some advice on the following subject : right now we have this setup to both trigger externally a task and send custom notifications when everything is done :

1. When the data is refreshed, a file generated by Databricks is sent to the VM where Qlik Sense Enterprise is installed.

2. This trigger some tasks in the QMC, thanks to one task that checks every minute if the file is present in a local folder, and ends in success when it finds it.

3. The file also contains info (months refreshed, etc.) which is then loaded in the Qlik Sense App that sends the notification (via Web Connectors).

We're working on a way to optimise things, and not be dependent on a txt file. I've already read about ways to trigger externally a task (https://community.qlik.com/t5/Official-Support-Articles/Examples-Trigger-a-Qlik-Sense-task-externally/ta-p/1714821, https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-external-program-task-in-Qlik-Sense-with-a/ta-p/1713044, https://community.qlik.com/t5/New-to-Qlik-Analytics/Trigger-Qliksense-task-based-on-external-event-like-Control-M/m-p/1719080), but I can't find a better way for the custom info and notification than with a file for Qlik to read on.

If anyone has suggestions on this subject, that would be very helpful.

Best regards,

Martin.

Hi everyone,
I’m working on a Qlik SaaS Automation and need to convert a JSON file (table) (from Onedrive) into a CSV file. Has anyone successfully done this in Automation? If so, could you guide me on the steps or provide an example? Any advice on how to map the JSON structure to CSV columns would be greatly appreciated!

Thanks in advance!

Miguel. 

Hello,

I am working on the expression editor where i have 3 columns on a table each i want to filter by a separate variable (list of string like:  AZ104;ERF21 ). For the moment i have that:

The problem is if i apply this, it will try all the possible combination of values inside variables.  The goal is to filter the table by a specific triplets (all the values ​​indexed 1 of each variables as a triplet, all the values ​​indexed 2 of each variables as a triplet....etc). Here an exemple of what it my return (in yellow) , so here the Count() need to be 2.

Thanks.

Hi everyone

I am trying to make these two dates fields return the YEAR in which an employee was active? what is the best way to handle the task?

SORTED DESC BELOW

Thank you

Are there any recommendations available for approporiate logging levels for all the different logging functions that can be set in QMC? I have found the support article The Qlik Sense Engine Traffic Log level with the recommendation that Traffic Log Level for Engine is only activated when problems already have been noticed, but surely there's some kind of best practice regarding what other log levels should be active in a system that seem to running just fine? 

Naturally the Debug log level should only be active for any type of logging when there is a problem that needs to be investigated, but there are many other logging levels available and a lot of different things that can be logged. 

What is a reasonable log level for each logging possibility, so that I get enough interesting system information in the Monitor Apps, but also a reasonable amount of information to discover what has gone wrong (when eventually something happens that shouldn't have happened)? Too much logging is just painful in various ways, but too little logging could turn out to be a painful experience as well...

Any suggestions?

Buenas tardes,                                                                                                                              

Tengo la siguiente tabla:                                                                                                                              

En la tabla se registran los cruces de usuarios en una autopista donde la hora de inicio de un recorrido está dada por el campo DT_TRANS_DATE_TS ylos escenarios son los distintos recorridos por los que se ha trasladado.                                                                                                                                     

Necesito agrupar los cruces en base al sentido y la hora del cruce, en donde si el tiempo entre cruces es menor al campo Parámetro (tiempo de recorrido promedio), se considera que dichos cruces forman parte de un solo recorrido, de lo contrario se considera un solo recorrido.                                                                                                                                

La forma en que busco agruparlos es creando un campo en el cuál si se cumple la regla del tiempo, devuelva el ID_TRANSIT del cruce inicial, de lo contrario que deje el mismo ID_TRANSIT. Esto intenté hacerlo con una dimensión calculada mediante la suguiente fórmula:                                                                                                                                         

=iF(Aggr(Min(DT_TRANS_DATE_TS),ID_CARD, SENTIDO) or (DT_TRANS_DATE_TS - Aggr( Above(TOTAL DT_TRANS_DATE_TS,1),ID_CARD, SENTIDO)>Parámetro ) ,ID_TRANSIT,Aggr( Above(TOTAL ID_TRANSIT,1),ID_CARD, SENTIDO))                                                                                                                                       

Pero el dato no es el esperado como se puede ver en las columnas Resultado actual vs Expresión, donde la columna expresión me dá el dato correcto pero no en la dimensión calculada que es donde la requiero para usarla en futuras fórmulas para agrupar datos.                                                                                                                                    

La fórmula de la expresión que me dá el dato correcto es la siguiente:                                                                                                                                         

Expresión:                                                                                                                                       

=Count(Aggr( Concat(DISTINCT Escenario2,'-'),ID_CARD ,SENTIDO))                                                                                                                                      

También entiendo que se podría obtener el dato desde el script pero no lo he conseguido tampoco.                                                                   

Por otra parte, también necesito concatenar los escenarios de la manera en que se muestra en la columna Concat(Escenario2), no he podido concatenarlos correctamente.                                     

Espero me pueda ayudar                                                                                                                            

Muchas gracias                                                                                                                            

Alejandro de la Garza

I created a new repo and I have added the git version credentials on Qlik compose but when I try to commit the first time am getting this:

i have been working on this project for months now and after i finalized most of the data warehouse my client noticed that all names that have Arabic letters shows as "???? ???" and when i was investigating the issue i found out that nvarchar is not supported in compose. is there a way that i can show the Arabic names? 

Hi Team,

I am getting the error "RetCode: SQL_ERROR SqlState: 22000 NativeError: 100144 Message: Invalid UTF8 detected in string '1000xEF'File 'a015ffd4_cef8_b042_a6c3_9230a7b23386/0/CDC00000001.csv.gz', line 23230, character 1210" in Qlik.

Could you please guide to resolve this error?

Thanks in advance.

Regards,

Nagamanickam K