Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,497 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

    How can I download the newest version of Qlik Sense Desktop?

    Hello team, I have currently have a Qlik Sense Desktop September 2018 release installation in my laptop. I would like to upgrade it to the latest Febr... Show More

    Hello team, 

    I have currently have a Qlik Sense Desktop September 2018 release installation in my laptop. 

    I would like to upgrade it to the latest February 2020 release but I can't get it downloaded in the first place from your website.

    Can you guys please help me?

    Much appreciate it!

    Show Less
  • New to Qlik Sense

    Why Join Data in Qlik while Association between tables can be used to derive dee...

    Qlik Associative Model provides a full outer join like operation. If we "Join" the tables (Maybe inner) then the associative model is of no use.So why... Show More

    Qlik Associative Model provides a full outer join like operation.

     

    If we "Join" the tables (Maybe inner) then the associative model is of no use.

    So why even join data inside Qlik when associative model can do a better job of showing all data and providing deeper data insights

    Show Less
  • Qlik Sense App Development

    Documenting your development in Qlik Sense

    Our developers struggle with keeping up with changes to our ETL scripts in Qlik Sense. Having to constantly refer back to the Extractor from the Trans... Show More

    Our developers struggle with keeping up with changes to our ETL scripts in Qlik Sense. Having to constantly refer back to the Extractor from the Transformer field names/aliases, etc. So How does the Community document their work? Do you tediously put everything in an Excel spread sheet or is there a way to grab the Scripts via the API and bring them into Excel?

    Do you use Source control like Git or some other method of tracking changes?

    Appreciate any and all ideas from the Community!

    Show Less
  • New to QlikView

    Set Analysis Logic

    Hi Community,I've attached the Qlikview file & Sample excel.  I've posted the requirement in the .qvwNeed Set Analysis Solution. I'm not able to apply... Show More

    Hi Community,

    I've attached the Qlikview file & Sample excel.  I've posted the requirement in the .qvw

    Need Set Analysis Solution. I'm not able to apply the logic. Please check the attachment & provide me the solution.

    PFB the requirement:

    Requirement.png

    @sunny_talwar 

     

    Regards,

    RD

     

    Show Less
  • QlikView Creating Analytics

    Unable to view maps image in scatter chart

    Hi All, I have followed all the steps to implement maps in qlikview.I have a small problem the map cannot load the image through API, i am attaching m... Show More

    Hi All,

     

    I have followed all the steps to implement maps in qlikview.

    I have a small problem the map cannot load the image through API, i am attaching my application .

    It will be great if anyone can guide me in this.

     

     

    Show Less
  • New to Qlik Sense

    Grid Table with same dimension in Row and Column

    Hi,I am using QSB  and my data source looks like this : Order_idClient_idData_typeDate10012301Sales_date01/01/202010012301Order_date01/01/202010012301... Show More

    Hi,

    I am using QSB  and my data source looks like this :

     

    Order_idClient_idData_typeDate
    10012301Sales_date01/01/2020
    10012301Order_date01/01/2020
    10012301Install_date01/01/2020
    10012301Cancel_date01/01/2020
    10022302Sales_date01/01/2020
    10022302Sales_date01/01/2020
    10032303Order_date01/01/2020

     

     

    And I need to produce a graph like the following, that counts the orders ID that match both Dimesions. Row dimension and Column dimension is the same one. But pivot table does not allow to put the same dimension in both rows and columns.

     

     Sales_dateOrder_dateInstall_dateCancel_date
    Sales_dateCount (order_id)Count (order_id)Count (order_id)Count (order_id)
    Order_dateCount (order_id)Count (order_id)Count (order_id)Count (order_id)
    Install_dateCount (order_id)Count (order_id)Count (order_id)Count (order_id)
    Cancel_dateCount (order_id)Count (order_id)Count (order_id)Count (order_id)

     

    Thanks in advance for your help!!

    Show Less
  • New to Qlik Sense

    How to avoid blank lines in forum posts?

    This forum's post editor compulsively adds tons of these lines to my posts, resulting in a lot of ugly blank lines: <p>&nbsp;</p> There appears to be ... Show More

    This forum's post editor compulsively adds tons of these lines to my posts, resulting in a lot of ugly blank lines:

     

    <p>&nbsp;</p>

     

    There appears to be no way to remove them.  If I edit the raw HTML, it simply ignores the change and puts them right back in.  Each time I edit the post, I risk even more of those lines being added.

    Is there any way around this bug?  It makes posts look terrible.

     

    Show Less
  • New to Qlik Sense

    Create range for all measures associated with each dimension

    Hi! I have some huge data where I want to implement the following: I have Ids and expense/ amount associated with each Id however one Id may repeat n ... Show More

    Hi! 

    I have some huge data where I want to implement the following: I have Ids and expense/ amount associated with each Id however one Id may repeat n number of times with different or same amount each time. In load editor I want to create a range such that for member ID say 123 add up all expenses and put them in range. 

    In below table for member id 123: total expense is 560 so it should lie in range of 501-600 however currently I am getting below result. 

    Member IdExpenseRange
    123900-100
    123150101-200
    234200101-200
    234450-100
    456350301-400
    567257201-300
    123320301-400
    234380301-400

    For each id I get aggregate amount I want to create range in dimension 0-100, 101-200, 301-400 so on. Later on I want to count that for each range which Ids were there and total amount. If possible can this range be crated for each year as well.

    Thanks in advance! 

    Show Less
  • New to Qlik Sense

    3 Decimal round off in qlik sense

    Dear all,How to round off 3 decimal?Round(Value,0.001) is not working ?Please help  
  • QlikView Layout & Visualizations

    Set Analysis

    Hi, there are two parts in my questionPart1>I am having one problem related to one field "Sellable items", that contains below-given logic.Can you ple... Show More

    Hi, there are two parts in my question

    Part1>

    I am having one problem related to one field "Sellable items", that contains below-given logic.

    Can you please help me understand this logic:-->

    "if(match(getcurrentfield(Range_Structure),'RU','Purchasing Area (POA)','Purchasing Team','Supplier','Purchasing Group','Range Status')=0,

    (num(Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT={1},[Item Status]={Sellable}>}DISTINCT [Item No])
    /
    Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT=,[Item Status]={Sellable}>}DISTINCT [Item No])
    ,'# ##0,0%')),'')"

    Part2>

    There are 4 columns in my chart and "Sellable items" is one of them. After adding some filter, 2 rows are selected.

    In 1st row "Sellable items" = 73,8%

    and in 2nd row the values are = 0,0%. when I am selecting the total value by the expression, I am having a result of 74,3%.

    My goal is to neglect the 2nd  row where column "Sellable items" = 0,0% so the total become 73,8% (same as 1st row)

    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.

March 25, 2020 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


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