Qlik Community

Blogs

Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!

Important and useful support information about end-of-product support, new service releases, and general support topics.

Updates for Qlik Community offerings, announcements and changes.

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

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

On this forum you can access and follow the latest updates of our courses and programs with the Qlik Education team.

Learn about what's new across all of the products in our growing Qlik product portfolio.

Information on all new product releases, connectors, beta programs, and technical product information.

Deep dives into specific back-end technologies which allow for the extension of Qlik to fit the needs of the enterprise.

All about Qlik's Voice of the Customer program and Customer Success initiatives

Recent Blog Posts

  • Image Not found
    Qlik Product Innovation Blog

    New OnDemand Webinar Highlights Ways to Protect and Extend Your QlikView Investm...

    Simplified deployments… check! Lower infrastructure costs… check! Relief from entitlement management… check!   Thank you for your enthusiasm for QlikView year after year. As the Qlik offerings evolve, we want to make sure to keep you apprised of the latest news and developments. We invite you to join us for our latest Product Spotlight OnDemand webinar: “Protect and Extend Your QlikView Investment” for an update on QlikView, our strategy, and go ... Show More

    Simplified deployments… check! Lower infrastructure costs… check! Relief from entitlement management… check!

     

    Thank you for your enthusiasm for QlikView year after year. As the Qlik offerings evolve, we want to make sure to keep you apprised of the latest news and developments. We invite you to join us for our latest Product Spotlight OnDemand webinar: “Protect and Extend Your QlikView Investment” for an update on QlikView, our strategy, and go forward plan.

     

    During this webinar, product leadership will discuss Qlik direction and how our commitment to QlikView plays into the overall Qlik strategy and development trajectory. We will introduce the concept of product co-existence and how we’re making it simple and cost-effective to extend QlikView capabilities through Dual Use licensing.  We will also introduce you to our roadmap and release plan, so you can gain insight into valuable and complementary updates recently added to Qlik Sense.

     

    Visit this link to attend “Protect and Extend Your QlikView Investment”.

    Show Less
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    Qlik November Releases

    Hello All Qlik Customers,   November has been a busy month for Qlik Sense releases.  So, as we embark upon the holiday season, we want to take a moment to highlight those new releases.   Major releases Qlik Sense November 2019 introduces expanded cloud connectivity, new visualization capabilities, enhancements to cloud hub, reporting improvements and more.  To learn more about what this release has to offer, please be sure to visit our Qlik Produ... Show More
    Hello All Qlik Customers,
     
    November has been a busy month for Qlik Sense releases.  So, as we embark upon the holiday season, we want to take a moment to highlight those new releases.
     
    Major releases
    Qlik Sense November 2019 introduces expanded cloud connectivity, new visualization capabilities, enhancements to cloud hub, reporting improvements and more.  To learn more about what this release has to offer, please be sure to visit our Qlik Product Innovation Blog.  For additional details, including product defect fixes, please review the release notes here.

    Qlik Sense NPrinting 2019
    introduces the Qlik NPrinting Migration tool, Improvements in On-Demand Reporting and Variable logic. To learn more about this release, including product defect fixes, please review the release notes here.
     

    Qlik Sense Patches
    During the month of November, we have also released a number of Qlik Sense patches as shown below.
    Qlik Sense November 2018 Patch 7 -  details on included fixes can be found here
    Qlik Sense February 2019 Patch 5 -  details on included fixes can be found here
    Qlik Sense April 2019 Patch 4 -  details on included  fixes can be found here
    Qlik Sense June 2019 Patch 5 -  details on included  fixes can be found here
    Qlik Sense September 2019 Patch 1 -  details on included fixes can be found here
     
    As always when upgrading any software, make sure that you backup your system and applications before doing any installation and follow upgrading best practices. Thank you for choosing Qlik software.
     
    We wish you a Happy Holiday Season!
     
    Kind Regards,
    Global Support
    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Loops in the Script

    First of all, the Load statement is in itself a loop: For each record in the input table, the field values are read and appended to the output table. The record number is the loop counter, and once the record is read, the loop counter is increased by one and the next record is read. Hence – a loop. But there are cases where you want to create other types of iterations – in addition to the Load statement. For - Next Loops Often you want a loop out... Show More

    First of all, the Load statement is in itself a loop: For each record in the input table, the field values are read and appended to the output table. The record number is the loop counter, and once the record is read, the loop counter is increased by one and the next record is read. Hence – a loop.

    But there are cases where you want to create other types of iterations – in addition to the Load statement.

    Files.pngFor - Next Loops

    Often you want a loop outside the Load statement. In other words; you enclose normal script statements with a control statement e.g. a "For…Next" to create a loop. An enclosed Load will then be executed several times, once for each value of the loop counter or until the exit condition is met.

    The most common case is that you have several files with the same structure, e.g. log files, and you want to load all of them:

       For each vFileName in Filelist ('C:\Path\*.txt')
          Load *,
             '$(vFileName)' as FileName
          From [$(vFileName)];
       Next vFileName

    Files Table.pngAnother common case is that you already have loaded a separate table listing the files you want to load. Then you need to loop over the rows in this table, fetch the file name using the Peek() function, and load the listed file:

       For vFileNo = 1 to NoOfRows('FileListTable')
          Let vFileName = Peek('FileName',vFileNo-1,'FileListTable');
          Load *,
             '$(vFileName)' as FileName
          From [$(vFileName)];
       Next vFileNo

    Looping over the same record

    You can also have iterations inside the Load statement. I.e. during the execution of a Load statement the same input record is read several times. This will result in an output table that potentially has more records than the input table. There are two ways to do this: Either by using a While clause or by calling the Subfield() function.

    One common situation is that you have a table with intervals and you want to generate all values between the beginning and the end of the interval. Then you would use a While clause where you can set a condition using the loop counter IterNo() to define the number of values to generate, i.e. how many times this record should be loaded:

       Dates:
       Load
          IntervalID,
          Date( FromDate + IterNo() - 1 ) as Date
          Resident Intervals
          While IterNo() <= ToDate - FromDate + 1 ;

    Intervals with Arrows.png

    Another common situation is that you have a list of values within one single field. This is a fairly common case when e.g. tags or skills are stored, since it then isn’t clear how many tags or skills one object can have. In such a situation you would want to break up the skill list into separate records using the Subfield() function. This function is, when its third parameter is omitted, an implicit loop: The Load will read the entire record once per value in the list.

       [Individual Skills]:
       Load
          [Employee No],
          SubField(Skills, ',') as Skill
          Resident Employees;

    Skills w Arrows.png

    Bottom line: Iterations are powerful tools that can help you create a good data model. Use them.

    HIC

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Qlik Sense Wordpress Plugin

    There are a lot of people that use Wordpress as their company's portal. If you are one of these people then, you may find this plugin very useful. You can create a mashup from within wordpress, using the Capabilities API, without writing a single line of code. Just add the settings with the host and the App ID, then the shortcode for the objects that you want and you are done.Here, I will show you how to do that.First go to your wp admin panel, u... Show More

    There are a lot of people that use Wordpress as their company's portal. If you are one of these people then, you may find this plugin very useful. You can create a mashup from within wordpress, using the Capabilities API, without writing a single line of code. Just add the settings with the host and the App ID, then the shortcode for the objects that you want and you are done.

    Here, I will show you how to do that.

    1. First go to your wp admin panel, under "Plugins" click on "Add New" and then search for "Qlik"
      install.png
    2. Click on "Install Now" and then on "Activate"
    3. This will create a "Qlik Sense" settings page, just open that
    4. Settings.png
    5. Here you need to define your host, the Virtual Proxy (prefix) and the App Id, as you would in a regular mashup. If you are planning on using a second app, then add the second app id in "App2 ID".
    6. Save changes.
    7. Then add the shortcode into your posts "[qlik-sense-object id="page1-obj2" qvid="nvqpV" height="400" app2="true"]"

    - id: is the unique div id. This is needed especially when you want to display the same object in 2 different instances

    - qvid: Is the object id as found in the "dev-hub/single-configurator"
    - height: The height of the visualization in pixels
    - nointeraction: Add this if you want to disable interactions. If you want the objects to have interaction, you can just omit this.

    - app2: Add this if your object is coming from the second app that you have specified in the settings

    EditPost.png

    • I have added few objects with a specific height in a bootstrap template for better layout. Now, lets preview the page
      Helloworld.pngHelloworld2.png

    Make sure you whitelist your url in the virtual proxy.

    If you use it and like it, please give it a 5 star in Wordpress.

    This is it!

    Yianni

    In Portuguese: Qlik Sense Plugin para Wordpressby cleveranjos. Thank you Clever!

    GitHub - yianni-ververis/qlik-sense-wordpress-plugin: A Wordpress plugin to create a Qlik Sense Mashup

    Qlik Branch

    Show Less
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    Qlik Sense Patch Wednesdays* - New releases available

    Hello Qlik Sense Users   We are pleased to announce a pilot program called Patch Wednesdays*. The aim of the new program is to have a more consistent delivery timeline and better planning within Global Products.  Patches will be released every two weeks, and you guessed it, on Wednesdays!   With that being said, we'd like to note that the following patches were released today and are now available on the download site.   November 2019 Patch 1 - d... Show More
    Hello Qlik Sense Users
     
    We are pleased to announce a pilot program called Patch Wednesdays*. The aim of the new program is to have a more consistent delivery timeline and better planning within Global Products.  Patches will be released every two weeks, and you guessed it, on Wednesdays!   With that being said, we'd like to note that the following patches were released today and are now available on the download site.
     
    November 2019 Patch 1 - details on included fixes can be found  here 
    September 2019 Patch 2 - details on included fixes can be found here
    June 2019 Patch 6 - details on included fixes can be found here
    April 2019 Patch 5 - details on included fixes can be found here
    November 2018 Patch 8 - details on included fixes can be found here 
     
    Thank you for choosing Qlik software. As always, please follow best practices when upgrading any software and make sure you back up your system before making changes.
     
     
    Kind regards,
    Global Support
     
    *The terms of this program are under review and are subject to change.
    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Qlik Sense Mobile - Update (video)

    Hi folks - this video will show you how to get started with Qlik Sense Mobile from a basic sense. There have been some signifcant changes since I last recorded a video on this and it was time for a brief update. Due note that we have much more for those of you who administer, secure and deploy mobile BI. We work with Enterprise Mobile management vendors to tightly integrate our solution with their platforms. See the resource links below.In this v... Show More

    Hi folks - this video will show you how to get started with Qlik Sense Mobile from a basic sense. There have been some signifcant changes since I last recorded a video on this and it was time for a brief update. Due note that we have much more for those of you who administer, secure and deploy mobile BI. We work with Enterprise Mobile management vendors to tightly integrate our solution with their platforms. See the resource links below.

    In this video you will learn how to:

    • Install the Qlik Sense Mobile App on iOS
    • Configure and Send Client Authentication Link Using the QMC
    • Verify Offline Security Settings
    • Start the app and login to your server
    • Download your app
    • Access your app offline

    Note: Offline access via the Qlik Sense Mobile App is only available to Qlik Sense Enterprise customers. However, Qlik Sense servers and Qlik Sense Cloud can be quickly and easily accessed via a mobile device such as a tablet or smart phone by simply using a mobile browser that supports HTML5 - i.e. Chrome, Safari, etc. Check out these 2 videos to learn more:

    Please let me know if you have any comments or questions.

    Qlik Sense Mobile

    Resources:

    Enjoy!

    Michael Tarallo (@mtarallo) | Twitter

    Can't see the embedded video? YouTube blocked by your organization or region? Download the .mp4 to watch on your computer or mobile device.

    Show Less
  • Image Not found
    Qlik Product Innovation Blog

    Modern Data Integration with Attunity 6.5: An Update for Architects and DBAs

    A big part of the value is integrating with many platforms.  Things change – you might start your analytics on AWS, then try certain workloads on Azure and Google.  Your company might acquire a business unit that runs production data on SQL Server rather than Oracle.  Your CIO might institute a data modernization effort that requires you to offload analytics queries from your DB2 z/OS systems to Kafka.  Whatever direction you take, it helps to ha... Show More

    A big part of the value is integrating with many platforms.  Things change – you might start your analytics on AWS, then try certain workloads on Azure and Google.  Your company might acquire a business unit that runs production data on SQL Server rather than Oracle.  Your CIO might institute a data modernization effort that requires you to offload analytics queries from your DB2 z/OS systems to Kafka.  Whatever direction you take, it helps to have a consistent, automated data pipeline process.

     

    Here at Attunity, now part of Qlik, we cast an ever-widening net with our pipeline automation.  Attunity version 6.5 extends our leadership in enterprise data integration with enhanced platform support, performance and security capabilities, as well as additional platform configuration options for flexibility.

     

    Platform Integration Leadership in Enterprise Data Integration


    Attunity now integrates with new end points that organizations are embracing for both operations and analytics.  We have added support for Salesforce, MongoDB and Google Cloud SQL as sources, and Google Cloud BigQuery, Azure Databricks (beta) and Azure Data Lake Storage (ADLS) Gen2 as targets.

    Attunity Data Integration: Any Source to Any Target

    Attunitiy image.png

     

    Here are a few example use cases to see what this looks like in action. 

     

    • Next-Generation Data Lakes: Enterprises are shifting from complex, Hadoop-based data lakes on premises to simpler, more scalable and more efficient data lakes based on cloud-native data stores and Apache Spark. Databricks is a prime target.  With Attunity 6.5, you can now automatically create an operational data store in the Databricks Delta lake, then load, merge and format data in it from Salesforce and other sources – mainframe production systems, SAP SRM applications, you name it.  Source data and schema updates are automatically propagated into the ODS.  So your analytics are based on a current, accurate view of the business, spanning sales trends, customer activity, supply chain updates and more.

     

    • Multi-Cloud Initiatives: Many organizations are adopting a 2nd or even 3rd Cloud Service Provider in order to control cost, test one CSP’s advanced analytics tools, or reduce exposure to a CSP that is also a competitor. We continue to broaden our portfolio to flexibly support these decisions.  With Attunity 6.5, you can migrate your data warehouse from Amazon Redshift to Google BigQuery, or migrate your database from Google Cloud SQL to Azure SQL DB. 

     

    Performance

    We continue to reduce latency and increase throughput via deep integration with the most common enterprise platforms.  Here is a look at the performance enhancements of Attunity Replicate 6.5.

    • Kafka Targets:  We have significantly improved performance when using the Avro format to encode messages produced by the Kafka target.
    • Log Stream Targets:  Replicate users now can adjust data compression levels with an intuitive slider.  Higher compression levels conserve disk space, while lower compression reduces latency.
    • SQL Server Sources:  Replicate has reduced latency by reading SQL Server Large Objects (LOBs) directly from transaction logs instead of performing a lookup.
    • Extended Parallel Load Support:  This throughput-enhancing feature has been extended to the following endpoints:
      • Sources: Teradata and Amazon RDS for SQL Server
      • Targets: Azure Data Warehouse, and Snowflake on AWS and Azure
    • Target Change Processing:  Replicate now can increase throughput by applying batched changes to multiple tables concurrently on Amazon Redshift and Microsoft Azure SQL Data Warehouse targets, in addition to previously-supported targets.

     

    Management

    We have also improved our management flexibility, pushing out the envelope with new configuration options for some of our most popular sources:

    • SQL Server:  Replicate now supports dynamic data masking, as well as non-sysadmin users configured with the Always On option.
    • Oracle:  Reset log operations are now captured by default, and Replicate can detect open transactions on all RAC nodes rather than just the primary node.
    • SAP HANA:  Users now can:
      • Replicate from both single and multi-tenant architectures on a single host.
      • Replicate partition tables and header columns with log-based CDC.

     

    Security

    Finally, Attunity 6.5 hardens security controls on a number of fronts to ensure data integrity and support compliance efforts across all platforms.  For example, Attunity Replicate now includes a Secure Sockets Layer (SSL) option to encrypt client-server connections for email notifications.  This SSL capability also includes the ability to verify “peer” and “host” fields by validating server certificates.  We also have added non-privileged accounts on Windows, enabling users to run Replicate with restricted capabilities compared with the default account.  Finally, new installations now require strong passwords.

     

    To download the software and try it for yourself, check out the Attunity Replicate Test Drive.

     

    Article by Kevin Petrie

    Product Marketing Director

     

    Check out this video to see it in action:

     

    Show Less
  • Image Not found
  • Image Not found
  • Image Not found
  • Image Not found
  • Image Not found
  • Image Not found
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    QlikView Governance Dashboard 2.0.5 is now available

    Hi all QlikView usersWe have released a new version of our brilliant QlikView Governance Dashboard which is now available on our download site.   This new dashboard was developed to help administrators have oversight of their QlikView implementation and contains new functionality aimed at the upcoming QlikView November 2017 release.   We previously highlighted the changes which QlikView November 2017 will bring to Search and Select ( https://comm... Show More

    Hi all QlikView users

    We have released a new version of our brilliant QlikView Governance Dashboard which is now available on our download site.   This new dashboard was developed to help administrators have oversight of their QlikView implementation and contains new functionality aimed at the upcoming QlikView November 2017 release.   We previously highlighted the changes which QlikView November 2017 will bring to Search and Select ( https://community.qlik.com/blogs/supportupdates/2017/09/22/upcoming-changes-in-search-select-qlik-sense-and-qlikview ) and the new Governance Dashboard will help you identify which QlikView documents may have Set Analysis expressions affected by the changes.

    For more details please see the attached release notes.   Thank you for choosing Qlik software.

    Kind regards

    Global Support Team

    Show Less
  • Image Not found
    Qlik Product Innovation Blog

    Announcing Qlik Sense® Business!

        As part of our ongoing SaaS product roadmap, we are excited to announce the launch of Qlik Sense Business, our newest SaaS offering designed to help groups and teams collaborate on analytics and make faster data-driven decisions. Is this the same as Qlik Sense Cloud Business? No, and it’s not just a name change, either. Qlik Sense Business is a new, enhanced offering with more capabilities that groups and teams can use to build and share ap... Show More

     

     

    As part of our ongoing SaaS product roadmap, we are excited to announce the launch of Qlik Sense Business, our newest SaaS offering designed to help groups and teams collaborate on analytics and make faster data-driven decisions.


    Is this the same as Qlik Sense Cloud Business?

    No, and it’s not just a name change, either. Qlik Sense Business is a new, enhanced offering with more capabilities that groups and teams can use to build and share apps for greater discoveries.
    Qlik Sense Business runs on Qlik Cloud Services, our cloud-native, Kubernetes-based SaaS platform that also hosts Qlik Sense Enterprise.  Qlik Sense Business users will now benefit from the same speed, performance, and availability as our enterprise SaaS users. Additionally, Qlik Sense Business also shares the same enhanced and redesigned user interface, cloud hub, and management console as Qlik Sense Enterprise on Qlik Cloud Services.

    Qlik Sense Business users benefit from:

    •  Full Qlik Sense analytics capabilities, including the Associative Engine
    •  All of Qlik’s latest augmented intelligence capabilities, including insight suggestions
    •  Drag-and-drop app creation and fully interactive apps
    •  A personal space to create your own content and share with anyone you wish
    •  Five shared spaces where your team members can do-develop and share apps
    •  Direct data connectivity to over 40 data sources
    •  Automated data refreshes


    The global roll out of Qlik Sense Business is underway. Be one of the first by to start your 30-day trial now. You will be able to create your tenant in minutes, and begin creating and sharing apps immediately – all without any downloads or installations. 

    If you’re ever ready for more enterprise features – additional governance, API integrations and more data capacity – you can easily upgrade to Qlik Sense Enterprise on Qlik Cloud Services at any time.

    Currently a Qlik Sense Cloud Business user?

    Stay tuned for upcoming details next months. We’ll tell you how you can migrate from Qlik Sense Cloud Business and subscribe to Qlik Sense Business. You’ll also be eligible for a limited-time offer savings when you migrate your existing cloud subscription.

    Show Less
  • Image Not found
    Qlik Product Innovation Blog

    Visualization Tips & Tricks

    At Qonnections 2019 I hosted a session called “Qlik Sense Visualizations, best practice and top tricks”. I have received a lot of positive feedback, so I decided to make a part 2 with 41 more or less useful new tips.   Recent feature additions to Qlik Sense have certainly helped to expand the possibilities of customizing Sense, such as the container object, the dashboard bundle, alternate states, show conditions to name a few. But it’s also the p... Show More

    At Qonnections 2019 I hosted a session called “Qlik Sense Visualizations, best practice and top tricks”. I have received a lot of positive feedback, so I decided to make a part 2 with 41 more or less useful new tips.

     

    Recent feature additions to Qlik Sense have certainly helped to expand the possibilities of customizing Sense, such as the container object, the dashboard bundle, alternate states, show conditions to name a few. But it’s also the power of the calculation engine and the expression language that many times provides a way forward tweaking the look and feel of Sense.

     

    Most of the tips I will share in this post are invented by others and have been published before on Qlik Community. I highlighted some examples below, but there are many more tips included in the app.

     

    Bars and sparklines in the straight table

     

    sparklines.png

     

    Pad with Unicode white breaks, add a center line and use the absolute max as denominator. Showing two version, plain bars and circles, filled or empty. Sparklines are covered in the first set of tips.

     

    Vertical filter pane with values

     

    filter.pngUse the filter pane one grid high and change the label hold all values =concat(distinct Year,' | ').

     

    Different markers per line

     

     

     markers.pngAdd two measures, one for line and one for the symbol. Use master measures to keep colors consistent.

     

    Chart with annotations

     

    annotations.png

     

    Use the combo chart and custom marker layers on a secondary axis. Add a custom expression for the marker and the label. Tweak the axis and the expression to get the markers on the right place.

     

    Best-selling combinations

     

    combos.png

     

    Create a copy of the combination field in the load script, in this case, ProductNames. Add to a pivot table, use count(OrderID) as measure, mask duplicates values with white text color. Credit: Swuehl, link to post.

     

    Venn diagram

     

    venn.pngThis is a strict Venn diagram with all areas always present. Use an image of Venn diagram and the area layer of the map chart. Check out how to make a clickable chart of an image.

     

    Line chart with colored bands

     

    rasta.png

    Can be made with the line chart in area mode with measures for the bands. Create a line chart, set to area mode, unstacked. Add master measures for the bands with the wanted color. Add master measure for actual. Add measures to chart, starting with actual and the bands in progressive order. Add reference lines for the bands with label and color.

     

    Vertical band chart


    bands.png

    Create bar chart, Add measure =1 label =' '. Color by the wanted measure, add label. Switch of axis, labels and value. Set number of bars to "Max". Set bar width to max in "Styling". Add legend at the bottom. Switch of legend title.

     

    Download the app

     

    app2.png

    Full instructions and working examples can be found in the app below. Some of the tips are very easy to implement while others require a little more work. Most of them are independent of the Qlik Sense version but I recommend using the latest version.

     

    To download the app, visit the Community post, 41 tips.

     

    If you missed my previous postings, check out the previous apps I’ve shared on our community:

     

     

    If you interested in visualizations, you should also check out Qlik GeoAnalytics, our highly capable add-on for geographic analysis. I've published two posts with advanced tips for Qlik GeoAnalytics:

     

     

    Thanks,

    Patric Nordström
    Product Manager, Qlik Sense Visualizations and Qlik GeoAnalytics

     

    Show Less
  • Image Not found
    Qlik Support Updates Blog

    Changes to Qlik Sense Desktop in 2020

    UPDATE TO PREVIOUS POST - December 5, 2019   Following the statement below we have received quite a bit of feedback from passionate Qlik users and partners who are getting a great amount of daily value out of Qlik’s products and services.  As a result of this feedback we would like to share with you the following information and updates regarding key areas of concern.   API Developer access to development tool: We realize that Qlik Sense Deskto... Show More
    UPDATE TO PREVIOUS POST - December 5, 2019

     

    Following the statement below we have received quite a bit of feedback from passionate Qlik users and partners who are getting a great amount of daily value out of Qlik’s products and services.  As a result of this feedback we would like to share with you the following information and updates regarding key areas of concern.

     

    API Developer access to development tool:
    • We realize that Qlik Sense Desktop is an integral part of many API developers in our community, and a solution will be provided prior to June 2020 that will provide similar or better ability to develop with Qlik's APIs and will be communicated via our Qlik developer community, Qlik Branch.

     

    Ability to easily try Qlik Sense for extended periods of time:
    • We will continue to invest in making it easier and faster for anyone (not just Windows users) to try Qlik Sense via a cloud-based trial approach with Qlik Sense Business. We recognize that it is not always possible to make a decision in 30 days, so trial users will be able to extend their trial for an additional 15 days on their own. If additional time is need to make a decision, trials can be extended further, we only ask our trial users engage with a sales person who can assist with your evaluation of Qlik Sense.

     

    Ability to keep data offline while trying (and using) Qlik Sense:
    • We have prioritized enabling Qlik Sense Desktop to authenticate via Qlik Cloud Services which would enable Qlik Sense Business users to also use Qlik Sense Desktop. This will enable paid and trial users to keep their data local if they choose.

     

    Access to Qlik Sense for key influences and promoters of Qlik:
    • We will continue our investments in e-commerce capabilities so we can grant faster, easier and more customized access to Qlik Sense. This capability is much more than the ability to just buy Qlik Sense via a credit card, also giving Qlik the ability to efficiently service special groups via programs such as our Academic Program, Corporate Responsibility Program software grants and our Partner Program.

     

    Thank you all for the on-going feedback, suggestions and dialogue.  Qlik is very thankful to have a vibrate and passionate community.  We are listening and appreciate all the feedback.

     

    ______________________________________________________________________

     

    Posted December 3, 2019

     

    To adapt to changing customer preferences and in alignment with enterprise cloud vendors industry practice, Qlik is moving away from a ‘freemium’ model for both its cloud and desktop versions of Qlik Sense, in favor of a time limited trial.  This means that both Qlik Sense Cloud Basic and Qlik Sense Desktop will cease to be free. It is important to note that Qlik Sense Desktop will remain a supported part of our Qlik Sense product family.

     

    We began this process in August with the launch of Qlik Sense Business and migration of Qlik Sense Cloud users and now we are beginning the process for Qlik Sense Desktop.  We are aware this is a change for many of Qlik Sense Desktop users so we will be making these changes progressively over several months to allow you to plan accordingly.  We will start by removing the download from qlik.com, then Qlik Sense Desktop will notify users of the change and finally free use of Qlik Sense Desktop will stop.

     

     

    Key Changes and Dates:

     

    December 2019 through January 2020:  Free downloads of Qlik Sense Desktop will be removed from Qlik’s websites.  During and after this period, Qlik Sense Desktop will still be available via the customer download site.  If you do not have access to the customer download site then you can use this temporary download link to get the most recent version of Qlik Sense Desktop and continue free use.  During this period there will be no physical changes to Qlik Sense Desktop.

     

    February 2020:  When launching Qlik Sense Desktop, it will display an alert of the upcoming changes (and linking to this posting).  This display will be generated in all versions of Qlik Sense Desktop (including previously released versions). At this time, users can continue to use Qlik Sense Desktop for free however we strongly recommend users start transitioning to a paid edition of Qlik Sense either by starting a trial of Qlik Sense Business or by authenticating Qlik Sense Desktop against Qlik Sense Enterprise on Windows.

     

    30 June 2020: Free access to Qlik Sense Desktop will cease.  To continue to use Qlik Sense Desktop users must authenticate against Qlik Sense Enterprise on Windows.  Users will still be able to access the Qlik Sense App (QVFs) via their local file system and copy the files to other editions of Qlik Sense. 

     

    After 30 June 2020:  Qlik Sense Desktop will continue to receive updates and will remain a fully supported Qlik Sense client of paid deployments using Qlik Sense Enterprise on Windows.

     

     

     

    FAQ (updated)

    Can I use Qlik Sense Business to unlock Qlik Sense Desktop?
    No, currently the only option is to authenticate Qlik Sense Desktop against Qlik Sense Enterprise on Windows. We are working to provide authentication via Qlik Cloud Services including Qlik Cloud Business.

     

    Can I use an older version of Qlik Sense Desktop and continue free use?

    No, all versions of Qlik Sense Desktop will no longer allow free access after 30 June 2020.

     

    Can I buy Qlik Sense Desktop as a standalone?
    No, to continue to use Qlik Sense you will need to subscribe to Qlik Sense.

     

    Can I still use Qlik Sense Desktop for app development and/or offline access as part of a wider Qlik Sense Enterprise deployment?
     
    How do I try Qlik Sense if I cannot upload my data to the cloud?
    Please contact our sales team to discuss our multi-cloud capabilities which give you the choice of where your data resides.

     

    I’m an API developer and I use Qlik Sense Desktop for my development work, how will I do this after June 2020?
    We realize that Qlik Sense Desktop is an integral part of many API developers in our community, a solution will be provided prior to June 2020 that will provide similar or better ability to develop with Qlik's APIs and will be communicated via our Qlik developer community, Qlik Branch.

     

     

     

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Excluding values in Set Analysis

    In Set Analysis, it is straightforward to make selections; to define the criteria for inclusion. But it is not as straightforward to define an exclusion. But there are in fact several ways to do this.   First of all, an inclusion can be defined the following way:     This expression is equivalent to saying “Sum the Amounts where Field equals X”.   But if you want to say the opposite – “where field does not equal X” – it becomes more complicated.... Show More

    In Set Analysis, it is straightforward to make selections; to define the criteria for inclusion. But it is not as straightforward to define an exclusion. But there are in fact several ways to do this.

     

    First of all, an inclusion can be defined the following way:

     

    Formula0.png

     

    This expression is equivalent to saying “Sum the Amounts where Field equals X”.

     

    But if you want to say the opposite – “where field does not equal X” – it becomes more complicated. The relation “not equal to” is not a Set operation. However, one way to do this is to use the implicit exclusion operator:

     

    Formula1.png

     

    Note the minus sign in front of the equals sign. This will create an element set based on the existing selected values, but with the value X removed.

     

    A second way to do this is to use the unary exclusion operator:

     

    Formula2.png

     

    This will return the complement set of X and use this as element set in the set expression.

     

    In many situations the two methods return identical sets. But there are cases when they are different. In the table below you can see that it makes a difference if there already is a selection in the field.

     

    Image5.png

     

    Note the difference on the row with the C. Since the implicit operator (the 2nd expression) is based on current selection, also the value C is excluded from the calculation. This is in contrast to the unary operator (the 3rd expression) that creates a completely new element set, not based on current selection.

     

    We can also see that both of the above expressions exclude records where the field is NULL (the line where Field has a dash only). The reason is simple: As soon as there is a selection in the field, the logical inference will exclude NULL in the same field.

     

    So what should you do if you want to exclude X but not NULL?

     

    The answer is simple: Use another field for your selection. Typically you should use the primary key for the table where you find the Amount.

     

    Formula3.png

     

    Here you need to use the element function E(), that returns excluded values. Hence, the above Set expression says: “Select the IDs that get excluded when selecting X.”

     

    Image7.png

     

    The table confirms that we get the records we want: X is excluded but NULL is still included.

     

    With this, I hope that you understand Set Analysis somewhat better.

     

    HIC

     

    Further reading related to this topic:

    A Primer on Set Analysis

    Why is it called Set Analysis?

    Finding NULL

    Show Less
  • Image Not found
    Qlik Academic Program Blog

    Birmingham City University introduces the Qlik Academic Program to its Graduate+...

    The Qlik Academic Program has been working with students and lecturers from Birmingham City University for several years now, to introduce students to Qlik software and to help them to upskill in Data Analytics. We are pleased to announce that we have been able to go one step further, and the Academic Program resources are now part of the University’s Graduate+ Award Framework.   Graduate+ is a programme available to all students at Birmingham Ci... Show More

    The Qlik Academic Program has been working with students and lecturers from Birmingham City University for several years now, to introduce students to Qlik software and to help them to upskill in Data Analytics. We are pleased to announce that we have been able to go one step further, and the Academic Program resources are now part of the University’s Graduate+ Award Framework.

     

    Graduate+ is a programme available to all students at Birmingham City University. It focuses on turning high-calibre students into work ready graduates, allowing them to develop professional and personal attributes. One of the skill areas included here is digital literacy, and as part of this, the Qlik Academic Program resources will allow students to develop data literacy and analytics skills. The resources offered by Qlik include training in Qlik Sense software and associated qualifications, as well as general training in analytical theories and concepts.

     

    We are thrilled to have the opportunity to provide students across the whole University with our great resources. As data is becoming increasingly important across all levels of all organisations, it’s more important than ever that everyone has fundamental analytics skills. Being part of Graduate+ means that students from all disciplines can be exposed to the training materials and qualifications, not just those from traditional STEM subjects.

     

    You can read the full article here on FENews. We are looking forward to seeing how this new partnership helps students at Birmingham City University to secure the jobs that they want in 2020 and beyond.

     

    If you are a University student or lecturer and you would like to sign up for the free Qlik Academic Program, apply today!

    Show Less
  • Image Not found