Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 251,838 members
  • 3,893 online
  • 2,033,975 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

    Talend Studio

    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 More

    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\",\"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 ?

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    QlikView App Dev

    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 More

    Good 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

     

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • 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
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly 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.

Location and Language Groups

Choose a Group

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

Collaborate

Blogs

Community News

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