Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
862 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

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

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Discussion Boards and Documents for Qlik Services.

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

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

Recent Discussions

  • New to Qlik Sense

    Qliksense February 2020 bugs/upgrade issues

    Hi All,We are upgrading Qliksense September 2008 to Qliksense February 2020, NPrinting February 2020.Is there any document detail to know bugs of this... Show More

    Hi All,
    We are upgrading Qliksense September 2008 to Qliksense February 2020, NPrinting February 2020.
    Is there any document detail to know bugs of this version and work around documents.
    I tried on google but no luck.
    Please help me.
    Thanks in advance.

    Show Less
  • New to Qlik Sense

    View exported apps while not connected to enterprise server?

     In short my company has a Qlik sense enterprise license, due to our VPN setup you have to be in the office to be able to connect to this. Sometimes i... Show More

     

    In short my company has a Qlik sense enterprise license, due to our VPN setup you have to be in the office to be able to connect to this. 

    Sometimes i produce slide decks/reports over the weekend by exporting the apps i need an loading into Qlik sense desktop at home. With Qlik sense desktop going will there be any way for me to import apps to a version of Qlik while not connected to the enterprise server?

     

    Show Less
  • New to Qlik Sense

    Dimension from many excel sheets

    Hi, I'm facing an issue that I don't understand while building a Bar Chart. I am working with a database of Menus ordered during a cruise. I have 6 sh... Show More

    Hi, 

    I'm facing an issue that I don't understand while building a Bar Chart. I am working with a database of Menus ordered during a cruise. I have 6 sheets like the one one in the screenshot, representing 6 days of the week.1.PNG

    To simplify, they are 30 different menus, the sames each day. 

    For my bar chart, I've put as dimension =MenuTitleDinerDay1,

    and for Measures: =Count(MenuTitleDinerDay1)+Count(MenuTitleDinerDay2)+Count(MenuTitleDinerDay3)+Count(MenuTitleDinerDay4)+Count(MenuTitleDinerDay5)+Count(MenuTitleDinerDay6)

    I have a good looking result (Menus are sorted from the most ordered, and the total correspond to the total of orders), but I wanted to check and changed the dimension as =MenuTitleDinerDay2 and the bar chart changed: the first menus were different, but the total was still good. Basically, everytime I change the dimension from a day to another, the order of the menus change (and I thought it would always be the same as the dimension of day 1 is the same in day 2 for me..)

    I don't know if I'm very clear 😕 If someone has any ideas on how to fix that, I would be very pleased!

    Regards,

    Nicolas

    Show Less
  • Qlik Sense App Development

    How to make a group data issue

    Hi guys,I'm trying to do an app where I have the following table :where x has to be replace by 1,2 and 3 with a loop, to get this desired result :How ... Show More

    Hi guys,

    I'm trying to do an app where I have the following table :

    Group1.png

    where x has to be replace by 1,2 and 3 with a loop, to get this desired result :

    Group2.png

    How can I get this?

    As you can see, you can have 3 characters plus an X or 4 characters without the X and you have to do nothing because you have the complete group code of 4 digits.

    I've attached an excel table with the example

    Best regards, Marcel.

    Show Less
  • Qlik NPrinting Discussions

    NPrinting Task Execution call using Rest API throwing 403 Forbidden error

    Hi,We have recently migrated to NPrinting February 2020 SR1 version. Everything went smoothly and the server was up and running in no time. The only p... Show More

    Hi,

    We have recently migrated to NPrinting February 2020 SR1 version. Everything went smoothly and the server was up and running in no time. The only problem we are struggling to fix is the REST API calls to execute tasks.

    API call to login URL is working i.e. https://nprinting_server/api/v1/login/ntlm

     

    But all the other calls to URLs like the following giving me error "QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 403 (Forbidden)."  

    https://nprinting_server/api/v1/users or 

    https://nprinting_server/api/v1/tasks/430133d4-7ce7-4418-96f2-ef4112339d4b/executions

     

    Script code that I am using is as below:

    Please note that vCookie requires a little change after upgrade i.e. replace comma(,) with a semicolon(;) after the word Secure


    let vCookie = TextBetween('$(vCookieRaw)','Secure;','Path=/',2);

    let vPublshTaskURL = 'https://nprinting_server/api/v1/tasks/430133d4-7ce7-4418-96f2-ef4112339d4b/executions';

    RestNPTaskTriggerTable:
    SQL SELECT
    "__KEY_data"
    FROM JSON (wrap off) "data" PK "__KEY_data"
    WITH CONNECTION( URL "$(vPublshTaskURL)", HTTPHEADER "cookie" "$(vCookie)");
    [_post_items]:
    LOAD [__KEY_data] AS [__KEY_data]
    RESIDENT RestNPTaskTriggerTable
    WHERE NOT IsNull([__KEY_data]);
    DROP TABLE RestNPTaskTriggerTable;
    Server throwing error:

    QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 403 (Forbidden):
    The server refused to fulfill the request.

    I have checked the roles for user I am using to create the REST connection, which a domain user and has the Administrator role, everything looks alright.

     

    Is there any configuration I need to make on Nprinting server to allow resources to be used from other servers?

    Any suggestions to resolve the issue?

     

    Thanks,

    JM

    Show Less
  • Qlik NPrinting Discussions

    Getting 'some entities missing from connection cache' error after NP16 import

    I read the troubleshooting page and this is the solution: "Some entities used in the template are missing from the connection cache.To solve:Open the ... Show More

    I read the troubleshooting page and this is the solution:

     

    "Some entities used in the template are missing from the connection cache.

    To solve:

    Open the template in Qlik NPrinting Designer to get a detailed list of the missing entities.
    Solve the list by creating the missing entities in the source .qvw document. Or remove them from the template.
    Regenerate the connection cache."

     

    The problem is they do exist in the source, and work, and are integral to the report creation. The list of missing entities is quite large consisting of images and specific columns in table. I have checked some and they are very simple, one is literally just an expression '=[Field]'. So that should be compatible. I have tried reloading the metadata.

    Show Less
  • New to Qlik Sense

    How to Delete Sheets which are not used since 365 Days by Qlik Sense API or any ...

    Hi Techies,I have a use case where  I need to cleanse cleanse sheets which are not accessed or used by any user since 365 days. I can find such sheets... Show More

    Hi Techies,

    I have a use case where  I need to cleanse cleanse sheets which are not accessed or used by any user since 365 days. I can find such sheets information like ID from Operations Monitor application but I can't delete such sheets manually one by one. I am looking for a way to cleanse such sheets by any script or API. I was reading few articles I think it is possible by using App Integration API:

    https://help.qlik.com/en-US/sense-developer/February2020/Subsystems/APIs/Content/Sense_ClientAPIs/app-integration-api.htm

     

    Can I have such API script which I can run by Powershell or Postman which can cleanse sheets which havn't used since 365 days ? 

    Show Less
  • New to Qlik Sense

    Help with Gantt Chart in Qlik Sense

     I want to color task by task status or put the status label like the below screenshot but I did not know how . is there a way to do it  without using... Show More

     

    I want to color task by task status or put the status label like the below screenshot but I did not know how . is there a way to do it  without using extension?

     

    LabelLabelcolorcolor

     

     I created Gantt chart for a project using Qlik Sense with the help of this video Gantt Chart in Qlik Sense

    in the attachment Gantt chart and my data 

     

    Gannt chartGannt chartdatadata

     

     

     

     

    Show Less
  • New to Qlik Sense

    Qlik Sense - Set Analysis - Intersection Operator

    Hi everyone,I am trying to understand the operator part of the set analysis. I might have a silly example.My questions is as below:Is  this set analys... Show More

    Hi everyone,

    I am trying to understand the operator part of the set analysis. I might have a silly example.

    My questions is as below:

    Is  this set analysis ---> Sum( {$<[Company Name] = {'ABC'}> * $<[Company Name] = {'DEF'}> }  Sales )

    EQUIVALENT TO

    Sum( {$<[Company Name] = {'ABC'}>}  Sales) + Sum( {$<[Company Name] = {'DEF'}> }  Sales )

    If not, can anyone please explain is why it is not so?

    Thanks.

    Show Less
  • Qlik Sense App Development

    NPrinting APIs No Longer Working After Upgrading to NPrinting Nov 2019

    We just upgraded our NPrinting instance to the November 2019 version (SR1).  (Our Qlik version is also Nov 2019 - Patch 6.)  We had been using NPrinti... Show More

    We just upgraded our NPrinting instance to the November 2019 version (SR1).  (Our Qlik version is also Nov 2019 - Patch 6.)  We had been using NPrinting REST connections successfully prior to this upgrade to run NPrinting tasks using Qlik Sense load script.  Now, when we try to test the NPrinting Get and Post API connections, we're getting a 401 error: "HTTP protocol error 401 (Unauthorized): Requested resource requires authentication."

    We have verified every aspect of the connection settings: we're using Windows NTLM, using an NPrinting user that was created based on the Qlik service account, etc.  Like I said, all of this was working prior to the upgrade, but now it isn't.

    I've tested the URL we're using with a Chrome browser - and the URL is returning information successfully via Chrome.  But not with Qlik.

    We're out of ideas - and I'm not finding any posts out there with similar issues.  So any help from the Community would be much appreciated.

    Thanks!
    Steve

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

March 25, 2020 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

Now Available on Demand