Recent Discussions
-
tjava parse json
Hi I have a file input in Talend studion that contains below type of syntax and i need to extract userid, password from it"{\"password\":\"aaa\",\"us... Show MoreHi
I have a file input in Talend studion that contains below type of syntax and i need to extract userid, password from it
"{\"password\":\"aaa\",\"username\":\"aaab\"}"
any suggestion how to parse this json looking kind of field.
i tried tjsonextract but its not working correctly.
i am trying tjava and json.parse but that is also not working.
any suggestions/recommendations ?
-
Applymap or Join with wildcards
Good morning,I hope somebody can hel me.I have one table inline like this:OrdenPrueba:LOAD INLINE [Orden, Prueba34281, Prueba34457, Prueba2400104, Pru... Show MoreGood morning,
I hope somebody can hel me.
I have one table inline like this:
OrdenPrueba:
LOAD INLINE [
Orden, Prueba
34281, Prueba
34457, Prueba
2400104, Prueba
2403224, Prueba
2501056, Prueba
2501041, Prueba
];And I have other table where into the Id field can appears or not like part of it the filed Order of OrdenPrueba:
Numbers:
LOAD INLINE [
Id
37464342817456,
2403224464747,
7465752501056,
36474757,
383993300,
];
I would like to insert a column in the table Numbers, where appears Prueba when one of the orders appears as part of the field Id
Thanks in advance
-
Job Count for previous FYYear in Pivot Table
Hi All,I have this Pivot Table, where the dimensions are 'Region' and 'FYYear', which is a Financial Year field from a Master Calendar. The table curr... Show MoreHi All,
I have this Pivot Table, where the dimensions are 'Region' and 'FYYear', which is a Financial Year field from a Master Calendar. The table currently has one measure - 'Jobs', which is just a simple job count. Count(distinct RegionJobNumber)
But I am struggling with getting the same measure working for the previous FYYear. I am currently sat on this expression: Count({$<FYYear={"$(=max(FYYear)-1)"}>}distinct RegionJobNumber) but as you can see from the attached image, it is not working. The data itself goes back to 2015, but the FYYear dimension is filtered to >= 2022, so every column has the data required for this to work.
For now I am just trying to get this working as a standalone column measure, to check that the correct output is being produced. But eventually this will go into another measure, which will compare the Job Count (FYYear) to Job Count (FYYear-1) and then aggregate them by another field [CUSTOMER GROUP] to return the number of Customer Groups who had fewer jobs than the previous FYYear.
Any suggestions would be much appreciated.
-
Conditionally hide HTML table row
I've created an NPrinting HTML report that contains an HTML table based on a straight table in Qlik Sense. It works fine. Now I would like to hide one... Show MoreI've created an NPrinting HTML report that contains an HTML table based on a straight table in Qlik Sense. It works fine. Now I would like to hide one column in NPrinting based on a condition. I created a formula that returns an HTML row if the condition is met, else an empty string:
=If(Include='bh', '<td style="border-collapse:collapse;border: 1px solid;text-align: left;">%%Site%%</td>','')
But the result, in an email, is all messed up.
Is this possible in an HTML report or do I need to use PixelPerfect instead?
Note that I'm on NPrinting Feb 2024 SR3 but that's not an option in the dropdown menu.
-
Qlik Security Rule-Allow Users To Reload App
Hello Folks, We need users to be able to reload an app using writeback functionality. I've created the following rule. Does the rule allow them Rea... Show MoreHello Folks,
We need users to be able to reload an app using writeback functionality. I've created the following rule.
Does the rule allow them Read+Update for ALL App.Object_'s? Even ones that aren't in the App_.e9... application? If so, how do I further restrict this rule to allow Read+Update on the singular App in question?
Any guidance is greatly appreciated.
-
Alertas
Buen día quisiera programar una alerta en mi dashboar para que cuando cambie un dato me envíe un mail o un mensaje de texto, ya hice una pero no me ha... Show MoreBuen día quisiera programar una alerta en mi dashboar para que cuando cambie un dato me envíe un mail o un mensaje de texto, ya hice una pero no me ha mandado mail ni nada, adjunto imagen de lo que requiero (que me envíe una alerta cuando el número de máximo de entradas por hora.
-
Show tables based on user selection
I have a container with 3 tables, for example sales, order ,shipment. I am trying to select the container table based on my selection for example the ... Show MoreI have a container with 3 tables, for example sales, order ,shipment. I am trying to select the container table based on my selection for example the sales table will be
selected if user selects sales value. I can bring sales, order and shipment as dummy values in a table. -
PPT Generation using Automation - Filtering not Working
I'm using automation to generate a PowerPoint (PPT) report from my Qlik sheets. Although I apply filters within the automation workflow, the final PPT... Show MoreI'm using automation to generate a PowerPoint (PPT) report from my Qlik sheets. Although I apply filters within the automation workflow, the final PPT report is generated without applying those filters it shows the unfiltered data instead.
Has anyone faced this issue or knows what might be going wrong? I'm looking for a way to ensure that the filters applied in automation are reflected correctly in the generated PPT.
-
Can I Change Qlik Replicate Default URL (Hostname)?
The default URL to access Qlik Replicate on a Windows server is set tohttps://<machine-name>/attunityreplicate.Our customer has registered the domainh... Show MoreThe default URL to access Qlik Replicate on a Windows server is set to
https://<machine-name>/attunityreplicate.Our customer has registered the domain
https://<domain-name>/attunityreplicate in DNS and installed an SSL certificate matching this domain on Qlik Replicate.
Access via this domain is working correctly.However, since the default URL (https://<machine-name>/attunityreplicate) and the customer’s domain name (https://<domain-name>/attunityreplicate) differ,
web browsers display a security warning related to the SSL certificate mismatch.Could you please confirm whether it is possible to change the default URL in Qlik Replicate from <machine-name> to <domain-name>?
Thanks.
-
Dear Qlik Support Team, We are currently planning to deploy Qlik Replicate on a...
Dear Qlik Support Team, We are currently planning to deploy Qlik Replicate on a Linux platform and intend to use NAS as the shared storage solution. W... Show MoreDear Qlik Support Team,
We are currently planning to deploy Qlik Replicate on a Linux platform and intend to use NAS as the shared storage solution. We would like to inquire about Qlik’s official support and any potential risks or limitations for the following two NFS-related scenarios:
1. Virtual machines using NFS-backed virtual disks:
Qlik Replicate is running within a virtual machine (e.g., VMware), where the VM's virtual disk (e.g., VMDK) is stored on a backend NFS file system via the hypervisor or other mechanisms. The VM itself accesses the storage as a block device. Could you please confirm if this architecture is officially supported by Qlik? Are there any potential risks or recommended configurations for this setup?2. Direct NFS mount within the VM for Qlik Replicate storage:
Within the VM’s operating system, an NFS path is directly mounted and used by Qlik Replicate to store its working directory, task metadata, replication state files, log files, and internal repository. We understand this may introduce I/O performance latency, but we would like to further clarify whether this configuration could cause file locking issues, lead to data consistency risks during HA or failover scenarios, or if there are any additional use cases that Qlik specifically advises against. If any related recommendations or official technical documentation are available, we would appreciate it if you could kindly share them with us.Thank you for your assistance.