Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 176,132 members
  • 5,813 online
  • 1,725,525 posts
  • 131,725 Solutions
  • Announcements
    CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW

    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

      Alerting

      Web Connectors

      Tem como ao mandar email com o Web Connectors, escolher o email e mudar o texto pegando um campo do painel? 
    • forum

      New to Qlik Sense

      Qlik Data Gateway Direct access

      Hello.the data I use in Qlik Sense Saas is on Premise on a Microsoft Sql server. I am currently using Qlik Data Transfer to transfer the tables to be ... Show More

      Hello.
      the data I use in Qlik Sense Saas is on Premise on a Microsoft Sql server. I am currently using Qlik Data Transfer to transfer the tables to be analyzed to the cloud.
      I honestly find QDT poso practical as it is not editable after creation and you cannot see which fields you have transferred to the cloud.
      I don't want to use <FORTS> for economic reasons and would like to try QLIK DATA GATEWAY DIRECT ACCESS.
      It can be used ?
      Are there any contraindications?
      Can it do the same job as Qlik Data Transfer?
      Generally the tables to be analyzed by space are approx. 100 and generally resident in a single Micorsoft SQL database.
      at the date, then, these data are the subject of a qlikview PE apps.
      Could I also transfer the entire QlikView apps? But then, how do I update the data?
      Sorry for the inconvenience.
      Can you help me choose the best path?
      thanks again in advance.
      Hello everybody.

      Show Less
    • forum

      New to Qlik Sense

      NULL Symbol

      how to eliminate the very ugly '-' ,NULL or Missing symbol, from displaying a measure in a table, at a graphic and non-script level.
    • forum

      New to Qlik Sense

      Sum values based on the max of another field

      I'm trying to sum the quantity of based on the most recent activity. For example using the chart below sum the qty for each campaign based on the hig... Show More

      I'm trying to sum the quantity of based on the most recent activity. For example using the chart below sum the qty for each campaign based on the highest "purchased period" only.

      Campaign Purchase period Qty

      A 30 10

      A 30 5

      B 30 20

      B 60 30

      C 30 20

      C 60 30

      C 90 40

      Answer should be:

      A = 15

      B = 30

      C = 40

      Show Less
    • forum

      QlikView App Dev

      Exclude certain values from a dimension, to not show, without supressing zero va...

      I have a table - example attached- from which I want to exclude from being seen two Payor IDs (as an example, let's say, do not display Payor ID's 2 a... Show More

      I have a table - example attached- from which I want to exclude from being seen two Payor IDs (as an example, let's say, do not display Payor ID's 2 and 3). I do not know how to do this. I do not want to make them null and supress zero values. From what I've seen, in Qlik View, when you choose Supress zero/null values, it applies to the whole table, not the values in a field, even when you highlight it in the "Presentation" tab. If anyone can help me with a solution, thank you in advance.Exclude multiple values of a dimensionExclude multiple values of a dimension

      Show Less
    • forum

      App Development

      not affected by filtering

      Hello, I have 2 different files named 'Previous' and 'Current' where I get my data. I have defined 1 as Deleted_Flag in my script load editor to help ... Show More

      Hello,

      I have 2 different files named 'Previous' and 'Current' where I get my data.

      I have defined 1 as Deleted_Flag in my script load editor to help understand where my data comes from.

      In the below script, I am aiming to count the SKU Name if it's exist only in the file called 'Current'.

      =count(if(aggr(sum(Deleted_Flag), [SKU Name])=1 and [Current or Previous]='Current', [SKU Name]))

      It works, but it's affected by user selection. I want to have an exact value in there and it should not be affected any selection. I know we can use {1} as amodifier in set analysis but I couldn't adopt this script to set analysis format.

      Could you please advise me how can I avoid any user selection?

      Thanks

      Show Less
    • forum

      Qlik Replicate

      The DR mechanism of Qlik Replicate

      How does Qlik Replicate perform Disaster recovery procedure? if we pre-created a secondary Qlik Replicate in DR region, how to synchronize the Configu... Show More

      How does Qlik Replicate perform Disaster recovery procedure? if we pre-created a secondary Qlik Replicate in DR region, how to synchronize the Configuration on primary region to DR region?

      Show Less
    • forum

      Integration, Extension & APIs

      Insert powerbi/image in mashup

      Is there any way to insert a powerbi graphic without being via iframe editing directly in the source code? I wanted something similar to what exists t... Show More

      Is there any way to insert a powerbi graphic without being via iframe editing directly in the source code? I wanted something similar to what exists today in sharepoint.

      In sharepoint, just select the power bi option and enter the url.

      powerbi-sharepoint-new-web-part.png

      Another option is also if it would be possible to insert an image without being via source code, like a drag and drop function.

      Show Less
    • forum

      Integration, Extension & APIs

      How to automatically start NPrinting Publish Tasks after reload Qlik Sense apps

      How to automatically start NPrinting Publish Tasks after reload Qlik Sense apps. Need some help how to configure for serveral QlikSense apps
    • forum

      App Development

      How to combine record from resident table into SQL where clause to another DB

      Hello,in a table I have a list of products. PRODUCT:LOAD DISTINCT AUG_COD_IMPRESIDENT QLIK_PRODUCT_TABLE; I should use these product codes to filter a... Show More

      Hello,
      in a table I have a list of products.

      PRODUCT:
      LOAD DISTINCT AUG_COD_IMP
      RESIDENT QLIK_PRODUCT_TABLE;

      I should use these product codes to filter an extractions towards an oracle DB.

      However, by inserting the records as a join or in the where clause, the system looks for the qlik table in the oracle db and then returns the error as "table not found".

      LIB CONNECT TO 'DB_ORDER';

      ORDERS:
      SELECT
      AUG_COD_IMP,
      HTM_DATA_CAMPIONAMENTO,
      FROM TELEMISURA inner join PRODUCT l on (l.AUG_COD_IMP = AUG_COD_IMP)
      WHERE 1=1
      ;

      How can I insert the record from qlik table into the sql query in order to avoid the extraction of the whole db?

      THANKS

      Show Less

    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