Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 251,823 members
  • 4,958 online
  • 2,033,970 posts
  • 153,137 Solutions
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Visualization and Usability

    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 More

    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)

    akelleway_0-1747997620513.png

    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.

    Show Less
  • forum

    Qlik NPrinting

    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 More

    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.

    Show Less
  • forum

    Management & Governance

    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 More

    Hello Folks,

     

    We need users to be able to reload an app using writeback functionality.  I've created the following rule.

     

    justindallasverizon_0-1747923530748.png

     

     

    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.

    Show Less
  • forum

    Data Movement & Streaming

    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 More

    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.

    Show Less
  • forum

    App Development

    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 More

    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.

    Show Less
  • forum

    Reporting Service & Alerting

    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 More

    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.

    Show Less
  • forum

    Qlik Replicate

    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 More

    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.

    Show Less
  • forum

    Qlik Replicate

    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 More

    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.

    Show Less
  • forum

    Qlik Replicate

    PostgreSQL Error: state found as 'already active' while expected as 'inactive'

    Hello. I am performing a PostgreSQL ---> Oracle synchronization and it is returning the following error:   This task has only CDC configuration, when... Show More

    Hello.

    I am performing a PostgreSQL ---> Oracle synchronization and it is returning the following error:

    vitalf03_0-1696962483840.png

     

    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.

    Show Less
  • forum

    Qlik Replicate

    Azure Storage Container as Target to write parquet files

    Encountering a persistent issue while trying to write data from SQL Server to Azure Blob Storage in Parquet format using Qlik Replicate. I'm authentic... Show More

    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:

    • Already added storage blob contributor and reader roles to the application in the storage for the account.

    Error:

    • SYS-E-HTTPFAIL, Failed to connect to Data lake store name 'arthachicagoadb'..
    • SYS,GENERAL_EXCEPTION,Failed to connect to Data lake store name 'arthachicagoadb'.,JAVA_EXCEPTION, message: 'io.swagger.client.ApiException: This request is not authorized to perform this operation using this permission.'

     

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

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.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!