Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,617 online
Announcements
Join us at the Cloud Data and Analytics Tour! 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

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.

Events

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

Qlik Academic Program

Enabling professors and students with data and analytics.

About

Get started, 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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    Connectivity & Data Prep

    How to join multiple tables while maintaining parent and child relationship

    Hello Qlik Experts,I m trying to combine multiple table while maintaining relationship between them. How should i achieve this? PFA data model for ref... Show More

    Hello Qlik Experts,

    I m trying to combine multiple table while maintaining relationship between them. How should i achieve this? PFA data model for reference

    Omkar13_0-1623212242818.png

     

    Show Less
  • forum

    Brasil

    Criar uma variável a partir de uma seleção

    Boa noite,Meu objetivo é criar uma variável que receba valores diferentes a partir das escolhas no painel de filtro da figura abaixo. Essa variável as... Show More

    Boa noite,

    Meu objetivo é criar uma variável que receba valores diferentes a partir das escolhas no painel de filtro da figura abaixo. Essa variável assumiria por exemplo, os seguintes valores:

    Se o usuário escolher Despesa de Pessoal e Despesa Discricionária, "PD";
    Se o usuário escolher Despesa de Pessoal e Despesa Compromissada, "PC";
    Se o usuário escolher Despesa de Discricionária e Despesa Compromissada, "DC, e assim sucessivamente.

    Quero utilizar essa variável em uma expressão de cálculo em uma tabela dinâmica. Tentei utilizar a função "Set" para criar variáveis mas parece que só é disponível no script.

    É possível fazer isso?

    Obrigado,
    Gustavo

    Qlik - Captura Painel de Filtro.JPG

     

    Show Less
  • forum

    New to Qlik Sense

    How to compare columns from two unrelated tables

    Hello experts, I am new to qlik and I need to compare multiple columns from two unrelated tables to produce a column with dynamic outcomes. Both of my... Show More

    Hello experts, I am new to qlik and I need to compare multiple columns from two unrelated tables to produce a column with dynamic outcomes. 

    Both of my tables have millions of records, so I can't do a cartesian join. 

    Table 1: travel_desitnation

    Table 2: available_destinations

    Input: user can select 1 or more destinations from table 1

    Output: score each rows in table 2 to determine the proximity of its destination to the input destination(2) 

    Please see example in attachment. Thank you in advance!  

     

    Show Less
  • forum

    New to Qlik Sense

    Improve App Overview to like PowerPoint Slide Sorter

    Does anyone know of an extension or other option that makes the App Overview look more like a Power Point slide sorter.  I have an older user who is s... Show More

    Does anyone know of an extension or other option that makes the App Overview look more like a Power Point slide sorter.  I have an older user who is struggling using Qlik Sense and developing a story or message without resorting to printing all the sheets and rearranging them manually and then having someone else putting the sheets in the same order in the app as they are on paper.

    Show Less
  • forum

    New to Qlik Sense

    box plot handling of null and zero values

    We are using box plots to look at a small (700 value) dataset.  We want to exclude values that are either null or zero.  What is the best way to achie... Show More

    We are using box plots to look at a small (700 value) dataset.  

    We want to exclude values that are either null or zero.  

    What is the best way to achieve this?  

    Show Less
  • forum

    Community Corner

    correct the highlighter error and try again - community error

    Hi @Sue_Macaluso , @Melissa_Potvin Error from the screenshot drives me crazy. All content was written using controlls available in message editor. The... Show More

    Hi @Sue_Macaluso , @Melissa_Potvin 

    Error from the screenshot drives me crazy. All content was written using controlls available in message editor. Then you when you want to publish message it screams: "correct the highlighted errors and try again", but there is no highlighter error... There is message at the bottom " Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied."

    I am sattisified so When I click to post it again it shows the same error again... and again... and then since I tried couple of times it thinks I am posting the same message few times and blocks me from posting it at all

    "Correct the highlighted errors and try again.Post flooding detected (user tried to post more than 2 messages within 5 seconds)"

    It happens so often that it puts me off from community as I am spending time to write something, but then I am unable to post it...

     

    I dont get why would I get the first error since I wrote everything without any copy/pase, I just logged on to new session on community etc...

    Could you please comment on that?

    Thanks Lech!

     

     

    1.png2.png

     

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Qlik Printing sends blank KPI in email

    The nPrinting email drops off/sends blank KPI chart. This is not occurring regularly but this had happened once  in 2 different nprinting emails that ... Show More

    The nPrinting email drops off/sends blank KPI chart. This is not occurring regularly but this had happened once  in 2 different nprinting emails that pulls data from 2 different Qliksense apps. 

    The task execution looks fine.  only thing that is common is that they both are KPI charts and doesn't have any filter applied on them.

    does anyone had experienced this before? any recommendations to solve this issue? 

    @Nicole-Smith

    Show Less
  • forum

    Qlik NPrinting Discussions

    Send report with NPrinting November 2020 to FTP

    Hi,It's possible send report generate from NPrinting November 2020 directly to FTP? Best regards,Sr. Esneider,
  • forum

    New to Qlik Sense

    Splitting Quarter data into trailing 13 months and getting columns for month and...

    I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for th... Show More

    I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for the quarter data. So I need the columns 'Monthstart()' and 'Yearstart()' Please help!

     

    Original formula for Quarter data column

    =SUM(IF(QUARTERSTART(OT_Period)='10/01/2020',OT_Overtime_YTD))

     

    The 'OT_Overtime_YTD' is the dollar amounts. Essentially the columns would be. 

     

    Region/Location/Employee/Monthstart()/Yearstart()

     

     

    Show Less
  • forum

    Deployment & Management

    Sheet Actions Not Working

    We are trying to set up an action on sheet to 'select values in a field' - the action should be that when the sheet is opened the current 'Month-Year'... Show More

    We are trying to set up an action on sheet to 'select values in a field' - the action should be that when the sheet is opened the current 'Month-Year' is selected from the MonthYear field - but it does not currently work.

    We are using the formula Date(Today(),'MMM-YYYY') to find today's Month-Year, this returns the value 'Mar-2021', and we can see that we have a value of 'Mar-2021' in our MonthYear field. When we close the app and reopen, or just navigate away from the sheet and then back to it, the selection is not applied.

    We have tried replacing the formula with a hard-coded text string  of 'Mar-2021' and this also does not work.

    Has anyone else experienced this issue in SaaS?

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

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.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region