Skip to main content

Welcome to
Qlik Community!

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

Welcome to Qlik Community

Recent Discussions

  • 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
  • forum

    New to Qlik Analytics

    To colour a bar in chart with multiple colours

    Hi, I have to colour the bars of chart in colour Green (for consumption  less than 850)and the rest of colour of same bar in red (for consumption more... Show More

    Hi,

    I have to colour the bars of chart in colour Green (for consumption  less than 850)and the rest of colour of same bar in red (for consumption more than 850).

    Beginner_Qlik1_0-1715013318531.png

    So for "03 Tankroom" , bar should be both in green(for <=850) and red(1911-850) color. and other two bars should be in Green color.

    Could some one let me know how to achieve this?

     

    Thanks in advance

     

    Show Less
  • forum

    App Development

    When Sheet Headers are disabled for an app, the sheet navigation arrows disappea...

    Hello, Just wondering if this "works as designed" or if it's a bug. In Qlik Sense Enterprise, when you go into an app's settings and select Disable Sh... Show More

    Hello,

    Just wondering if this "works as designed" or if it's a bug. In Qlik Sense Enterprise, when you go into an app's settings and select Disable Sheet Header, the nav icons "<>" are no longer present. This may seem obvious, but I was told by someone that in Qlik Sense Cloud, they appear in a different location.  So I was wondering if that claim was true and if they should also be visible in Qlik Sense client-managed as well. 

    Thank you

    Steve

    Show Less
  • forum

    Qlik Cloud Data Integration

    Get the session of the users

    Hello everyoneI would like to get session for the users accessing on cloud, on the Enterprise side i could get easily, but to cloud i have no idea, do... Show More

    Hello everyone

    I would like to get session for the users accessing on cloud, on the Enterprise side i could get easily, but to cloud i have no idea, does anyone could help me with this or have done something like this before?

    Show Less
  • forum

    New to Qlik Analytics

    where is "Variable Input extension"?

    HiI found some videos about the "Variable Input extension".But I can't find the download for the "Variable Input extension"According the release info ... Show More

    Hi

    I found some videos about the "Variable Input extension".

    But I can't find the download for the "Variable Input extension"

    According the release info the extension should be included since 2018.

    I have installed the latest from today, but no "Variable Input"

     

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate | Using filter condition on table

    Hi team, I have a doubt regarding creating filter conditions for a column, in the attached image I have used two filter condition, I'm having a requir... Show More

    Hi team, 
    I have a doubt regarding creating filter conditions for a column, in the attached image I have used two filter condition, I'm having a requirement were I want to use more number of filters that maybe in thousands(using python API QEM) , is it possible or can I know whats the maximum number of filters I can use.

    Thankyou
    Regards
    Sreehari

    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!