Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 233,059 members
  • 5,109 online
  • 2,016,171 posts
  • 151,379 Solutions
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Intervalmatch MAPPING

    Hello, I have a relatively simple task, but I’m currently stuck at one point. I want to create something similar to an Intervalmatch, but optimized fo... Show More

    Hello,

    I have a relatively simple task, but I’m currently stuck at one point.

    I want to create something similar to an Intervalmatch, but optimized for mapping, as a traditional Intervalmatch would take too long in this case.

    I have a mapping table with timestamps, which usually differ only slightly from those in the target table, but in most cases, they almost match. Now, I’d like to define an additional column that maps the correct value from the mapping table to the target table, as long as the timestamp in the mapping table doesn't deviate by more than 10 seconds in the past.

    Here’s a sample code to illustrate:

    MAPPING_TABLE:
    MAPPING LOAD 
    KEY & '-' & Date & '-' & Time,
    Time
    INLINE [
    KEY, Date,Time,
    1, 22.05.2024,13:10:41
    1, 22.05.2024,13:11:40
    1, 22.05.2024,13:11:37
    ];

    TABLE2:
    LOAD *,
    APPLYMAP('MAPPING_TABLE', KEY & '-' & Date2, 'N/A') AS Time; // Need the correct code here;
    LOAD *,
    Time(Time2 - MakeTime(0, 0, 10)) AS TimeDelta
    INLINE [
    KEY, Date2, Time2
    1, 22.05.2024, 13:11:45
    1, 22.05.2024, 13:11:41
    1, 22.05.2024, 13:11:38
    ];

    My goal is to create the following table:

    GOAL_TABLE:
    LOAD *
    INLINE [
    KEY, Date2, Time2, Time,
    1, 22.05.2024, 13:11:45, N/A
    1, 22.05.2024, 13:11:41, 13:11:40
    1, 22.05.2024, 13:11:38, 13:11:37
    ];

    Hopfefully you can support me here.

     

    Best regards Son

    Show Less
  • forum

    New to Qlik Analytics

    Create new table

    Hello, please see the picture below.  I am trying to create a new table that creates a row for each day for each particular machine regardless if that... Show More

    Hello, please see the picture below.  I am trying to create a new table that creates a row for each day for each particular machine regardless if that machine had an exam date, and then creating a column in that table that holds the total minutes in that day.  Please help!

    drohm002_0-1728402122360.png

     

    Show Less
  • forum

    New to Qlik Analytics

    complex section access scenario for masking columns

    Hi All, I have data with some PII fields. I have three user role which are defined in the section access data with USERID, ROLE field. Three roles are... Show More

    Hi All,

    I have data with some PII fields. I have three user role which are defined in the section access data with USERID, ROLE field. Three roles are PII,SEMI_PII,NON_PII. In data I have around 3 PII fields. When user with role PII logs in, he should see all PII field values as is. When user with role SEMI_PII logs in, he should see all PII field values partially masked. When user with role NON_PII logs in, he should see all PII field values fully masked. Masking could be anything but masked values should be unique for each field value. for eg. I have Client Name A,B & C, so masked values could be like xAnvBgH, HnbvFTb & hhGVcDr which is unique to each Name as values will be repeating.

    Definition of SEMI_PII is that we have indicator in our data, if indicator value is 1 PII fields should be masked, otherwise original values should be displayed. for eg. Let's say we have Client Name A, B & C. for values A & B indicator is1 and for C it is 0. So when user logs in he should see values cHbbVch,BngVbhjK & C. Which means A & B values will be masked.

    Note: I have around 1000 users and PII field values for some field might have 5 million distinct values. 

    I don't know how to approach this

    Show Less
  • forum

    Qlik Replicate

    Full reload and CDC failed with message. Failed to get source column def for id...

    We have an existing old task that has failed under "error". We did a full reload it works. But after several minutes, the CDC kicks in and we got the ... Show More

    We have an existing old task that has failed under "error". We did a full reload it works. But after several minutes, the CDC kicks in and we got the error message as below. I have replaced the schema and table name. The rest are the error logs.

     

    Table 'Schema'.'table123' (subtask 0 thread 1) is suspended. Failed to get source column def for ids[0]=6.

     

    The source endpoint is Oracle 11g and target endpoint is MySQL 8 AWS. We are on version 

    • November 2022 (2022.11.0.628)

     

    Update:

    I am getting this error now.

     Failed to get source column def for ids[2]=1335435064

    Show Less
  • forum

    New to Qlik Analytics

    Create a single date from an interval

    Hello,   I hope that you can help me. So basically I have a qvd with Date intervals like 4th August to 10th August, 11th August to 15th August and so ... Show More

    Hello,

     

    I hope that you can help me.

    So basically I have a qvd with Date intervals like 4th August to 10th August, 11th August to 15th August and so on and on...

    My goal is to create a datefield in which I can type a date and it should give me the correct interval. Do you know how to create such a visualization?

     

    Thanks for your help!

    Show Less
  • forum

    New to Qlik Analytics

    How to import a table where measures are in rows

    Hello   I am loading the following table in my Qlik DB without any problem However, I also have to load the table hereunder and I am a bit stuck. Is... Show More

    Hello

     

    I am loading the following table in my Qlik DB without any problem

    Real.png

    However, I also have to load the table hereunder and I am a bit stuck.

    Targets.png

    Is it possible to load those data without modifying the original file?

     

    Many thanks

    Show Less
  • forum

    Qlik NPrinting

    nPrinting February 2024 SR3 - Excel report - Pivot tables with "Page" feature

    Pivot tables don't seem to be working properly with the "Page" feature in nPrinting Excel reports. To reproduce it: Create a connection to any Qlik S... Show More

    Pivot tables don't seem to be working properly with the "Page" feature in nPrinting Excel reports.

    To reproduce it:

    1. Create a connection to any Qlik Sense app.
    2. Create an Excel report using that connection.
    3. Add any field as "Page". This will change the name of "Sheet1" to <NAME_OF_FIELD>.
    4. Create a fixed table in the Excel (a table not coming from Qlik, but just some fixed data).
    5. Create a pivot table in the sheet using the fixed table as source.
    6. Preview the report.

    Let's say you are iterating over field MYFIELD and values are MF1, MF2, MF3 and MF4. In this case, nPrinting will clone your sheet 4 times and they will be called MF1, MF2, MF3 and MF4.

    The fixed table will be present in all sheets and the pivot table as well. However, in ALL sheets, the pivot table will point to the fixed table in sheet MF1 (the first one).

    In this case, the expected behavior is for nPrinting to generate 4 sheets (MF1, MF2, MF3 and MF4), each sheet will have a copy of the fixed table and each sheet will have a pivot table using as data source the fixed table from the same sheet.

    I understand in 2017 there was an issue (Jira issue OP-5657), which was fixed, related exactly to the issue of mixing "Page" with pivot tables (see release notes for nPrinting November 2017).

    So, is this supposed to work as I expect it to? Is this an error? Is it a "feature"? (maybe @Andrew_Kruger or @Gianluca_Perin can help?).

    Thanks a lot for your help!

    Show Less
  • forum

    Move to SaaS

    "Connecting" error happening frequently in Qlik Cloud Government QCG SaaS

    We have been seeing this error fairly often, for multiple users, in many different locations, on vpn and off vpn.  The error is similar to a timeout b... Show More

    We have been seeing this error fairly often, for multiple users, in many different locations, on vpn and off vpn.  The error is similar to a timeout but happens while the user is actively working in an app. The message shows at the top of the screen like shown below.

     

    Ken_T_0-1728399357765.png

     

    when this error happens, developers sometimes lose the recent changes to the script that they were working on.   we reported this to Qlik support but did not get any resolution, cause or workaround.

    Is anyone else seeing this situation in Qlik SAAS or in QCG?
    have you found any causes or workarounds?

     

    Show Less
  • forum

    Qlik Cloud Data Integration

    Bug? Why does qlik-embed still use third party cookies?

    When i block them it still works fine with oAuth and getAccesstoken.   When i reload Qlik programatically by deleting all the scripts and window objec... Show More

    When i block them it still works fine with oAuth and getAccesstoken.

     

    When i reload Qlik programatically by deleting all the scripts and window objects to refresh the session it doesnt fix any timed out errors. I suspect this cookie causes it.

    Show Less
  • forum

    Design and Development

    Impossible to create a case

    Hello, I would like to create a case or to follow an existing Talend case (00316713) : https://community.qlik.com/t5/Official-Support-Articles/How-to-... Show More

    Hello,

    I would like to create a case or to follow an existing Talend case (00316713) :

    https://community.qlik.com/t5/Official-Support-Articles/How-to-view-cases-in-Support-Portal/ta-p/1717144

    When I select "Manage Cases" I am redirected to :

    URWITEU_1-1728397921198.png

    Could you please tell me how to do that ?

    We are paying a platinum support and we are unable to create a simple ticket...

    Thanks.

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

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!