Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,131 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.

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

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.

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

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.

Discussion Boards and Documents for Qlik Services.

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

    Profiling Card - Split Field in Data Manager Unavailable

    Hi all,I am not able to find Split field cards in my Qlik Sense app's Data Manager. Any help greatly appreciated,Thanks in Advance, 
  • Qlik Sense Integration, Extensions, & APIs

    Mashup table sort option

    Hi all,I created a table in QlikSense and use its hypercube to render it in a mashup.I would like to add the sort functionality, so that if I click on... Show More

    Hi all,

    I created a table in QlikSense and use its hypercube to render it in a mashup.

    I would like to add the sort functionality, so that if I click on the measure header it sort the table.

    I tried with "setOptions()" and "backendApi.applyPatches()" but I do not seem to be able to make it work.

    Can you help me?

    Show Less
  • Qlik NPrinting Discussions

    Error and warning messages in NPrinting 2020

    I wonder who designed the system 😫, which displays internal database codes instead of user-friendly information. Very poor implementation of messages... Show More

    I wonder who designed the system 😫, which displays internal database codes instead of user-friendly information. Very poor implementation of messages

    warning.PNG

     

    Show Less
  • Qlik NPrinting Discussions

    NPrinting ignores cell formatting

    Hi guys,I have this issue that I have tried to resolve myself for a week or two where the values of my straight tables are rendering in reports under ... Show More

    Hi guys,

    I have this issue that I have tried to resolve myself for a week or two where the values of my straight tables are rendering in reports under the 'General' format instead of what I have chosen. I have posted some screenshots to help explain:

    1. The qvw with the correct number format (some other tables will need to be a % or have different decimals). I have tried formatting in the expression itself as a workaround but it did not work. I can't select 'Keep source formatting' for this project.

    1.PNG

    2.  The structure of the Template. You can see the cell is formatted to number. The table will expand across 5 cells and each is formatted to replicate how it is seen in the qvw. Each row will be a different table.

    2.PNG

     

    3. The result. It has ignored the formatting of the expression and the template editor and reverted to 'General'.

    3.PNG

     

    I have browsed before posting this question but I could not see a resolution, there were some considered solved but it was for QlikSense, and one post assumed that this problem would be fixed in a newer version of NPrinting (I started this project in NP 16.7 and continued it in the Feb 2020 version).

     

    It might not mean much but I did a direct export from the table in the qvw to an excel file just in case the server settings was overruling it and it was matching the qvw.

    Show Less
  • New to Qlik Sense

    how to set up import from daily Excel files

    Need some advice on how best to set up data loading for my app. I have 2 Excel files that are generated each day. One is a list of patients seen in th... Show More

    Need some advice on how best to set up data loading for my app. I have 2 Excel files that are generated each day. One is a list of patients seen in the ED. The other is a list of floors where patients are admitted to. Each report has an ID number that is unique to the ED visit.

    When I first set up the app, I loaded patient list data for several days from an XLS file that had multiple tabs. Since then I've just been loading the new daily file. Everything seems to be working smoothly.

    My original plan was to just keep loading the new daily reports. I ran into trouble when I tried to do a left join in order to add the admission location to the patient list data. Is it better to set up an association based on the unique identifier field? Is there a better way to accomplish this?

     

    Thanks–

    Show Less
  • New to Qlik Sense

    Year on Year Change

    Hi,I have been searching the forums and my question has been asked multiple times but I can't get any of the answers to work even though my data looks... Show More

    Hi,

    I have been searching the forums and my question has been asked multiple times but I can't get any of the answers to work even though my data looks identical. I am trying to calculate the change between the 2013 and 2018 data for each Category and Area name. So for Europeans living in Linden, it is 1932 - 1842 = 90.  I have tried using variations of 

    sum({$<Year = {2018}>}[SA2-ethnic_group.Subtotal]) - sum({$<Year = {2013}>}[SA2-ethnic_group.Subtotal]) but that  I think will only work if my Years are in separate columns. The answer I get is 1932 for 2018 as it has no value for 2013. I tried "above" but the set expression seems invalid. Without the set expression, it just subtracts the figure above it and as my offset will vary, I cant specify an offset. Also tried creating a pivot table with Category as a column and Years/Subtotal as separate columns but it gave me the same answer.  

    Any help would be appreciated. Thanks, David

    Census Data.jpg

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Widget in Qlik Business

    I want to know how to work in Qlik Business with the Widgets that I developed in the DeskTop version. How can I copy the widgets to my space in Qlik B... Show More

    I want to know how to work in Qlik Business with the Widgets that I developed in the DeskTop version. How can I copy the widgets to my space in Qlik Business cloud?
    How do you do this?

    Show Less
  • New to Qlik Sense

    First Date Filter and Count

    Hello, I have a Contact Date field and a ClientID field - one ClientID can have many Contact Dates I would like to find the first contact date for eac... Show More

    Hello, 

    I have a Contact Date field and a ClientID field - one ClientID can have many Contact Dates 

    I would like to find the first contact date for each ClientID 

    Is this possible? 

    Thank you 

    Show Less
  • New to Qlik Sense

    firstsortedvalue with filters

    I read many other posts, but I can't apply it to my case... I think "firstsortedvalue" might be the solution. Here's my Data (I gave my best to get a ... Show More

    I read many other posts, but I can't apply it to my case...

     

    I think "firstsortedvalue" might be the solution.

     

    Here's my Data (I gave my best to get a good example):

    #Reporting PlantMaterial NumberMaterial DescriptionDirect Savings YearInvoice Amount CHFInvoice QuantityDiff. prev. YearCalc. Direct Savings CHFSavings / CostVendor Category
    1Germany12345Apple2019                          480’250.86163’681-0.4802                               -115’571.35SavingsR
    2Germany12345Apple2019                              3’952.291’125-0.4802                               -115’571.35SavingsM
    3Germany12345Apple2018                          694’002.40240’158-0.4802                               -115’571.35SavingsR
    4Germany12345Apple2018                                  940.13503-0.4802                               -115’571.35SavingsM

     

    What do I want to do:

    There are multiple same values for "Calc. Direct Savings CHF", but I only want to see the "Vendor Category", based/ranked on the <highest> "Invoice Amount CHF" per "Direct Savings Year"

     

    Example:

    #1, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2019 is higher than #2

    #3, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2018 is higher than #4

     

    Finally, out of the 4 lines, only 2 shall remain --> #1 & #3

     

    hope this makes sense!

    Thanks already 🙂

    Show Less
  • New to Qlik Sense

    Retornar a soma do mês anterior

    Boa noite comunidade,preciso de uma ajuda no seguinte cenário.Tenho um filtro MesAno: MM/YYYYTenho uma tabela com valores e datas, preciso montar gráf... Show More

    Boa noite comunidade,

    preciso de uma ajuda no seguinte cenário.

    Tenho um filtro MesAno: MM/YYYY

    Tenho uma tabela com valores e datas, preciso montar gráfico de linhas, onde a dimensão será o dia de cada data.

    E as medidas serão: sum(valor) em cima do filtro selecionado e também preciso de uma medida do sum(Valor) dos dias do Mês anterior.

    Como resultado o gráfico terá duas linhas, um somatórios dos valores do mes selecionado e outro do mês anterior ao selecionado..

    Como posso fazer isso?

     

     

     

    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.

On Demand Webinar

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

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