Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,808 online
Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video

Data Analytics Forums

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration Forums

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.

Product Insight & Ideas

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 Qlik Community

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

    New to Qlik Sense

    Show in a Qlik table only the first 5 Company with the biggest values

    Hi all, I am looking for a set analysis in order to show in a table only the first 5 company with the biggest (max) values. Company  ValuesA          ... Show More

    Hi all, 

    I am looking for a set analysis in order to show in a table only the first 5 company with the biggest (max) values. 

    Company  Values

    A                   100

    B                   99

    C                  99

    D                 97

    E                96

     

    All the rest of the companies shouldn't showing up, 

    Thank you for any help 

     

    Best

    Show Less
  • forum

    Qlik NPrinting Discussions

    Nprinting not recognizing the alternative Measures and Dimensions from Qlik sens...

    Dear Team,We have few pie charts from Qlik sense which has alternative measures and we need to use those alternative measures in the Nprinting reports... Show More

    Dear Team,


    We have few pie charts from Qlik sense which has alternative measures and we need to use those alternative measures in the Nprinting reports. When generating the report in Nprinting through Edit template option, it is not displaying the alternative measure in the Template Editor. Any idea on how to get this done.


    Thanks in Advance...

    Malick

    Show Less
  • forum

    Search the Community

    How to Calculate Stock Coverage for months with the available sales targets

    Can anyone tell me how to find stock coverage for months, for example:MonthsjanfebmaraprSales Targets15564 For instance when we are talking about the ... Show More

    Can anyone tell me how to find stock coverage for months, for example:

    Monthsjanfebmarapr
    Sales Targets15564

     

    For instance when we are talking about the month Jan where stock is 30.

    Monthsjanfebmarapr
    Sales Targets15564
    Remaining stock after using15104-26

     

    Hence when forecasting stock we find that when we reach April we are deficit by -26 units.

    So I would like to show a formula that divides the remaining stock (i.e 4 in march) by the total stock initially available in Jan (i.e 30 ) to give a value of 0.14.

     

    and this 0.14 gets added to the 3 months (JAN, FEB and MAR) where the initial 30 unit stocks lasted.

    Which means in total we get 3.14 (i.e the number the months the stock will last given the parameters)

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Transitive relationship

    Hello, i have a question regarding scripting in QS.Lets say I have a table temp. [temp]:Load * inline [Employee, Boss100, 105177, 180105, 911400, 402]... Show More

    Hello, 

    i have a question regarding scripting in QS.

    Lets say I have a table temp. 

    [temp]:
    Load * inline [
    Employee, Boss
    100, 105
    177, 180
    105, 911
    400, 402
    ];

    I want to pair all possible relationship. The result should look like this:

    Load * inline [
    Employee, Boss
    100, 105
    177, 180
    105, 911
    400, 402
    100, 911];

    So in my example 100 -> 105 and 105 -> 911 means that people with the Ids 100 and 911 are in such a relationship. So I want their number to be listed in my result table.

    Hope u can help me.

    Best regards

    Phan Thanh Son

     

    Show Less
  • forum

    Qlik Sense App Development

    Concatenated column within table

    Hi all,I need some help please.I have three source tables: Asset, Component and Assessment. An asset is related to multiple components and an assessme... Show More

    Hi all,

    I need some help please.

    I have three source tables: Asset, Component and Assessment. An asset is related to multiple components and an assessment is linked one a single asset. 

    I've displayed a number of fields in the table from assessment and asset. I would like to add a column with all of the related components but I can't figure out how to do it. It's always displays as blank.

    Any ideas would be greatly appreciated. I've attached a screenshot.

    Show Less
  • forum

    Groupe des Utilisateurs Francophones

    durée entre deux dates dans un même champs pour calcul taux d'utilisation

    Bonjour,j'ai des Messages d'erreurs HTML tout le temps qui me rends fou pour poster une demande sur ce forum donc je vous prends un screen de ma deman... Show More

    Bonjour,

    j'ai des Messages d'erreurs HTML tout le temps qui me rends fou pour poster une demande sur ce forum donc je vous prends un screen de ma demande car c'est incompréhensible le problème HTML que j'ai.

     

    Merci de regarder directement en PJ.

     

    Bonne journée et merci

    Show Less
  • forum

    Qlik Sense App Development

    Qlik Sense February 2021 - Merge functionality

    Hi all,Qlik Sense February 2021 has  a new functionality, regarding the Qlik Sense Engine, that is call Merge, can someone explain how it works?Below ... Show More

    Hi all,

    Qlik Sense February 2021 has  a new functionality, regarding the Qlik Sense Engine, that is call Merge, can someone explain how it works?

    Below the description:

    Merge command script: A new “Merge" command in Qlik script that allows changed data to be loaded into a Qlik application without having to reload the entire data model. Note: This is only the engine functionality and for commercial use it will need additional functionality to allow "partial reload" to be exposed for scheduled reloads vs. via API.

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    Why Week('2021-01-24')=5 in QlikSense?

    In QlikSense, Week('2021-01-24')=5, as the below:But in Qlikview, it's right:
  • forum

    Qlik Sense App Development

    Heatmap Pivot Table

    Hello,Does anyone have a good solution to represent a heatmap in QlikSense?Following the advice here (https://community.qlik.com/t5/New-to-QlikView/Wo... Show More

    Hello,

    Does anyone have a good solution to represent a heatmap in QlikSense?

    Following the advice here (https://community.qlik.com/t5/New-to-QlikView/Working-with-a-Risk-Map/td-p/1112151) I have created some heatmaps using a pivot table. The result is nice, the only issue is that when filters are applied, rows without values disappear, destroying the square shape.

    Is there any way to maintain the rows/form?

    before filtering:

    Uploaded image: before filtering. image.png

     

    after filtering:

    Thank you for any suggestions!

    Carly

    Show Less
  • forum

    Community Corner

    Expression - Only function with null if condition

    Hi All,I am using a table - with dimension Service Id,Risk Category Adjusted Score, RISK_MODEL_EXEN_END_DT,I have to show the table report when [Risk ... Show More

    Hi All,

    I am using a table - with dimension Service Id,Risk Category Adjusted Score, RISK_MODEL_EXEN_END_DT,

    I have to show the table report when [Risk Model End Execution Id] is NULL.

    So, I used the expression -

    =Only({$<=if(IsNULL([Risk Model End Execution Id]),'NULL','NOTNULL') >}[Risk Model End Execution Id]

    1.PNG

     

    but giving me error in expression-

    error.PNG

     

    Please kindly assist.

     

    Thanks

    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

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