Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 163,169 members
  • 10,256 online
  • 1,716,246 posts
  • 129,289 Solutions
  • Announcements
    Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

    Welcome to Qlik Community

    FOR NEW MEMBERS

    Everything you need to make your Qlik Community experience valuable.

    SEARCH KNOWLEDGE BASE

    Explore official Support and member created content.

    ASK PRODUCT QUESTIONS

    Submit questions to product experts and participate in conversations.

    Analytics

    Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

    Data Integration

    Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

    Qlik Gallery

    Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

    Ideation

    Participate in Qlik Technical Previews, submit ideas, and review documentation.

    Support

    Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

    Events

    Learn about upcoming Qlik related events, webinars and local meetups.

    Groups

    Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

    About

    Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

    Blogs

    Hear directly from Qlik employees in our ten unique blogs.

    Qlik Resources

    Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

    Qlik Academic Program

    Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

    Community Sitemap

    Here you will find a list of all the Qlik Community forums.

    Recent Discussions

    • No Boards Found
    • forum

      New to Qlik Sense

      Sum IF

      Hello, I have following table: PLANNED_END_DATE QUANTITY ITEM CALCULATED_DELIVERY_DATE 12/12/2022 6:30 550000 483174 12/31/2022 0:00 11/22/2022... Show More

      Hello,

      I have following table:

      PLANNED_END_DATE QUANTITY ITEM CALCULATED_DELIVERY_DATE
      12/12/2022 6:30 550000 483174 12/31/2022 0:00
      11/22/2022 10:50 550000 483174 11/30/2022 0:00
      10/31/2022 21:35 201000 483174 10/31/2022 0:00
      8/25/2022 22:44 95648 483172 8/31/2022 0:00
      10/5/2022 17:42 1000000 483172 9/30/2022 0:00
      11/17/2022 18:37 1000000 483172 11/30/2022 0:00
      10/24/2022 8:12 369600 483207 9/30/2022 0:00
      10/25/2022 18:27 169600 483207 10/31/2022 0:00
      11/29/2022 13:56 300000 483207 11/30/2022 0:00
      12/7/2022 11:19 400000 483207 12/31/2022 0:00
      10/30/2022 0:53 260000 483241 10/31/2022 0:00

       

      I would like to have 3 columns in my application according to following rules:

      If planned end date > calculated delivery date then Sum the Quantity and show it as  "late orders"

      If planned end date = calculated delivery date then Sum the Quantity and show it as  "on time orders"

      If planned end date < calculated delivery date then Sum the Quantity and show it as "in advance"

      Could you please help?

      thanks in advance and regards

      Show Less
    • forum

      App Development

      Load data that exists between pairs of rows

      Hi there, I have a table like the following (generalised data): Position String 1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 a 9 h 10 d  ... Show More

      Hi there,

      I have a table like the following (generalised data):

      Position String
      1 a
      2 b
      3 c
      4 d
      5 e
      6 f
      7 g
      8 a
      9 h
      10

      d

       

      With an extract of relevant pairs as follows (assume that a and d are pairs that indicate the start and end of relevant data):

      Position String StringCount
      1 a 1
      4 d 1
      8 a 2
      10 d 2

       

      These tables continue for multiple rows, and there are multiple instances of "a" and "d" with data in between.

      The positions and counts of a and d can change depending on the source data.

      I wish to load the above table but include the data that appears between the pairs, i.e:

      Position String
      1 a
      2 b
      3 c
      4 d
      8 a
      9 f
      10

      d

       

      What is the easiest way to solve this? I figure I might be able to use a loop that relies on the StringCount, but wondering what ideas you have.

       

       

      Cheers,

      Prog

      Show Less
    • forum

      New to Qlik Sense

      New Qliksense Enterprise version

      Hi - Right now we have Qliksense enterprise May 2022 version. Does anyone know when will be the updated version of Qliksense enterprise release planne... Show More

      Hi - Right now we have Qliksense enterprise May 2022 version.

      Does anyone know when will be the updated version of Qliksense enterprise release planned?

      Thanks

      Show Less
    • forum

      Deployment & Management

      Virtual proxy URL not working

      HI, I am using Qliksense enterprise, multi-node, clustered environment. I just created an additional virtual proxy with prefix as "Test" connected to ... Show More

      HI,

      I am using Qliksense enterprise, multi-node, clustered environment.

      I just created an additional virtual proxy with prefix as "Test" connected to my Production proxy. Please see the screens below.

      Now when I try to access like https://qlikserver/test/hub/my/work, I get internal server error (500), please see the last screen shot.

      Does anyone know how to resolve this issue? 

      Appreciate your help!!

      jpjust_0-1659726325471.png

       

      jpjust_1-1659726355584.png

      jpjust_2-1659726484839.png

       

      Show Less
    • forum

      QlikView Administration

      QlikView and Oracle compatibility questions.

      I would like to know if the current QlikView version 12.10.20700.0 SR9 we are running on our servers is compatible with the Oracle client 19c? If ther... Show More

      I would like to know if the current QlikView version 12.10.20700.0 SR9 we are running on our servers is compatible with the Oracle client 19c?

      If there is a problem or you recommend a different version, please tell us the recommended version.

      thank you.

       

      Show Less
    • forum

      QlikView Administration

      limitar carga de Datos a 3 años

      buenas trades    quiero ver si me pueden apoyar en poder limitar la carga de informacion de solo tres años en mi QVD, ya que actualmete me carga todo ... Show More

      buenas trades 

       

      quiero ver si me pueden apoyar en poder limitar la carga de informacion de solo tres años en mi QVD, ya que actualmete me carga todo el Historico

       

      G_Table:
      LOAD OrigenTabla,
      ID,
      Mov,
      MovOrigen,
      MovOrigenID,
      MovID,
      FechaEmision,
      FechaRegistro,
      VentaUsr,
      FechaFinConteo,
      FechaInicioConteo,
      MovConcepto,
      Proyecto,
      UEN,
      Upper(Cliente) as Cliente,
      ClienteEnviarA,
      Almacen,
      len(Almacen) as AN,
      Articulo,
      OpcionSubCuenta,
      Cantidad,
      Observaciones,
      Referencia,
      Estatus,
      Agente,
      OrdenCompra,
      Causa,
      Precio,
      Ejercicio,
      Periodo,
      PrecioUnitario,
      SubTotalVentas,
      RFC,
      ClaveOpcionVenta,
      ClaseClaveOpcion,
      ListaPreciosEsp,
      Fabricante

      FROM
      [C:\Users\doc02\Desktop\Qvd\1\MovimientosV1.qvd]
      (qvd)Where Sucursal = '1'
      and not UEN= '1' and not UEN ='6' and not UEN ='7'
      and FechaEmision <= '01/01/2019' and Estatus= 'CONCLUIDO' and Cliente <>'CMEX1871';

       

      quiero cargar 2017, 2018, y 2019 solamente ?

       

      espero me puedan apoyar

      Show Less
    • forum

      App Development

      Disable / Make a chart unclickable in Qliksense?

      Is there any way to disable or make a chart unclickable/uninteractable in qliksense?  Believe it or not, I've been given a requirement to render a cha... Show More

      Is there any way to disable or make a chart unclickable/uninteractable in qliksense?  Believe it or not, I've been given a requirement to render a chart unclickable if possible. The end user wants it static.

      Thanks,

      Show Less
    • forum

      Security & Governance

      Desbloqueio de senha e usuário

      Desbloqueio de senha e usuário
    • forum

      Deployment & Management

      How to balance resource between tasks and users on one node?

      How to balance resource between tasks and users on one node?   Is it possible?   One node installation, qlik sense Aug2022 client-managed. We get prob... Show More

      How to balance resource between tasks and users on one node?

       

      Is it possible?

       

      One node installation, qlik sense Aug2022 client-managed.

      We get problem on user (hub) side when tasks on qmc (scheduler) side are running. Can we decrease resource level for tasks and give users (hub) max priority?

      Show Less
    • forum

      Deployment & Management

      Qlik Sense Connections

      Hi All,  Not sure if I've assigned this to the correct location but I'm not sure where to look.  I'm trying to figure out when a connection has been c... Show More

      Hi All, 

      Not sure if I've assigned this to the correct location but I'm not sure where to look. 

      I'm trying to figure out when a connection has been created or assigned to a specific user, then that person leaves the company, what happens to that connection? 

      When I've created connections in the past, I've always gone to the QMC and changed the owner to sa_repository and then removed the owner from the name but this is purely because when I was brand new to Qlik, the person before me did this. 

      Is there a best practice for things like this and if so, are there any useful resources or links available?

      Many thanks, 

      V

      Show Less

    Blogs

    Community News

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

    Blogs

    Qlik Academic Program Blog

    Read the latest blog around the Qlik Academic Program.

    Blogs

    Qlik Product Innovation Blog

    If you want to know what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Get the latest Support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Qlik Design Blog

    Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

    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

    Events and Webinars

    QlikWorld Tour

    Discover your data swagger at a city near you.

    Find your city

    Events and Webinars

    Qlik and Qlik Community Hosted Events

    Subscribe to our Events and Webinar page so you do not miss an event opportunity!

    choose and register

    Event

    Welcome to Qlik

    Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

    On-Demand

    Events

    Upcoming Events and Webinars

    There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

    Upcoming