Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,662 online
Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video

Data Analytics Forums

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

Data Integration Forums

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

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.

Qlik Gallery

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

Product Insight & Ideas

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

Qlik Resources

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

Events

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About Qlik Community

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    Qlik NPrinting Discussions

    On Demand API Working but not passing user selections

    Hi, I'm successfully able to trigger on OnDemand Report using the API from a Javascript action using the following code :function(){    var data = JSO... Show More

    Hi,

     

    I'm successfully able to trigger on OnDemand Report using the API from a Javascript action using the following code :

    function(){   

    var data = JSON.stringify({"type":"report","config":{"reportId":"87d35c6-0b10-201p-edf5-7239562219e2","outputFormat":"PDF"}});

    var xhr = new XMLHttpRequest();

    xhr.open("POST", "https://mynprintserver.com/api/v1/ondemand/requests");
    xhr.withCredentials = true;
    xhr.setRequestHeader("Content-Type", "application/json");
    xhr.send(data);
     
      }   

    Can any help with the code for passing any user selections across also? 

     

    Many thanks,

     

    Dai

    Show Less
  • forum

    New to Qlik Sense

    Diagram for meanvalue of participants per day for a month

    I have a setup of values in a table that looks like this, but with more rows:test1:LOAD * INLINE [Participant, Datea, 2020-12-07a,2020-12-08a, 2020-12... Show More

    I have a setup of values in a table that looks like this, but with more rows:

    test1:
    LOAD * INLINE [
    Participant, Date
    a, 2020-12-07
    a,2020-12-08
    a, 2020-12-09
    b, 2020-12-07
    b, 2020-12-09
    c, 2020-12-08
    c, 2020-12-09
    c, 2020-12-10
    d, 2020-12-10
    e, 2020-12-07
    ]
    ;

    I want to make a bar diagram that shows the mean paticipants per day for a whole month. I can count participation per day, but not the mean value for the month.

    Show Less
  • forum

    New to Qlik Sense

    Sum with Set analysis Issue

    Hi,Feeling very silly right now but cannot get the simplest thing to work i have done so much.Please can anyone tell me why i can sum TotalQty and add... Show More

    Hi,

    Feeling very silly right now but cannot get the simplest thing to work i have done so much.

    Please can anyone tell me why i can sum TotalQty and add the dimension MergeFibre and get the breakdown but when i add a value from the MergeFibre Field 'OtherMaterials' as set analysis in the sum i get a zero on that line?

    Thanks. I am gong blind looking at this, it makes no sense.

     

    davyqliks_0-1611661737566.png

     

    Show Less
  • forum

    Qlik Sense App Development

    An Error Occurred Access is denied

    Hello Everyone,I'm new to QS, but seasoned in QV.  I have migrated my first QS app to the cloud.  I am not using Section Access.  I have published it ... Show More

    Hello Everyone,

    I'm new to QS, but seasoned in QV.  I have migrated my first QS app to the cloud.  I am not using Section Access.  I have published it to a stream called Human Resources and have assigned my users to that stream.  When I open the app in the cloud I get the message "An Error Occurred - Access is denied".  I can click on the close button and proceed around the app.  It only happens on the first screen.  Any ideas what I might be missing?

     

    7986918e-51e0-4ace-a703-6799ff7d8a40.jpg

    Show Less
  • forum

    Qlik NPrinting Discussions

    Qlik Nprinting Levels

    Hi,I am using Printing 18.0.1 version in designer and server.I need to create table details in Nprinting  which same as my Qlik Sense App (3+ version)... Show More

    Hi,

    I am using Printing 18.0.1 version in designer and server.I need to create table details in Nprinting  which same as my Qlik Sense App (3+ version).I cant get the completed table data in NPrinting in details level.When i am checked in community We need to add the object levels for getting detail reports.

    NPrinting 17 - pixel perfect levels

    but in my designer i try to search the table objects in Levels .There is no object is showing  me.but those objects i can add in Table objects.

    Please help me is there any bug present in my tool for not showing the tables objects in Levels.

    Show Less
  • forum

    Qlik Sense Data Connectivity

    Mongodb Connection failing in November 2020 Patch 2

    Hi there,We recently upgraded to Qliksense November 2020 Patch 2 from Qliksense June 2020.  We had a MongoDB connection running prior to the upgrade. ... Show More

    Hi there,

    We recently upgraded to Qliksense November 2020 Patch 2 from Qliksense June 2020.  We had a MongoDB connection running prior to the upgrade.  After the upgrade, the extract started crashing.  When I tried to test the connection, I got the following error:

    ERROR [HY000] [Qlik][MongoDBODBC] (110) Error from MongoDB Client: Authentication failed. (Error Code: 11)

    I tested this on an older version of Sense and had no issues.  I see that changes have been made to the connector where more parameters are available, but don't see anything in the docs about changed behaviour.  Is this a bug, or do I need to adjust something on the config of this connection?

    Show Less
  • forum

    New to Qlik Sense

    new Hover menu on filters in Nov 2020

    Hello,I upgraded from Qlik Feb 2019 to Qlik Nov 2020.  I have noticed a new hover menu that appears larger on my filters, etc.The solution is to disab... Show More

    Hello,

    I upgraded from Qlik Feb 2019 to Qlik Nov 2020.  I have noticed a new hover menu that appears larger on my filters, etc.

    The solution is to disable the Hover Menu for each filter.  I need to now review all my Dashboards and change this setting.

    Has anyone else experienced this new feature?  I find that the larger hover menu with the additional option interferes with users making selections.

     

    Thank You,

    Michael

    Show Less
  • forum

    Qlik NPrinting Discussions

    Using NPrinting API in QlikSense - GET Filters

    I am trying to get the table with all my current filters and their values.  I have already gotten to the point of pulling all my users, and their corr... Show More

    I am trying to get the table with all my current filters and their values. 

     

    I have already gotten to the point of pulling all my users, and their corresponding filter selections, but getting the values of those filters is eluding me. 

     

    Does anyone have a sample script for pulling the nested fields / values tables from the filters data?

     

     

    RestConnectionMasterTable:
    SQL SELECT
    "__KEY_data",
    (SELECT
    	"id" ,
    	"name",
        "description",
        "enabled",
        "appId",
        "connectionId"
    FROM "items" FK "__FK_items")
    FROM JSON (wrap off) "data" PK "__KEY_data"
    WITH CONNECTION( URL "https://qlik-nprint.mycompany.cloud:4993/api/v1/filters", HTTPHEADER "cookie" "$(vCookie)",QUERY "Limit" "10000") );
    
    
    NPrint_Filters:
    NoConcatenate LOAD 
    *
    RESIDENT RestConnectionMasterTable;
    drop table RestConnectionMasterTable;

     

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Need help on a security rule to prevent professionals from editing *public* shee...

    Hi all,I need some help with creating a security rule or changing an existing security rule.Somehow, all professional users can edit the public sheets... Show More

    Hi all,

    I need some help with creating a security rule or changing an existing security rule.
    Somehow, all professional users can edit the public sheets in our published apps.
    All our public sheets have been approved, so in order to prevent (accidental) edits we require professional users to only be able to edit their own and community sheets.

    Furthermore, they should also be able to copy public sheets.

    Can anyone help me with the security rule that complies with these requirements?

    With kind regards,

    Martijn

    Show Less
  • forum

    Qlik Sense App Development

    giving credit for a new customer only to the salesperson who made the first sale

    Hello,I am analysing new customers brought in to the company for a specific product range.The goal is to determine which sales person made the 1st sal... Show More

    Hello,

    I am analysing new customers brought in to the company for a specific product range.

    The goal is to determine which sales person made the 1st sale within the criteria and give him/her 1 point per new customer. 

    Dimensions: Product type, Customer, Salesperson

    Range: Current Month/Year vs Previous Month/Year

    Lets say we have 3 different product types.

    If the customer did not buy anything last year within these product types, but bought it this year, then give +1 to the sales person who made the 1st sale this year. 

    My current issue is correctly assigning the point to the salesperson with the first sale.

    Code example below for MTD:

    Aggr(Sum({$<Year={"$(=Max(Year))"}
    ,Month={"$(=Only(Month))"},[Product_Type]={'Heater'}
    ,ProductDriver={'=Sum({$<Year={"$(=Max(Year))"},Month={"$(=Only(Month))"}>}
    Aggr(Sum({$<Year={"$(=Max(Year))"},Month={"$(=Only(Month))"}>} InvoiceValue_),ProductDriver))>0'}
    ,Customer_KEY = E({<Year={'$(=Max(Year))-1'},Month={"$(=Only(Month))"}
    ,[Product_Type]={'Heater'}
    ,ProductDriver={'=Sum({$<Year={"$(=Max(Year))-1"},Month={"$(=Only(Month))"}>}
    Aggr(Sum({$<Year={"$(=Max(Year))-1"},Month={"$(=Only(Month))"}>} InvoiceValue_),ProductDriver))>0'}>} Customer_KEY)
    >}Customer_Count),Customer_KEY,[Doc Created By])

    Attached current result vs expected.

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

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

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

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

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand