Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,719 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

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

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

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.

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

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.

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

    New to Qlik Sense

    Change the language of Qlik sense

    Hello. How do I change the language of qlik Sense? I uninstalled it and installed it again but it did not give me the option to choose another languag... Show More

    Hello. How do I change the language of qlik Sense? 

    I uninstalled it and installed it again but it did not give me the option to choose another language

    thanks!

    Show Less
  • forum

    App Development

    Cell color export to excel

    Dear Qlik users,is it possible to use a function in Qlik Sense which, once I export a table to Excel, colors Excel cells?I tried to use the color func... Show More

    Dear Qlik users,

    is it possible to use a function in Qlik Sense which, once I export a table to Excel, colors Excel cells?

    I tried to use the color functions like blue() but the result in Excel is a text like this RGB(255,255,0).

    Thank you in advance for your help.

    Show Less
  • forum

    New to Qlik Sense

    Yearfrac function in Qlik Sense

    Hi I am calculating employee service length which respects time dimension, so that if past date is selected in a chart, the service length is reduced ... Show More

    Hi 

    I am calculating employee service length which respects time dimension, so that if past date is selected in a chart, the service length is reduced accordingly for the length at that point in time.  I am currently dividing the number of days at a point in time minus hiring date by 365 in order to convert the number of days into number of years in decimal, but as the number of days in a year varies between year to year with leap year having 366 days and normal years having 365, the calculation below is not correct.  Please could you let me know an equivalent function with Yearfrac in Excel so that I can accurately calculate the employee service years? 

    Newbie7_0-1632628542300.png

    Thank a lot for your help.

     

    Show Less
  • forum

    New to Qlik Sense

    Fixed the length and structure

    Hi All,I have a table where I just want that my table should only contain the ID column value in the proper structure which include first five with al... Show More

    Hi All,

    I have a table where I just want that my table should only contain the ID column value in the proper structure which include first five with alphabet next three should be numeric and end with an alphabet so total length is 9, so as per below table I should only fetch the data for 4 rows (Name1,4,7 and Name10) only in a table. Please advise how to achieve this.

    NameID
    NAME1ASDFL302T
    NAME2ERRDSKFDFFDFG
    NAME3ADSF
    NAME4LKJGH786F
    NAME5456SDFFJG
    NAME6T567LKHDD
    NAME7ASERF987G
    NAME8855898RREWRER
    NAME9WQEREWT3
    NAME10BJHGC456P

     

    Thanks

    Sunil Kumar

    Show Less
  • forum

    App Development

    Qlik Sense Mashup - export multiple tables to excel

    I was wondering if anyone else has found a solution to do this? We wanted to export multiple tables to one excel file, on separate tabs.
  • forum

    New to Qlik Sense

    Export multiple sheets in QlikSense to Excel

    Hi thereJust wondering if it is possible to export tables on multiple sheets in QlikSense to a single excel document with the tables appearing on sepa... Show More

    Hi there

    Just wondering if it is possible to export tables on multiple sheets in QlikSense to a single excel document with the tables appearing on separate tabs?

    I know this is possible in QlikView using a macro but just wondering if it can be done with a macro or similar in QlikSense?

    Thanks

    Shara

    Show Less
  • forum

    App Development

    Exporting multiple tables or hypercubes in single excel file through Qliksense

    Hi,I have a requirement where we need to export multiple tables or hypercubes in QlikSense. I have tried using the Exportdata function in Table API av... Show More

    Hi,

    I have a requirement where we need to export multiple tables or hypercubes in QlikSense. I have tried using the Exportdata function in Table API available in Qliksense but was able to export a single table only.

    Example of using exportData method

    Can anyone please suggest any method to achieve this in Qliksense

    Regards,

    Bhargav

    Show Less
  • forum

    New to Qlik Sense

    Graphique en secteur

    Bonjour la communauté,Je souhaite avoir la visualisation suivante: Voici mon modèle de données:Article= 411,444,668,987 (une liste de code)Total= '999... Show More

    Bonjour la communauté,

    Je souhaite avoir la visualisation suivante:

     

    kangkaw_0-1632499802800.png

    Voici mon modèle de données:

    Article= 411,444,668,987 (une liste de code)

    Total= '999999999'

    PC=222,333,444,555,888 ( une liste de code)

    date= JJ/DD/AAAA

    l'idée est d'avoir la somme de créance pour les compte où le PCG=411 et ayant 

    l'idée est de connaitre pour l'article 411  la répartition des sommes  pour lesquelles un PC est compris dans la liste.

     

    Par exemple, si je prends 2 client:

    Client 1 Total = 50 € et PC= 333,444,777

    Client2  Total = 100 € et PC = 444,999,777

    Client3 Total = 150 € et non compris dans la liste des PC

    Client3 Total = 300 € et non compris dans la liste des PC

    kangkaw_0-1632499802800.png

     

    j'ai utiliser la formule suivante pour la mesure avec PC ou sans PC: 

    Sum({$<article={411}>+1<PC={333,666,888}>} TOTAL) 

    et article en dimension mais je n'ai pas le résultat souhaité.

     

    avez vous des proposition.

    Merci

     

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Gauge from Qlik sense into Nprinting

    Hi,I am having an issue with gauge imported from Qlik Sense into Nprinting.In QS, my gauge looks like that:I imported it as an image but when I print ... Show More

    Hi,

    I am having an issue with gauge imported from Qlik Sense into Nprinting.

    In QS, my gauge looks like that:

    gerald_lebret_0-1632648952800.png

    I imported it as an image but when I print it out into pdf, it does not seem to be working. The value of the measure is not shown and it looks like that:

    gerald_lebret_1-1632649062143.png

    Can anyone help me please?

    Thank you.

    Gerald

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Calculated fields result not showing in reports

    Hi all,I am pretty new to Nprinting and need someone's help.I am using pixel perfect to create a report.I have created a lot of calculated fields that... Show More

    Hi all,

    I am pretty new to Nprinting and need someone's help.

    I am using pixel perfect to create a report.

    I have created a lot of calculated fields that I want to use in a table.

    For instance, I have a formula for the number of days in january and a formula with the sales for january. Then I created a calculated field to calculate the sales/day.

    For some reason, If I add into my table the 2 formulas and the calculated field. It works fine.

    However, if I only show the calculated fields, it does not appear at all.

    Can anyone please help? I am a bit stuck.

    I also have a problem because whenever the result of a calculated field = 0, Nprinting report shows blank and not 0

    The first problem is the most important one and any help would be highly appreciated.

    Thank you.

    Best regards.

    Gerald

     

    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