Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,134 online
Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

Data Analytics

Forums for Qlik Data Analytics 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

QlikWorld

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

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.

Ideation

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

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

    Connectivity & Data Prep

    Need guide on Connecting to hubspot using Qliksense REST connector

    Hi All, Sry to trouble you all. I have never used Qliksense REST connector to connect  to Hubspot, to pull date from  the dashboard in bubspot to qlik... Show More

    Hi All, 

    Sry to trouble you all. I have never used Qliksense REST connector to connect  to Hubspot, to pull date from  the dashboard in bubspot to qliksense. I encountered an issue which I need help on it. 

    1. This is the error I encountered:

    hubspot issue.PNG

    But I have already checked the "Check response type during 'Test Connection' ". Cannot figure out what is the cause of this. 

    hubspot3.PNG

    2. Below is my setting:

     

    hubspot2.PNG

     

    hubspot3.PNG

     

    hubspot4.PNG

     

    hubspot5.PNG

     

    hubspot7.PNG

     

     

    I followed the guide in this https://www.youtube.com/watch?v=FqwNU_pnFt4  . Can you anyone please advise me what should be the correct methods if the above are wrong?

    Questions:

    1. Is it because can't  use REST connection in qliksense to directly connect to hubspot?

    2. If point #1 is true, then is it need to create a REST API out of the dashboard in hubspot first, before utilising REST connection in qliksense to pull data out of dashboard in hubspot?

    Appreciate your help! Thank you.

    Regards, 

    XY Siang

     

     

    Show Less
  • forum

    Integration, Extension & APIs

    Pagination of hubspot deals API

    Hello People,I am really new to work with REST connectors on Qlik.I tried integrating Hubspot CRM deals API (https://api.hubapi.com/crm/v3/objects/dea... Show More

    Hello People,

    I am really new to work with REST connectors on Qlik.

    I tried integrating Hubspot CRM deals API (https://api.hubapi.com/crm/v3/objects/deals) using REST connector.

    More info about API endpoint ->Hubspot deals API 

    I also could paginate the API using the following parameters:

    • Pagination type: Next page
    • 'Next page' parameter name: after
    • 'Next page' initial value: 1
    • 'Page size' parameter name: limit
    • 'Page size' value: 100
    • Data indicator path :root/paging/next/after

    I hope these parameters are correct. Please check with me if I am wrong anywhere.

    Also after this when I try to load data the API works nearly for 1 hour (loading values) and gives me a 502 error
    (take a look at the attachment).

    This error is really often when I try to fetch data.

    Please let me know if someone can help me with this problem.

    Thank you very much.

    Neeraja

    Qlik Sense 

    Show Less
  • forum

    App Development

    Hubspot datamodel

    Hi,we are using Hubspot as our CRM and I want to use Qlik Sense to analyse the data in Hubspot. I can extract all the data using the REST API and buil... Show More

    Hi,

    we are using Hubspot as our CRM and I want to use Qlik Sense to analyse the data in Hubspot. I can extract all the data using the REST API and build a data model. Only this takes quite a bit of time and energy. As we have not customised Hubspot I wonder if anybody out there has gone through the pains of building a datamodel already. We only need the standard things.... mainly deals, contacts and companies.
    Please let me know should you be able to share a template.

    Thanks
    Mark

    Show Less
  • forum

    New to Qlik Sense

    filter with where clause

    am new to qlik and I am trying to filter my data set with where clause.example LoadVOYAGE,REFERENCE,JOU_FROM,JOU_TO,From XYZ_Table; so my question the... Show More

    am new to qlik and I am trying to filter my data set with 

    where clause.

    example 

    Load
    VOYAGE,
    REFERENCE,
    JOU_FROM,
    JOU_TO,

    From XYZ_Table;
     
    so my question they are different countries in JOU_FROM and JOU_TO. how could i Filter data 
    JOU_FROM like US* OR Like CA* AND JOU_TO NOT Like US* OR CA* to give all VOYAGES going out of Both countries. And also,
    JOU_FROM NOT LIke US* OR CA* AND LIKE US* OR CA* to give all VOYAGES going into both countries.
     
    Thanks i have been trying to get around this any tips would help.
    Thanks
    Ay.
     
     
    Show Less
  • forum

    New to Qlik Sense

    QlikSense Condition row colour deplay for value > 5

    HI, I am using Qliksense and I want to change row color red when a field called variance is > 5%. in pivot table.my pivot table has 4 dimension and 4 ... Show More

    HI, I am using Qliksense and I want to change row color red when a field called variance is > 5%. in pivot table.

    my pivot table has 4 dimension and 4 measure  and last measure is variance which will decide the color of row.

    please help, i could find better option to change it..

    Show Less
  • forum

    New to Qlik Sense

    Help to understand the use of pick and match function in qliksense script ?

    Spoiler (Highlight to read)Hi ,Please kindly help me to understand the below pick and match use in qliksense script.LOADMakeDate(Year("End Date"),Mont... Show More
    Spoiler
    Hi ,

    Please kindly help me to understand the below pick and match use in qliksense script.

    LOAD
    MakeDate(Year("End Date"),Month("End Date"),Day("End Date")) as ReportingDate,
    pick(match("Care Type",'1','6','7','11'),'1','4','5','M','') as care_type,
    1 as Measure;

    SQL SELECT
    End Date
    "Care_Type" as "Episode of Care Type",
    1 as Measure
    From
    Table



    regards




    Show Less
  • forum

    App Development

    Filter Specific Visual WITHOUT Alternate States

    My goal is to have multiple of the same filter on a page so that users can compare different values of the measure. Ex: User compares multiple locatio... Show More

    My goal is to have multiple of the same filter on a page so that users can compare different values of the measure. Ex: User compares multiple locations for housing and see's pros and cons. These filters should only impact specific visuals on the page.

    The key here is to NOT use Alternate States as I need to make the visuals a master item and that is a limited capability with alternate states.

    Show Less
  • forum

    New to Qlik Sense

    Date Format

     I need some help changing the below date format to 04/02/2021. 
  • forum

    QlikView App Dev

    Bookmark to current page using Document trigger

    Hi all,This is my scenario:I have set sheet triggers to select field values in every sheet.After hitting clear button,the triggers setting is also rem... Show More

    Hi all,

    This is my scenario:

    I have set sheet triggers to select field values in every sheet.After hitting clear button,the triggers setting is also removed and all values are seen which is not ideal.

    I refered the answer used in this question https://community.qlik.com/t5/QlikView-App-Dev/Clear-all-selections-removes-the-logic/td-p/1315902

    It solves the purpose of retaining the triggers ,however if I clik Clear button for eg on 3rd sheet,it automatically goes to 2nd sheet where the bookmark was created.

    Is there any way I can retain the trigger values and also remain on the same sheet ?

    Show Less
  • forum

    Security & Governance

    Section Access:access denied if user in custom sql server UserDirectory

    Hello,I have a user directory with AD domain users and a user directory with users in a sql table.The app includes following section access:SECTION AC... Show More

    Hello,

    I have a user directory with AD domain users and a user directory with users in a sql table.

    The app includes following section access:

    SECTION ACCESS;

    secAccess:
    LOAD * INLINE [
    ACCESS,NTNAME
    ADMIN,MYADDOMAIN\USER1
    ADMIN,MYADDOMAIN\USER2
    USER,SQLSERVERUSERDIRECTORY\USERSQL
    ];

    I openthe app with a ticket and AD domain I have no problems.

    When I try to acccess with the user in the SQLSERVERUSERDIRECTORY

    I get a "Access Denied" message.

    I see that USERSQL is among the users with SQLSERVERUSERDIRECTORY

    I set a rule to allow the SQLSERVERUSERDIRECTORY to login (so I don't get the PASS not avialable message anymore)

     

    Maybe I should try to write section access in a different way or what could I check?

     

     

     

    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

Online Conference

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

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