Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,331 members
  • 6,438 online
  • 1,989,560 posts
  • 149,023 Solutions
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

Welcome to Qlik Community

Recent Discussions

  • forum

    Deployment & Management

    Create new Qlik Sense Users by consuming API endpoint

    Hi thereI was wondering whether it is possible to populate Qlik Sense Users by reading a REST API endpoint? We have an application in which we have us... Show More

    Hi there

    I was wondering whether it is possible to populate Qlik Sense Users by reading a REST API endpoint? We have an application in which we have users, but we would like to give some of the users access to Qlik Sense. We can expose the user details (ID, Name and Attributes) using a REST API endpoint, but I am not sure if we will be able to create those users in Qlik Sense? The plan is to use the application together with a certificate to get tickets for these users, but I assume that we need to have the users available in Qlik Sense first (we want to use certain rules based on attributes).

    The alternative we are considering is to have a Qlik Sense App consume that REST API and then writing the details to an Excel file which is the source of a Qlik Sense UD connector, but we would like to cut out the QS app and Excel file if possible (seems like we are creating unnecessary steps in the process).

    Please let me know if anyone has done something like this or if you have any suggestions.

    Regards,

    Mauritz

    Update: My Excel plan won't work as I cannot write/store data into an Excel file. Now I REALLY need suggestions 😉

    @Levi_Turner @Gysbert_Wassenaar @rwunderlich 

    Show Less
  • forum

    App Development

    Qliksense ODAG - analyzer users

    Hello,I would like to know if there are any restrictions for user with an analyzer license to use an ODAG applications. If it is so, can you please al... Show More

    Hello,
    I would like to know if there are any restrictions for user with an analyzer license to use an ODAG applications. If it is so, can you please also explain which are these limits?
    Thank you in advance
    Sara 

    Show Less
  • forum

    Design and Development

    How to import 3rd party library when jar file cannot be downloaded

    Hello, I'd like to use Aspose.total or Aspose.words in a talend job.  Previously when we needed some third party jars (AWS secrets manager related), w... Show More

    Hello, I'd like to use Aspose.total or Aspose.words in a talend job.  Previously when we needed some third party jars (AWS secrets manager related), we downloaded the jars manually from mvnrepository.  

    However, in this case I don't see any jar files on the Aspose website or on mvnrepository.  I only see the xml for the pom.xml. See below. 

    <dependency> <groupId>com.aspose</groupId> <artifactId>aspose-words</artifactId> <version>24.2</version> </dependency>

    Do I need to manually insert that xml into the talend pom.xml?   The tLibraryLoad component seems to assume that you have access to the physical jar file, which I don't have.  

    I'm a decent talend developer, but I don't have much experience with third party libraries. 

    Show Less
  • forum

    New to Qlik Analytics

    Max date availability

    Hi All, I have to find the max date(MMYYYY) in which filter value PCAAT00 and PJABF00 must available for bate c. Here i attaching the data set for ref... Show More

    Hi All,

    I have to find the max date(MMYYYY) in which filter value PCAAT00 and PJABF00 must available for bate c.

    Here i attaching the data set for reference.

    max mmyyyy is 022024.

    max({<bate={'c'},filter={'PCAAT00','PJABF00'}>}MMYYYY)  ---032024 which is wrong

     

    Thanks.

    Qlik Sense Desktop maxDate.png

    Show Less
  • forum

    Deployment & Management

    What is the Node JS version of ServiceDispatcher\Node\Node.exe for Qliksense 202...

    What is the Node JS version of ServiceDispatcher\Node\Node.exe for Qliksense 2023 Nov and 2022 Nov
  • forum

    Design and Development

    Convert Datetime to Integer

    Hi, i need to convert Datetime to Integer in Talend - First i convert datetime to string  TalendDate.formatDate("yyyy-MM-dd HH:mm:ss:SSSS",row4.TimeSt... Show More

    Hi, i need to convert Datetime to Integer in Talend

    - First i convert datetime to string 

    TalendDate.formatDate("yyyy-MM-dd HH:mm:ss:SSSS",row4.TimeStamp)

    - Second i convert string to integer

    StringHandling.LEFT(Var.var1,4) ==> as var2 (for getting date in expression)

    Integer.valueOf(Var.var3) ==> (in output table)

    but get wrong like below

    asafrian1700127126_0-1710824448201.png

    There is no null data from the original table.

    Then I added the following command and the data was successfully streamed but something went wrong in the YEAR column 
    Var.var2!=null?Integer.parseInt(Var.var2):null

    the result 

    asafrian1700127126_1-1710824911166.png

    The year column contains a NULL value and the data contents in the YEAR column are not aligned with the rows so they do not match the TimeStamp column.

    Can you help to resolve this problem?

    Show Less
  • forum

    App Development

    Mostrar un KPI que me sume los 1's de mi tabla

    Tengo una tabla con columnas creadas por condicionales, y quiero mostrar un KPI que me sume todos los unos que hay en la tabla de las dos columnas que... Show More

    Tengo una tabla con columnas creadas por condicionales, y quiero mostrar un KPI que me sume todos los unos que hay en la tabla de las dos columnas que señalo.

    - count 

    - Real vs Requested

    Como vemos el sumatorio de la columna da 4 y el Kpi me esta dando 1, por lo que no entiendo porque me da distinto si la función que he puesto en KPI es un agregate de esa columna, (adjunto foto)

    migueldfr_23_1-1710835119706.png

     

    Esta es la función del KPI de Real vs Requested

    migueldfr_23_2-1710835148984.png

     

     

    Show Less
  • forum

    Qlik Enterprise Manager

    Analytics & DST

    My QR & QEM sit on 2XAWS EC2 instances, Windows OS. Timezone EST/EDT. Analytics Repository is AWS Aurora (Postrgres).According to AWS the default is U... Show More

    My QR & QEM sit on 2XAWS EC2 instances, Windows OS. Timezone EST/EDT.

    Analytics Repository is AWS Aurora (Postrgres).According to AWS the default is UTC.

    My Analytics data (retrieval_time) is showing as matching Eastern Time values.

    What I'm concerned about is (a) I need all my analytic data to be stamped by UTC and (b) conversions become complicated with DST.

    What is the best way to get my analytics data by UTC time?

    I have thought of altering the TZ at the windows OS level, but concerns this could affect other dependencies like maintenance & patching processes.

    Any "best practices" anyone could share?

    Thanks.

    Show Less
  • forum

    New to Qlik Analytics

    I want to plot the average order quantity on the chart.

    Hello, I want to take avarage. The chart shows sales amounts on a weekly basis. I want to plot the average order quantity on the chart. In straight l... Show More

    Ekran görüntüsü 2024-03-19 101309.png

    Hello, I want to take avarage. The chart shows sales amounts on a weekly basis. I want to plot the average order quantity on the chart. In straight line shape.

    Show Less
  • forum

    Qlik Cloud Data Integration

    Data Security

    If we have an application with our organisational data on Qlik SAAS Cloud, does it mean it is exposed to qlik vendor , how the security provided to ou... Show More

    If we have an application with our organisational data on Qlik SAAS Cloud, does it mean it is exposed to qlik vendor , how the security provided to our data on Qlik saas Cloud?

     

     

    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!