Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,786 members
  • 7,669 online
  • 1,997,253 posts
  • 149,730 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Incorrect KPI calculation

    Hi, I have a problem in the data model and KPIs.The Facts table consists of several tables (concatenate), and there is a dimension table that contains... Show More

    Hi,

    I have a problem in the data model and KPIs.
    The Facts table consists of several tables (concatenate), and there is a dimension table that contains flags.
    I want to count the amount of values in a packet according to a certain flag and I don't get data.

    How can I solve this?

    Simple example

    Fact:

    SourceTable num(Date) StoreID OrderID ItemID Qty Amount GoalAmount Key
    Orders 44444 001 1001 a001 1 100 - 44444 | 001
    Orders 44444 001 1001 b002 1 150 - 44444 | 001
    Orders 44444 001 1002 a001 2 200 - 44444 | 001
    Orders 44444 002 2001 c003 5 50 - 44444 | 002
    Orders 44444 002 2002 a001 4 350 - 44444 | 002
    Orders 44444 001 1003 b002 2 300 - 44444 | 001
    Goals 44444 001 - - - - 700 44444 | 001
    Goals 44444 002 - - - - 800 44444 | 002


    Dim:

    Key flag1 flag2 flag3
    44444 | 001 1 1 0
    44444 | 002 0 1 1
    44444 | 003 1 1 1

     

    Sum({<flag1={1}>}Qty) = 6 --> I received 0.
    Sum(Qty) when filtered on flag1=1 --> I received 0.

    My final KPI should be like that:
    Avg(Aggr(Sum({<flag1={1}>}Qty),Date))

    Thanks!!

    Show Less
  • forum

    Integration, Extension & APIs

    Need Help Retrieving Export Activity Logs from Qlik Sense Cloud via Audit API

    Hi everyone, I'm currently working on retrieving user data related to the export of data, images, or PDFs in our Qlik Sense Cloud environment. I have ... Show More

    Hi everyone,

    I'm currently working on retrieving user data related to the export of data, images, or PDFs in our Qlik Sense Cloud environment. I have set up a connection for auditing purposes as per the guidelines in the Qlik Developer Portal, but I am struggling to find the specific information regarding user exports.

    Despite setting up the audit connection, I'm unable to locate or retrieve logs that detail when users export data, images, or PDF files.

    Here’s what I have tried:

    • Set up an audit API connection following the official Qlik documentation.
    • Attempted to query the audit logs looking for export actions but could not identify the right parameters or event types related to exports.

    Could anyone provide guidance or share examples on how to properly query the Qlik Sense Audit API to capture these specific user activities? Any tips on the types of filters or API endpoints to use would be greatly appreciated.

    Thank you in advance for your help!

    Best Regards,

    Nick

    Show Less
  • forum
  • forum
  • forum

    QlikView Administration

    How to Monitor Qlikview Apps usage like we have in Qliksense Monitoring Apps.

    I need to monitor Qlikview Applications usage how we did in Qliksense Monitoring Applications.
  • forum

    App Development

    Variable Input: Sorting Dates

    Hi everybody, I have tried to sort the filter-values shown on the screenshot. Unfortunately they are sorted as Strings due to the concat-function i us... Show More

    Hi everybody,

    I have tried to sort the filter-values shown on the screenshot. Unfortunately they are sorted as Strings due to the concat-function i use for creating the "selections". Does anybody know how to sort the values correctly?

    Danri94_0-1715070158981.png

    Danri94_2-1715070229103.png

     

     

    Show Less
  • forum

    App Development

    How to add font to the list of fonts in Qlik Sense Styling properties

    Hi,  I am working with Qlik Sense February 2024 Patch 1 (QSEoW) and I am wondering what makes the list of fonts which we can choose from when styling ... Show More

    Hi, 

    I am working with Qlik Sense February 2024 Patch 1 (QSEoW) and I am wondering what makes the list of fonts which we can choose from when styling objects. The list opens up and presents various fonts but those are not all fonts this client has and uses. I would like to add my own font to that list so it is always present for users to choose from. Is there any documentation regarding custom font requirements and whether it is possible to add one to that list without creating custom theme?

    I am going through documentation trying to find anything on that subject but so far I didn't see anything.

    thanks

    Lech

    Lech_Miszkiewicz_0-1710891686578.png

     

     

    Show Less
  • forum

    App Development

    Find latest row for each "Kenteken" and only import those

    Hi there.   I have a problem and I can't seem to fix it in my load editor I want to import only the values of the latest row found for each Kenteken. ... Show More

    Hi there.

     

    I have a problem and I can't seem to fix it in my load editor I want to import only the values of the latest row found for each Kenteken. So for instance a Kenteken xx-00-xx can be on row 12000 and the same one xx-00-xx can be on 14000. I only want to import the latest row with that particular kenteken and other fields in order to get rid off duplicates. I want it to be done in the load editor and not in the front-end.

     

    Unfortunately I can't do anything with dates because they can be similar and there are too many variances.

     

    This is the script:

    feit_Boekwaardelijst:
    Load DISTINCT
         Kenteken,
        "Boekwaarde bedrag",
        "Boekwaarde datum",
    "Boekwaarde bedrag BTW",
    "Restwaarde bedrag",
        "Restwaarde datum",
    "Afschrijving termijnen",
    "Afschrijving KM",
      "Afschrijving schade",
    "Afschrijving kosten",
    "Afschrijving corr. rente",
    Verkoopbedrag,
    "Kostprijs verkoop",
    "Verkoop resultaat",
    Investering,
      "Verkoopprijs incl. BTW",
      Capitalize("Debiteur verkoop") as  "Debiteur verkoop",
      '-' & "Debiteur verkoop" as Handelaren,
        "Verkoop soort",
      Num("Inname stand", '#.##0') as "Inname stand"
    FROM [lib://IC Files - Company/Stream - ML - Algemeen/App - Verkooprapportage/Boekwaardelijst 2018 - 2023.xlsx]
    (ooxml, embedded labels, table is Tabelle1;
     
     
     
     
    Thanks a lot.

     

    Show Less
  • forum

    Design and Development

    Exception in routine but the job exit as 0

    For example, let say i create a routine that will pretty print JSON on log package routines; import org.apache.log4j.*; import routines.system.JSONOb... Show More

    For example, let say i create a routine that will pretty print JSON on log

    package routines;
    
    import org.apache.log4j.*;
    import routines.system.JSONObject;
    
    public class PrettyPrintJSON {
      private static org.apache.log4j.Logger log = LogManager.getLogger(PrettyPrintJSON.class);
    
      public static void print(String jsonPayload, String description) {
        try {
          JSONObject json = new JSONObject(jsonPayload); // Convert text to object
          log.info(description + " JSON  : \n" + json.toString(4));
        } catch (Exception e) {
          e.printStackTrace();
        }
        return;
      }
    }

     

    So when I use this routine on Tjava or inside another routine that uses non JSON string

    String json ="sorry I not JSON man!";
    PrettyPrintJSON.print(json,"Wakanda create case payload");

     

    Seem the job still keep continue running and exit with status 0.

     

    I expecting it to stop or exits with status 1

    Show Less
  • forum

    Deployment & Management

    License requirements for Qlik Sense SaaS provisioning

    Hello, I have a question regarding the requirements for automated provisioning of Qlik Sense SaaS. In the help it is stated that P2 or higher license ... Show More

    Hello,

    I have a question regarding the requirements for automated provisioning of Qlik Sense SaaS.

    In the help it is stated that P2 or higher license is required, however according to Microsoft licensing requirements, P1 can also be auto-provisioned.

    https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/auto-provisioning-configure-scim-in-azure.htm
    -----------------------------------------------------------
    Microsoft Entra ID with a P2 subscription or higher (formerly Microsoft Azure Active Directory Premium P2)
    -----------------------------------------------------------

    https://www.microsoft.com/en-us//security/business/microsoft-entra-pricing
    -----------------------------------------------------------
    Identity governance>Automated user provisioning to SaaS apps>on
    -----------------------------------------------------------

    Why do we need a P2 or higher license?
    This is a costly area, so I would appreciate the information.

    Thank you in advance.

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!