Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 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.
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 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.
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 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.
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 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.
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 sales table will be
selected if user selects sales value. I can bring sales, order and shipment as dummy values in a table.
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 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.
The 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 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.
Hello.
I am performing a PostgreSQL ---> Oracle synchronization and it is returning the following error:
This task has only CDC configuration, when performing a "Reload Target" the table loaded successfully. subsequently, the task returned this error above, what should I do?
The task was performed correctly before, for many days.
Encountering a persistent issue while trying to write data from SQL Server to Azure Blob Storage in Parquet format using Qlik Replicate. I'm authenticating via an Azure Enterprise Application, but I'm hitting a permissions-related error.
Source: SQL Server
Target: Azure Blob Storage (Container - raw)
Format: Parquet
Tool: Qlik Replicate
Authentication: Service Principal (Enterprise App in Azure AD)
Connection Method in Qlik: OAuth2 (with Client ID, Secret, Tenant ID)
Note:
Error:
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
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!
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!