Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 169,172 members
  • 5067 online
  • 1,713,990 posts
  • 130,386 Solutions
  • Announcements
    Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE

    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 Qlik Community

    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 NPrinting

      Variable value does not work

      Hello, I have created dasboard in Qlik Sense. I created variables for my measures like example below. I want to use Nprinting based on user values, so... Show More

      Hello,

      I have created dasboard in Qlik Sense. I created variables for my measures like example below. I want to use Nprinting based on user values, so I set an employee ID number value in variable  part of filter, then I added this filter for user but it does not work.  Any help will be really appreciated?

      SET v_RESPONSIBLE = 'SEC_ACC_ADMA';
      SET v_RESPONSIBLE_PS = 'SEC_ACC_PS';

      SET v_OsUser = (upper(SubField(OSUser(),'=',-1);

      Measure: count({<SEC_ACC_PS={$(v_OsUser)},TASK_ENTITY={"Proje Ziyareti"}>} [Task_Subject])

      Nprinting :

       

      ElifGuler_0-1663871814037.png

       

      Thanks.

       

      Show Less
    • forum

      Qlik NPrinting

      Upgrading from NPrinting June 2020 SR1 to May 2021 SR4 postgreSQL tables missing...

      We are upgrading from NPrinting June 2020 SR1 to May 2021 SR4.  I reloaded 2 nprinting monitoring apps after upgrade and get errors on reload. postgre... Show More

      We are upgrading from NPrinting June 2020 SR1 to May 2021 SR4.  I reloaded 2 nprinting monitoring apps after upgrade and get errors on reload. postgreSQL tables missing fields

      Qlik NPrinting Operations Monitor shows 

      SELECT * 
      FROM "nprinting"."public"."report" 
      Error: Field 'import_task_id' not found 
      Execution Failed

      The other app  NPrinting Task Schedule shows 

      SELECT "id", 
      "version", 
      "created",  
      FROM "public"."task_execution" 
      Error: Field 'id' not found 
      Execution Failed 
      Execution finished.

      In Qlik NPrinting Operations Monitor app if I pull up the db table in the app I can see the field IS missing compared to our other server which is still June 2020 SR1.

      In the NPrinting Task Schedule app if I pull up the db table in the app I can see the field IS NOT missing compared to our server on June 2020 SR1.

      In the Qlik NPrinting Operations Monitor I have temporarily commented out the line to allow successful reload.

      In the NPrinting Task Schedule app - I cannot do the same since this field is needed and it IS present in the table - I can't understand why it say it isn't.  If I go to the connection, locate the table and choose "insert script" ... I can see it there.

      current: Qlik Sense Enterprise June 2020 Patch 7 ; NPrinting June 2020 SR1

      upgrade to :  Qlik Sense Enterprise May 2021 Patch 12, Qlik NPrinting May 2021 SR4

      @Lech_Miszkiewicz 

      Show Less
    • forum

      Qlik Replicate

      Replacing a default value using Global transformation

      I am replication from Oracle 11.2.0.4 to target MySQL 8.0.30 The source table has some default values. I would like to use global transformation to re... Show More

      I am replication from Oracle 11.2.0.4 to target MySQL 8.0.30

      The source table has some default values. I would like to use global transformation to replicate default values to target table. When my source table has column "STATUS" default value='OPEN', the target DB status column should be having values 'OPEN' as well.

      replace($name,'OPEN','OPEN')

      I hit into error as attached screenshot.

      My global transformation define as

      Global rules --> new rule --> replace column values

       

      Can help please as I am not familar with the function.

       

      Thank you.
      Desmond

       

       

      Show Less
    • forum

      New to Qlik Sense

      Users access issue

      Hi Qlik Peeps, We would like to ask about this issue occurring now. One of our user had an analyzer license and  switch it to professional license but... Show More

      Hi Qlik Peeps,

      We would like to ask about this issue occurring now. One of our user had an analyzer license and  switch it to professional license but when she login her account it seems that the license still was the old license she have (analyzer license. Is there a quarantined happening on the account?  

      We are currently using Qlik Sense Enterprise May 2022 version.

      Any thoughts on this?

       

      Thanks in advance.

      Show Less
    • forum

      New to Qlik Sense

      Automatic cycle through sheets/storytelling

      I have 4 Sheets currently split through separate apps, these can be brought together to one if necessary. I am trying to present them on TV screens as... Show More

      I have 4 Sheets currently split through separate apps, these can be brought together to one if necessary. I am trying to present them on TV screens as dashboards to show work available etc. 

      I can create an embeded link for the sheet which only I can view as it is a preview and this shows the format I want as storytelling removes the formatting and with F11 the default view still has the header like below.

      JonathanKelly_0-1660897043526.png

        Is it possible and if so how can I go about presenting the a sheet or multiple sheets to a TV screen via a URL, etc. and have multiple sheets cycle through like a slide show while still looping back to the beginning once it has gone through all sheets? 

      Show Less
    • forum

      Deployment & Management

      Error Accessing QMC - cannot read properties of undefined (reading 'userid')

      When opening the QMC we are experiencing the error "cannot read properties of undefined (reading 'userid')". Sometimes it can be cleared by clicking R... Show More

      When opening the QMC we are experiencing the error "cannot read properties of undefined (reading 'userid')".

      Sometimes it can be cleared by clicking Refresh but sometimes it persists.

      Show Less
    • forum

      New to Qlik Sense

      Show 0 in Pivot Table

      Dear I have a order table which has sales district info , The below 'RC_PSS Simogear'  shows 0  in PY in the pivot chart. How to  create like it? Thi... Show More

      Dear

      I have a order table which has sales district info , The below 'RC_PSS Simogear'  shows 0  in PY in the pivot chart. How to  create like it?

      StacyCui_1-1664505151011.png

      This is my pivot chart. It could not show the RC_PSS Simogear.  Should I use "Outer Join"?  Use Order table outer join Master Calendar table? or is there any other method?  I am really appreciated for your reply.

      StacyCui_2-1664505557867.png

       

      Show Less
    • forum

      New to Qlik Sense

      Auto number with qlik partial load is not working as excepted

      Hi All, autonumber with qlik partial load giving wrong results. can you please suggest how to go ahead for the same. is there any alternative function... Show More

      Hi All,

      autonumber with qlik partial load giving wrong results.

      can you please suggest how to go ahead for the same.

      is there any alternative functions that we can use for the partial load.

       

      thanks

      Show Less
    • forum

      App Development

      Creating multiple Columns from SQL dbo data source - to replicate this report fo...

      Hi  I'm trying to figure out how to create a table with all required columns in qlik sense from a sql dbo. This is what comes from the SQL report buil... Show More

      Hi 

      I'm trying to figure out how to create a table with all required columns in qlik sense from a sql dbo.

      This is what comes from the SQL report builder and pumped out:

      christopher76_1-1663927155639.jpeg

      The finance department want a 'like for like' App within Qlik Sense - as close to replicating the above format as posssible.

      However, I'm relatively new to Qlik and just can't seem to make it happen.

      The image below is a snapshot of what the App is looking like as I test dimensions and measures.:

      christopher76_0-1663927105250.jpeg

      But I just can't seem to achieve the right formatting to get 'Categories ' across the top.

      I would be enormously grateful for any input and help.

      Thank you

      Chris

       

       

      Show Less
    • forum

      New to Qlik Sense

      Best Document All in one

      Attaching document with reference to multiple topics of help

    Get Started On Community

    Start Here Get Started On Community

    Leaderboard

    Epsum factorial non deposit quid pro quo hic escorol.

    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