Qlik Community

Welcome to Qlik Community

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

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion board and documents related to Qlik Associative Big Data Index.

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.


Challenge the status quo

See why Qlik (Attunity) is recognized in the 2019 Gartner Magic Quadrant for Data Integration Tools.

Recent Discussions

  • New to Qlik Sense

    Logic based on three tables

    Dear Members, I am trying to build one logic from excel to Qlik Sense Cloud. But after several efforts it's not working as expected. So need your... Show More

    Dear Members, 

    I am trying to build one logic from excel to Qlik Sense Cloud. But after several efforts it's not working as expected. So need your help. I have attached test data. This has three data sheets for Aug'19. 

    1. Orders - these are orders created in one month.  

    2. Activities - these are activity closed in same month. 

    3. Orders_2mths - these are last two months orders data. It's a reference sheet for activities table. Activities pick IN_OUT & Country field from this sheet. 

    Now I am trying to build some charts based on above data. one of example is given in chart sheet. This is using Orders & Activities sheets only. 

    There will be two charts one for country & other for months. Country chart will show only latest month data and Months chart will show monthly trend and added month bars as year passes. 

    Now challenge is , if we connect Orders & Activities on basis of Order_No & Month. We lost few orders due to this mapping. If we add them only using Order_No, we didn't get monthly chart.

    Country is available in both Orders & Activities. But we need to use order's Country_O for chart preparation as it's in denominator of ratio. 

    Please share your thoughts to build this logic. 

    Test Data

     

    Show Less
  • New to Qlik Sense

    Ranking with Dimension

    Hi Experts,i have data set material, sales amount and would like to get ranking for some specific material.Please help. Thanks in advance
  • Qlik Sense App Development

    Snapshot of whole sheet to be used in Qlik Sense story telling?

    Hello together,I'm wondering if it would be possible to make a whole dashboard sheet with defined selections available as a snapshot to be used within... Show More

    Hello together,

    I'm wondering if it would be possible to make a whole dashboard sheet with defined selections available as a snapshot to be used within the story telling function of Qlik Sense.

    Live dashboard can't be used since we (our customer) want's to have the same dashbord with different selections available in the story.

    Example:

    Timeline Page 1: Sheet 1 with selection April

    Timeline Page 2: Sheet 1 with selection May

    a.s.o.

    Of course it would be possible to to make snapshots of every single dashboard sheet item - but that's a lot of work, if you have to repeat these steps for mulitple selections from the same sheet.

    Any ideas?

    Best regards,

    Markus

    Show Less
  • New to Qlik Sense

    Yearly Cumulative Returns

    Hi All,I'm trying to build a table showing the yearly returns for my benchmark and my strategy. So my dimension is [Date.autoCalendar.Year] and w... Show More

    Hi All,

    I'm trying to build a table showing the yearly returns for my benchmark and my strategy. So my dimension is [Date.autoCalendar.Year] and what I want to see is the annual cumulative return for each year but the expression I am using for cumulative returns keeps aggregating on top of the previous year in the table instead of giving me the cumulative return just for that year in each row (see image below - columns "AMP Return", "Strategy Return" and "Active Return" all build on the previous year instead of giving me just the return for that year). 

    Any ideas on how to modify the expression to get yearly returns instead of aggregate cumulative returns over the entire period?

    Here is the expression I am using for the AMP Return column: 

    FirstSortedValue(Aggr(exp(RangeSum(Above(log(1+[US-LMS_Return]), 0, RowNo()))) - 1, Date), -Date)

     

    clipboard_image_0.png

    Thanks for the help.

    Olivier

    Show Less
  • QlikView Scripting

    Loading multiple Excel files from SharePoint

    Hi All,I am trying to load multiple excel files from SharePoint using FileList but didn't get through could you please suggest how can i load all the ... Show More

    Hi All,

    I am trying to load multiple excel files from SharePoint using FileList but didn't get through could you please suggest how can i load all the excel files from sharepoint,or please suggest if any workaround for this.

    Please find the below code which i am using to read the files

    Ex:

    for Each file in FileList('https:\\SharePointlink\*.xlsx');

    LOAD

      FileName('$(file)') as DocName

    FROM

    [$(file)]

    (ooxml, embedded labels, table is Raw);

    NEXT file

    Thanks & Regards

    Mallikarjuna

    Show Less
  • Qlik Education Discussions

    New Certification Exams for Qlik Sense June 2018

    Certification candidates may now register and take the three new Qlik Sense Certification Exams based on the June 2018 Release. The roles for the new ... Show More

    Certification candidates may now register and take the three new Qlik Sense Certification Exams based on the June 2018 Release. The roles for the new exams are Business Analyst, Data Architect, and System Administrator. Each exam has 50 questions to complete in 2 hours.

    There is also a new Certification FAQ and Qlik Sense Certification Exam Study Guide on qlik.com

    Partners holding any Qlik Sense – v3, v2, or v1 certifications should update with these exams in 2019, in order to meet the requirements for the Qlik Partner Program.

    All previous versions of the Qlik Sense Certification Exams have been retired. Candidates who have a June 2017 exam scheduled may still take it, but are encouraged to cancel and reschedule their appointment with the latest exam.

    All Qlik Certification Exams are in English. Candidates who have difficulty because English is not their native language may request an accommodation (extra time) on the exam by emailing certification@qlik.com at least 10 days before they want to take their exam. Each individual must make a request for this exception and they should include their VUE ID, found in the Personal Information page in Qlik CertTracker when submitting their request.

    A note about exam releases
    The new Qlik Sense Certification Exams are based on the June 2018 Release of Qlik Sense. Our exams lag behind the product release, because they take 6 to 8 months to develop. We will only release new exams once per year, so the next exams are planned to be based on the June 2019 Release of Qlik Sense.
    Questions?
    Contact certification@qlik.com

    Show Less
  • Community Corner

    Images are missing from edit message pane.

    When pressing edit message in a forum thread I'm not able to see the images added to the message.  When I press edit reply to this post:&nbs... Show More

    When pressing edit message in a forum thread I'm not able to see the images added to the message.  

    When I press edit reply to this post: https://community.qlik.com/t5/New-to-QlikView/Straight-Table-Data-Filter-Issue/m-p/1624115/highlight/true#M380748. Notice the dupliate images in my post. The missing images caused me to add it again during the edit and now it is impossible to remove any of them.

    I see the following in the edit pane:

    clipboard_image_0.png

    Show Less
  • Qlik Sense Cloud Discussions

    Incremental Loading in Cloud

    I am currently evaluating Qlik Cloud for my company's use.  I've been able to implement incremental loading in View and Sense, but while attempti... Show More

    I am currently evaluating Qlik Cloud for my company's use.  I've been able to implement incremental loading in View and Sense, but while attempting this in Cloud I get the error: "Failed to open file in write mode for file." 

    Basic Script is:

    Table1:

    LOAD

         a

         b

         c

    FROM [lib://qlikID/FileName1.QVD] (qvd);

    Concatenate (Table1)

    LOAD

         a

         b

         c

    FROM [lib://qlikID/FileName1.XML] ((XmlSimple, table is [DataSet Name/Table Name]);

    STORE Table1 into [lib://qlikID/FileName1.QVD] (qvd);

    Can anyone help identify my error?

    Thank you, Ken

    Show Less
  • Qlik Sense App Development

    QVW to QVF conversion not working properly

    Good afternoon,I've converted a project on Qlik Sense Converter, but all my set analysis are returning value 0. They're working normally on Qlik View.... Show More

    Good afternoon,

    I've converted a project on Qlik Sense Converter, but all my set analysis are returning value 0. They're working normally on Qlik View.

    Is there any difference between Qlik View and Qlik Sense set analysis?

    Thanks.

    Show Less
  • New to Qlik Sense

    Change Dimensions in my table

      Hello,I want to calculate the failure rate of my products.My data are like this:serial nr              ... Show More
     
     

    Hello,

    I want to calculate the failure rate of my products.

    My data are like this:

    serial nr              sell date           return date 

    112233                 1/1/2012         -

    112233                  -                        1/1/2015

    112244                  1/1/2013        -

    112255                  1/5/2013        -

    112266                  1/1/2014        -

    112266                  -                        1/1/2016

     

    and I want to make them be like this:

    serial nr              sell date           return date           days( return date - sell date)

    112233                 1/1/2012        1/1/2015                  1095

    112244                  1/1/2013        -                                   -

    112255                  1/5/2013        -                                   -

    112266                  1/1/2014       1/1/2016                   730

    What can I do to have this view? 

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar
Show help for this page