Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 163,379 members
  • 11,556 online
  • 1,716,710 posts
  • 129,337 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

      Qlik Application Automation

      How to create Common Filters in MAshup

      I am trying to integrate two applications using mashup, I want to add a filter that applies to both the applications 
    • forum

      New to Qlik Sense

      Field 'ID_DATE_NUM' not found

      Am trying to run below script but its giving me Field 'ID_DATE_NUM' not found error. Below is the script please help   PDT_DTL : Load *,Date(Date#(ID_... Show More

      Am trying to run below script but its giving me Field 'ID_DATE_NUM' not found error. Below is the script please help

       

      PDT_DTL :

      Load *,Date(Date#(ID_DATE_NUM,'YYYYMMDD'),'DD/MM/YYYY') as REPORTING_DT,
      num(Date(Date#(ID_DATE_NUM,'YYYYMMDD'),'DD/MM/YYYY')) as %KeyDate;

      SELECT
      CAT,
      ID_DATE_NUM,
      ID_DATE,
      REVN_SUB_TYPE,
      RGN,
      AREA,
      OS,
      SGMN,
      SUBS,
      SUB_MPS,
      VOL,
      VOL_MPS,
      VAL,
      VAL_MPS,
      REV,
      REV_MPS
      FROM
      TEMP_DASH_2022

      Show Less
    • forum

      Deployment & Management

      Qlik Cloud using tags to improve search

      Trying to find a better way to search for content in my apps.  In each app, there are many sections in the Load Editor area.  I thought that I could u... Show More

      Trying to find a better way to search for content in my apps.  In each app, there are many sections in the Load Editor area.  I thought that I could use tags so that I can search which app has the content better, but in Qlik Cloud, I don't see a way to search for the tags.  Also, the tags option only show up when I publish an app.

      What are tags use for in Qlik Cloud?  Other than the app name, is there another way to help search for the Sections in the app Data Load Editor screen?

      Show Less
    • forum

      App Development

      How to calculate hours in date range

        I have several notes that start one day and end the next. I need to calculate and the rule is start greater than 16h and end less than 16h.Example:f... Show More

       

      I have several notes that start one day and end the next. I need to calculate and the rule is start greater than 16h and end less than 16h.
      Example:
      func, oper, dt ini time, dt end time,
      A, 1, 06/26/2022 22:00, 06/26/2022 22:50
      A, 2, 06/27/2022 01:00, 06/27/2022 04:30
      A, 3, 06/27/2022 17:00, 06/27/2022 22:00
      A, 4, 06/28/2022 20:00, 06/28/2022 23:00
      A, 5, 06/29/2022 03:00, 06/29/2022 14:00
      B, 1, 06/26/2022 22:00, 06/26/2022 22:50
      B, 2, 06/27/2022 01:00, 06/27/2022 04:30
      B, 3, 06/27/2022 17:00, 06/27/2022 22:00
      B, 4, 06/28/2022 20:00, 06/28/2022 23:00
      B, 5, 06/29/2022 03:00, 06/29/2022 14:00

      Desired result:
      Func "A" on the 26th = from 22:00 on the 26th to 04:30 on the 27th
      func, day, total hours
      A, 26 06:30
      A, 27 05:00
      A, 28 18:00

      Show Less
    • forum

      New to Qlik Sense

      data load add colum on condition

      Hello, I would like to add a column in the data load editor. I have 2 products, product 1 and product b. for these i have 3 columns with dates. Date C... Show More

      Hello,

      I would like to add a column in the data load editor.

      I have 2 products, product 1 and product b. for these i have 3 columns with dates. Date C, Date D and date E.

      newcolumn = if product A, Date D - Date C, if product B, date E - date C

      can somebody help me with the syntax?

       

      Show Less
    • forum

      App Development

      Line chart X axis issues - (week) showing earlier data points not present in the...

      Hi There,On my dataset I have a constrain that only shows dates after 31/03/22.As you can see, when I hover over the first data point it shows that th... Show More

      Hi There,
      On my dataset I have a constrain that only shows dates after 31/03/22.

      As you can see, when I hover over the first data point it shows that the date is 01/04/22 - I am wondering why the Line chart X axis which is a week ending number is showing 27/03/21.

      lc_date.gif
      I had a look and I can confirm that in the data I don't have anything earlier than 01/04/22.
      Does anybody know how I can achieve this?

      Show Less
    • forum

      Brasil

      SUM - Soma acululada desconsiderando filtro

      Bom dia, Estou tentando fazer uma soma acumulada que traga o total mas que respeite os filtros que eu selecionar, e preciso desconsiderar o campo cent... Show More

      Bom dia,

      Estou tentando fazer uma soma acumulada que traga o total mas que respeite os filtros que eu selecionar, e preciso desconsiderar o campo centro de custo =000.

      No exemplo para a data 01/02/2022 preciso trazer o valor de 1089.(que no teste filtrando o período não funcionou)

      grazielegretter_0-1660306123046.png

       

      só que quando seleciono o centro de custo à ignorar, o campo total acumulado 2(minha tentativa) não funcionou em trazer o 1089 da soma simples anterior.

      grazielegretter_1-1660306201213.png

       

      Anexei um qvd com dados similares.

      Show Less
    • forum

      New to Qlik Sense

      variable in Sum

      Hi All, I have a variable and I have 2 total values in this variable. the content of my variable Test2; sum(grosstotal) + sum (grossamount) My express... Show More

      Hi All,

      I have a variable and I have 2 total values in this variable.

      the content of my variable Test2; sum(grosstotal) + sum (grossamount)

      My expression =  Sum({<PERNUM = {"=Sum([$(vTest2)]) > 0"}>} $(vTest2)) but is not working.

      What I want to do here is to bring the data of the personnel except the zero sum.

      how can i use the variable here please help

      Show Less
    • forum

      New to Qlik Sense

      connexion between sql server management tools ans qlickSense

      how to connect to database using windows authentication?  
    • forum

      QlikView App Dev

      Need quantity per product for latest (Max(DelDate)) delivery but Aggr gives resu...

      Hello All, need your help please. Checked already all relevant posts here for similar issues (also HICs guidelines on Aggr etc.) but can't get this to... Show More

      Hello All,

      need your help please.

      Checked already all relevant posts here for similar issues (also HICs guidelines on Aggr etc.) but can't get this to work 😞

      I just need the total quantities for each product for the latest delivery date

      desertmatt_0-1660292507766.png

      Data Excel and qvw attached - would appreciate if somebody could point me in the right direction please.

      Thank you very much

      Matt

      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