Skip to main content

Blogs

This space offers a variety of blogs, all written by Qlik employees. Product and non product related.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 

Design

The Design blog is all about product and Qlik solutions, such as scripting, data modeling, visual design, extensions, best practices, and more!

Product Innovation

By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.

Support Updates

The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.

Qlik Academic Program

This blog was created for professors and students using Qlik within academia.

Community News

Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.

Qlik Digest

The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.

Qlik Education

The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.

Subprocessors List

Qlik Subprocessors General Data Protection Regulation (GDPR).

Japan

Qlik Community blogs for our customers and partners in Japan.

Recent Blog Posts

  • Image Not found

    Support Updates

    Qlik Support Tip - Run as different user

    Hello Qlik Users!Meet Andre! About Andre:It has been almost 4 years since I joined Qlik in the Raleigh office, and have provided support to most QDA products. I enjoy mountain biking, rock climbing, and spending time with the family. Times have been different lately so gaming and movies are a big thing.Andre’s Support tip:When troubleshooting (e.g. QlikView Desktop with NPrinting, Section Access in QV, etc) the .exe can be run using a different u... Show More

    Hello Qlik Users!

    Meet Andre!

    Andre.png

     

    About Andre:

    It has been almost 4 years since I joined Qlik in the Raleigh office, and have provided support to most QDA products. I enjoy mountain biking, rock climbing, and spending time with the family. Times have been different lately so gaming and movies are a big thing.

    Andre’s Support tip:

    When troubleshooting (e.g. QlikView Desktop with NPrinting, Section Access in QV, etc) the .exe can be run using a different user account by holding Shift + Right-click, and selecting “Run as different user”.

    QlikViewRightClick.gif

     

    The same can be done in order to view/delete the Qlik Sense service account QlikClient certificate without having to logon in scenarios where the service account is not allowed interactive remote access.

    MMCrightclick.gif

     

    We hope you enjoyed getting to know Andre and found his Qlik Support tip helpful! Please let us know if you have any questions and we hope you look forward to meeting more of the team!

    Kind regards,

    Qlik Digital Support

     

    Show Less
  • Image Not found

    Product Innovation

    Qlik Replicate - Do More with Qlik - This Thursday - Sign Up Now!

    This Thursday at 2PM ET - I'll be hosting our first Do More with Qlik Session of the year, introducing you to Qlik Replicate. Take a brief look at what Qlik Replicate can do and join me LIVE where I will demonstrated real-time automated data ingestion and update. Hope to see you there!Registration and resources links below.  Sign Up for Do More with Qlik - Qlik ReplicateTake Replicate for a Test DriveQlik Data Integration Product Page Show More

    This Thursday at 2PM ET - I'll be hosting our first Do More with Qlik Session of the year, introducing you to Qlik Replicate. 

    Take a brief look at what Qlik Replicate can do and join me LIVE where I will demonstrated real-time automated data ingestion and update. Hope to see you there!

    Registration and resources links below.

     

     

    Show Less
  • Image Not found

    Design

    Insight Advisor Chat and Business Logic Resources

    Since we released our new augmented analytics features, Insight Advisor Chat and Business Logic, I have presented these topics a few times and created / gathered some resources to showcase the various capabilities to show you how they work under the covers. Since then I felt it was important to  compile these resources and share them with you. Take a look and let me know what you think. These capabilities are available in both Qlik Sense Enterpri... Show More




    Since we released our new augmented analytics features, Insight Advisor Chat and Business Logic, I have presented these topics a few times and created / gathered some resources to showcase the various capabilities to show you how they work under the covers. Since then I felt it was important to  compile these resources and share them with you. Take a look and let me know what you think. These capabilities are available in both Qlik Sense Enterprise SaaS and Windows Client-managed. 

    Have questions? Please post them in the comments below. 

    Insight Advisor Chat

    Insight Advisor Chat offers a fully conversational, natural language analytics experience in Qlik Sense. Multi-language natural language processing (NLP) understands user intent, and natural language generation (NLG) delivers added insight and perspective for a deeper understanding of your question. Insights include auto-generated charts, narrative insights, observations, and more. Users can dive directly into search-based visual analysis for further exploration. And because it works across Qlik Sense apps, it allows people to find the right insights even if they don't know where to look.  Current languages supported with NLP include English, French, German, and Russian.  And the Windows version supports integration with Microsoft Teams and Slack.

    Business Logic

    Business Logic provides a robust business logic layer that incorporates business rules and metadata to customize and guide the behavior of Insight Advisor when generating insights and interacting conversationally with users. It includes the ability to logically group fields, classify data, specify default behaviors, define preferred relationships, and more.  Users can create calendar periods to define how measures should be filtered, aggregated, and compared based on preferred timeframes.  And, they can customize natural language processing, including defining vocabulary rules and synonyms for more natural interaction.

    Resources

    I hope these are helpful and please let me know if you have any questions.

    Regards,
    Mike Tarallo

     

    Show Less
  • qlik-community-blogs.jpg

    Support Updates

    Cross-Site requests with cookie without the SameSite attribute are being blocked

    Development that use cross-site resources may encounter issues when Chrome version 80 is released in the month of February 2020.
  • Image Not found

    Support Updates

    Featured Content Friday Revamp!

    Hello Qlik Users!Last August, we started the Featured Content Friday blog that showcases all of you! We had many submissions from Partners and Users that showed interesting ways Qlik is being used. It was very exciting to see!We want you all to continue to submit your creations! We love seeing how you are using the products. Don’t forget, by submitting your work, you will be entered in a drawing to win Qlik Swag!We would like to expand upon this ... Show More

    Hello Qlik Users!

    Jamie_Gregory_0-1610651370379.jpeg

    Last August, we started the Featured Content Friday blog that showcases all of you! We had many submissions from Partners and Users that showed interesting ways Qlik is being used. It was very exciting to see!

    We want you all to continue to submit your creations! We love seeing how you are using the products. Don’t forget, by submitting your work, you will be entered in a drawing to win Qlik Swag!

    We would like to expand upon this program for 2021. This year we will be showcasing internals as well! (they of course will not be included in the drawing for swag) We think it will be a great way to inspire and encourage thinking outside the box.

    So, as a reminder, send your submissions to digital@qlik.com. For the submission to be valid, you must be subscribed to the Qlik Support Updates Blog. If you’re not subscribed, please make sure to do so by clicking the green subscribe button.

    Please provide the following information in the email:

    • Name
    • Qlik Community ID
    • Company
    • Role
    • How long have you been using Qlik?
    • What’s your favorite thing about Qlik?

     

    Along with the above information, please describe the challenge, the solution that was created, and any steps that could be helpful for other users to implement your solution. Please feel free to attach any materials needed to illustrate the problem and/or solution.

    So, send us your QVF, QVW, screenshots, video, sample code, how-to, Community post, GIF (we love GIFs!), and Ideas (yes! Send us an idea you entered on the Ideas Board).

    Let’s make 2021 a year of inspiration and collaboration!

    Kind regards,

    Qlik Digital Support

    Show Less
  • Image Not found

    Qlik Academic Program

    Round Table on Skills on Emerging Technologies

    On January 8th, I was invited by ICT Academy as a Speaker for a round table on "Skills on Emerging Technologies - Industry Readiness of Graduates.  ICT Academy is an initiative of the Government of India in collaboration with the state Governments and industries. It is a not-for-profit society, and a joint venture under the Public-Private-Partnership (PPP) model. ICT Academy was started to meet the skill requirements of the industry and generate ... Show More

    On January 8th, I was invited by ICT Academy as a Speaker for a round table on "Skills on Emerging Technologies - Industry Readiness of Graduates.  ICT Academy is an initiative of the Government of India in collaboration with the state Governments and industries. It is a not-for-profit society, and a joint venture under the Public-Private-Partnership (PPP) model. ICT Academy was started to meet the skill requirements of the industry and generate more employment especially in tier 2 and 3 towns, the rural parts of India

    The objective of the Round table was to understand from Industry Experts and HR Leaders on the needs for skilling the graduates / final year students on various emerging technologies. Based on the inputs during this Round Table, the Government shall take necessary steps in forming strategy towards skilling the Graduates with an outcome of Employability.

    There were  8 experts from different industries in this Round Table and each expert shared perspectives on the following points:

    • Emerging Technologies for Entry level graduates.
    • Recruitment Trends 2021 for emerging Technologies
    • Recruitment trends for skilled entry level graduates in areas of Cloud, Data Science, RPA, Cyber Security, AI, ML, DL and Blockchain
    • Entry Level Requirements for such emerging technologies 

    ict.jpg

    I had the opportunity to talk about data analytics as a career and its scope as a skill for graduates, irrespective of their background. In fact, the training and qualifications offered by the Qlik Academic Program is meant for any graduate who wishes to get skilled in analytics. Many students who are part of this program are from diverse disciplines including engineering, commerce, science, humanities, medicine etc. 

    In a discussion with the experts during the round table, the moderator asked about the top emerging technology for graduates that will generate a lot of demand and many of them viewed data analytics as their top choice.  Needless to mention, due to the huge amount of data being generated with the increase in connected devices, analytics has a bright future as a career. 

    To learn how you can earn your qualifications and certification in data analytics, visit qlik.com/academicprogram or write an email to academicprogram@qlik.com to know more

    Show Less
  • Image Not found

    Support Updates

    Critical issue found in Qlik Replicate 6.6 and 7.0

    Hello Qlik Users!A critical issue has been identified in Qlik Replicate 6.6 and 7.0.When starting a Replication task from timestamp, Replicate would sometimes fail to close the log stream file after searching for the start position. In this case, the log stream task will be locked and the following error would result in the logs:00016240: 2020-09-28T10:40:56 [IO              ]E*:  Access is denied*.   (apr status = 720005) [1000121]  (at_file.c:7... Show More

    Hello Qlik Users!

    A critical issue has been identified in Qlik Replicate 6.6 and 7.0.

    When starting a Replication task from timestamp, Replicate would sometimes fail to close the log stream file after searching for the start position. In this case, the log stream task will be locked and the following error would result in the logs:

    00016240: 2020-09-28T10:40:56 [IO              ]E*:  Access is denied*.   (apr status = 720005) [1000121]  (at_file.c:774)

    00016240: 2020-09-28T10:40:56 [IO              ]E:  Failed to get file information for ‘…\LOG_STREAM\audit_service\20200921234321312869\1' [1000121]  (at_file.c:802)

    There is a workaround available:

    1) Stop both tasks (LogStream and Replication task)
    2) Resume LogStream task and then resume replication task

    There is also a fix available in:

    • sp08-6.6.0-Replicate
    • sp02-7.0.0-Replicate

     

    These fixes are currently only available through Qlik Support. Please create a case to get access to the download file. For more information on the issue, please see Logstream task locked and error message is given.

    Please let us know if you have any questions.

     

    Kind regards,

    Qlik Digital Support

    Show Less
  • qlik-community-blogs.jpg

    Design

    Maximizing Development Space in Qlik Sense Using Variables

    As Qlik developers, we are always looking for ways to maximize the development real estate in our apps. And sometimes, we (well me), tend to overcomplicate things in order to accomplish the task at hand.
  • qlik-community-blogs.jpg

    Qlik Academic Program

    Qlik Academic Program Webinar

    Register today for the Academic Program Webinar and learn how to receive FREE software, training, and much more!
  • Image Not found

    Support Updates

    Techspert Thursdays - Optimizing Qlik Sense SaaS with App Analyzer

    Hi everyone,Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our Qlik Support experts.The Support Techspert Thursday session from January looked at Optimizing Qlik Sense Enterprise SaaS Apps with App Analyzer.But wait, what is it exactly?Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis, on the thir... Show More

    Hi everyone,

    Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our Qlik Support experts.

    The Support Techspert Thursday session from January looked at Optimizing Qlik Sense Enterprise SaaS Apps with App Analyzer.

    But wait, what is it exactly?
    Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis, on the third Thursday of each month.
    Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.

    In this session we will cover:

    • What the App Analyzer can do
    • How to set it up
    • How to improve app performance
    • Troubleshooting issues

    Click on this link to see the presentation.

    Show Less
  • Image Not found

    Support Updates

    New Year, New Qlik Community

    Hello Qlik Users!Happy Friday!And just like that… Qlik Community has been updated!I recently posted a blog about the Qlik Support Programs we offer. With the recent update to the Community, the location of the Support Programs has changed (as well as the Support Knowledge Base and the Qlik Support Updates Blog).You will now use the banner at the top to navigate Qlik Community. If you hover over Support, another banner will appear and you can navi... Show More

    Hello Qlik Users!

    Happy Friday!

    And just like that… Qlik Community has been updated!

    I recently posted a blog about the Qlik Support Programs we offer. With the recent update to the Community, the location of the Support Programs has changed (as well as the Support Knowledge Base and the Qlik Support Updates Blog).

    You will now use the banner at the top to navigate Qlik Community. If you hover over Support, another banner will appear and you can navigate to the Support Knowledge Base or to this blog. You will also find Support Programs and hovering on that option will provide a list of our Support Programs.

     

    New Support Programs.gif

     

    Please let us know if you have any questions. For more information on the changes made to Qlik Community, please see the update from our Community Manager, @Melissa_Potvin, on the Community Manager Blog.

    We hope you enjoy the fresh new look!

    Have a great weekend,

    Qlik Digital Support

    Show Less
  • Image Not found

    Support Updates

    January Webinar Schedule

    Hello Qlik Users!Here is the January webinar schedule. January 21st, 2021 Event: Support Techspert ThursdayTopic: Optimizing Sense SaaS Apps with App AnalyzerTime: Multiple times availableSign up hereJanuary 23rd, 2021Event: Do More with Qlik – For Beginners and BeyondTopic: Qlik ReplicateTime: 2pm ESTSign up hereJanuary 26th, 2021Event: Talk to Experts TuesdayTopic: Qlik SenseTime: 10am ESTSign up here Don’t forget – there are other On Demand we... Show More

    Hello Qlik Users!

    Here is the January webinar schedule.

     

    January 21st, 2021

    Event: Support Techspert Thursday

    Topic: Optimizing Sense SaaS Apps with App Analyzer

    Time: Multiple times available

    Sign up here

    Divider.png

    January 23rd, 2021

    Event: Do More with Qlik – For Beginners and Beyond

    Topic: Qlik Replicate

    Time: 2pm EST

    Sign up here

    Divider.png

    January 26th, 2021

    Event: Talk to Experts Tuesday

    Topic: Qlik Sense

    Time: 10am EST

    Sign up here

    Divider.png

     

    Don’t forget – there are other On Demand webinars available on the Events page. Please let us know if you have any questions about these sessions or if there is anything you would like to see in the future.

    Make sure you’re subscribed to Qlik Support Updates Blog so you will be notified of everything happening with Qlik Support. Also, please give this blog a “Like” if you found it useful!

    Have a wonderful day and thank you for choosing Qlik!

    Kind regards,

    Qlik Digital Support

    Show Less
  • Image Not found

    Qlik Academic Program

    New year, new Qlik Academic Program web page!

    Many of us are starting back to work this week after a much needed break at the end of 2020. Meanwhile our web team at Qlik were working their magic throughout December to get our new Academic Program web page up and running. As well as giving us a fresh look and feel, the page has plenty more information about our great free program for university students and educators. At just a glance you can now get a complete overview of all of the features... Show More

    Many of us are starting back to work this week after a much needed break at the end of 2020. Meanwhile our web team at Qlik were working their magic throughout December to get our new Academic Program web page up and running. 

    As well as giving us a fresh look and feel, the page has plenty more information about our great free program for university students and educators. At just a glance you can now get a complete overview of all of the features such as free software, training and qualifications that are provided to our members. Students can learn how analytics skills and data literacy help them to stand out in the job market, while educators delve into our array of teaching materials to enable them to integrate Qlik into the classroom.

    And don't forget to check out our brand new video at the top of the page which gives a quick overview of what we do in just 60 seconds. 

    So what are you waiting for, head over to qlik.com/academicprogram to check out all of the updates and to apply!

    Show Less
  • Image Not found

    Support Updates

    Qlik Patch Wednesday Resumes January 27th

    Hello Qlik Users!This is a quick note to let you know that Qlik Patch Wednesday will resume on January 27th.Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date with the latest releases. Please give this post a like if you found it helpful! Also, please let us know if you have any questions or leave your feedback in the comments.Thank you for choosing Qlik!Kind Regards,Qlik Global Support Show More

    Hello Qlik Users!

    This is a quick note to let you know that Qlik Patch Wednesday will resume on January 27th.

    Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date with the latest releases. Please give this post a like if you found it helpful! Also, please let us know if you have any questions or leave your feedback in the comments.

    Thank you for choosing Qlik!

    Kind Regards,

    Qlik Global Support

    Show Less
  • Image Not found

    Support Updates

    Qlik Sense SaaS – Unable to open apps in US region

    Hello Qlik Users!UPDATE 1/6/2021 11:08am EST - This issue has been resolved.It has been reported that some users are unable to open apps in the US region. This issue is currently being investigated.We will update you when the issue is resolved.You can also subscribe to updates on the issue by going to the Qlik Cloud Status page and clicking on Subscribe. Enter in your email address and click Subscribe to Incident.We apologize for any inconvenienc... Show More

    Hello Qlik Users!

    UPDATE 1/6/2021 11:08am EST - This issue has been resolved.

    It has been reported that some users are unable to open apps in the US region. This issue is currently being investigated.

    We will update you when the issue is resolved.

    You can also subscribe to updates on the issue by going to the Qlik Cloud Status page and clicking on Subscribe. Enter in your email address and click Subscribe to Incident.

    Qlik Cloud Services Status.png

    We apologize for any inconvenience this is causing.

    Kind regards,

    Qlik Global Support

    Show Less
  • Image Not found

    Support Updates

    Featured Content Friday – A New NPrinting Master Consolle

    Hello Qlik Users!It’s not only Friday, it’s Featured Content Friday!We are traversing the globe once again and featuring a partner from Milan, Italy.Valerio of ICE SUISSE CH!Valerio has been working with Qlik Sense, QlikView and NPrinting for over 12 years! He is a BI Senior Specialist as an architect and developer of BI platforms. Valerio created a Qlik Sense dashboard that:Relates apps, connections, filters and rulesChecks the scheduled reloads... Show More

    Hello Qlik Users!

    It’s not only Friday, it’s Featured Content Friday!

    We are traversing the globe once again and featuring a partner from Milan, Italy.

    Valerio of ICE SUISSE CH!

    Valerio has been working with Qlik Sense, QlikView and NPrinting for over 12 years! He is a BI Senior Specialist as an architect and developer of BI platforms.

    Valerioquote.png

     Valerio created a Qlik Sense dashboard that:

    • Relates apps, connections, filters and rules
    • Checks the scheduled reloads and emails sent
    • Verifies the use of a filter for users, reports and tasks
    • And much more!

     

    Check out Valerio’s post* about the master console that includes a video and images!

    A New NPrinting Master Consolle

    *The information in this post is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support may not be provided by Qlik Support.

    Do you want to be spotlighted in a future post? See our previous post, Introducing Featured Content Friday!, for more information on submitting your dashboards, workarounds, how-to’s.

    Thank you for being a part of the Qlik Community and for choosing Qlik!

    Have a great weekend,

    Qlik Digital Support

    Show Less
  • Image Not found

    Support Updates

    Qlik Support Programs within Qlik Community

    Hello Qlik Users!We wanted to take this time to remind you of all the available programs Qlik Support offers. You can find these programs, here on the Qlik Community under Support Programs.Here is a quick recap of each program:Support Knowledge Base – Our Knowledge Base where you can search and find answers to your questions. Articles can be found related to account questions, error messages, and known issues. Stay tuned for more information on u... Show More

    Hello Qlik Users!

    We wanted to take this time to remind you of all the available programs Qlik Support offers. You can find these programs, here on the Qlik Community under Support Programs.

    Jamie_Gregory_0-1609879360834.png

    Here is a quick recap of each program:

    Support Knowledge Base – Our Knowledge Base where you can search and find answers to your questions. Articles can be found related to account questions, error messages, and known issues. Stay tuned for more information on updates to our Knowledge Base search engine.

    Support Updates Blog – This blog of course! Here, you will find information about product and patch releases, useful tips, announcements, product issues and much more! Subscribe to stay up-to-date with the latest information from Qlik Global Support.

    Talk to Experts Tuesday – Our LIVE Q&A webinar series! We discuss a different product each session and you will have access to our experts ranging from Qlik Support to Product Management to Qlik Consulting. Check out the schedule, sign up today and bring your questions!

    Techspert Thursdays – More commonly known as STT and the series that started it all! Support Techspert Thursday facilitates knowledge sharing on the third Thursday of each month (some exceptions) with discussions on relevant support topics happening today. Sign up once and you will receive an invite each month!

    Featured Content Friday – Our way of spotlighting YOU! This is a blog segment that allows us to showcase what you have created using Qlik. We will be expanding this program, so stay tuned for more information!

    Qlik Fix – This program is a series of videos that walk you through troubleshooting errors, configuration changes, and how to’s. The videos are short so you can consume the information quickly and as effectively as possible.

    Let us know what kind of questions you have or what you would like to see in the future! We are always open to suggestions on how we can improve our programs!

    Kind regards,

    Qlik Digital Support

    Show Less
  • qlik-community-blogs.jpg

    Design

    Rounding Errors

      “If you use equality as a condition when comparing floats, I will flunk you!” I can still hear the words of the Professor in my first programming class when studying for my engineering degree. The threat was very real – he meant it – and the reason was of course the fact that you cannot (always) represent decimal numbers in an exact binary form. For example, we would never dream of writing a condition   If( x = 0.3333333 , … ) when we want to t... Show More

     

    If you use equality as a condition when comparing floats, I will flunk you!

    I can still hear the words of the Professor in my first programming class when studying for my engineering degree. The threat was very real – he meant it – and the reason was of course the fact that you cannot (always) represent decimal numbers in an exact binary form.

    For example, we would never dream of writing a condition

      If( x = 0.3333333 , … )

    when we want to test if x equals a third. Never. Because we know that a third cannot be represented exactly as a decimal number. No matter how many threes we add to the number, it will still not be exact.

    But it is not uncommon that people make comparisons with an exact decimal number, similar to

          If( x = 0.01 , … )

    thinking that it is a valid comparison, although it leads to exactly the same problem as the previous comparison! This becomes obvious if you look at the hexadecimal representation of 0.01:

          0.01 (decimal) = 0.028F5C28F5C28F…. (hex)

    The sequence …28F5C… is repeated an infinite number of times, but since QlikView uses a finite number of binary digits (all according to the IEEE standard), QlikView will internally use a “rounded” number.

    So what are the consequences? Well, QlikView will sometimes deliver the “wrong” number as result. Examples:

    Ceil( 0.15, 0.01 ) will return 0.16
    Floor( 0.34, 0.01 ) will return 0.33
    0.175*1000 = 175 will return FALSE
    Time( Floor( Time#( '04:00:00' ),1/24/60/60 )) will return 03:59:59

    What you see are not errors in QlikView. And they are not errors in IEEE 754. Rather, they represent errors in the expectation and usage of binary floating point numbers. Once you understand what binary floating point numbers really are, it makes perfect sense. It's simply that some values cannot be exactly represented as binary numbers, so you get rounding errors. There's no way around it.

    Should you want to investigate this yourself, I suggest you start with the following script that generates 100 numbers and their rounded counterparts. In five cases the Ceil() function rounds "incorrectly" and generates a "Diff" different from zero:

    Load
       Num(Rounded,'(HEX) 0.000000000000000','.',' ') as RoundedHEX,
       (Round(100*Rounded) - PartsPer100)/100 as Diff,
       *;
    Load
       Ceil(PartsPer100/100, 0.01) as Rounded,
       *;
    Load
       RecNo() as PartsPer100
       Autogenerate 100 ;

    So, what should you do?

    First of all, you should realize that the rounding errors are small and usually insignificant. In most cases they will not affect the result of the analysis.

    Further, you could avoid rounding with Floor() and Ceil() to sub-integer fractions.

    Also, you could convert the numbers to integers, because the errors will only appear if the numbers can have sub-integer components. For instance, if you know that you always deal with dollars and cents, you could convert the numbers to (integer) cents:

      Round( 100*Amount ) as Cents

    Or if you know that you never deal with time units smaller than seconds:

      Round( 24*60*60*Time#( Time, 'hh:mm:ss' ) ) as Seconds

    And finally, you should never use equality as a condition when comparing floats. Use greater than or less than. My professor isn’t here to flunk you, but rest assured: In his absence, QlikView will do it for him.

    HIC

    Show Less
  • Image Not found

    Support Updates

    New Onboarding Resource for Qlik Sense users and Administrators

    Hello Qlik Users!Happy New Year!As we jump into 2021, Qlik would like to share the new location for Qlik Sense Onboarding resources on Qlik Help.   The new Onboarding section lists resources to get started with Qlik Sense as well as administer Qlik Sense Business, Enterprise SaaS or Enterprise on Windows. You’ll find instructions and videos to walk you through things like creating visualizations or setting up your tenant.If you’re just starting o... Show More

    Hello Qlik Users!

    Happy New Year!

    As we jump into 2021, Qlik would like to share the new location for Qlik Sense Onboarding resources on Qlik Help.

      Qlik _ Help.png

     

    The new Onboarding section lists resources to get started with Qlik Sense as well as administer Qlik Sense Business, Enterprise SaaS or Enterprise on Windows. You’ll find instructions and videos to walk you through things like creating visualizations or setting up your tenant.

    If you’re just starting out with Qlik Sense and would like to learn more about using the tool or best practices to administer the software, we hope you will take advantage of this new collection of resources.

    If you have any questions, please feel free to reach out to customersuccess@qlik.com.

    Kind regards,

    Qlik Digital Support

    Show Less
  • Image Not found

    Explore Qlik Gallery

    A NEW "NPRINTNG MASTER CONSOLLE

    New Function of my own QLIK Framework...My new Dashboard to simultaneously explore all the information available ... Apps, Connections, Filters, Rules, Conditions, Reports, Users, Scheduling and more... The Dashboard in action