Hi guys – I have some great news to share in preparation for our annual customer and partner conference, Qlik World, formerly known as Qonnections. For the first time, you will now be able to immediately join the discussion with those attending QlikWorld - including Qlik’s team of experts - on event-related content and events – all via our Qlik Community forum. We have created a new forum in the Qlik Community where you can post questions, view Qlik World documents and learn more about the informative sessions you may want to attend. You will have inside access to many of the Qlik World key topics and themes to be presented, giving insight into our 2020 direction. There will be a selection of Qlik employees available to “Qonnect” with – whether they are product specific or event related, who will have the answers for you! . You can also subscribe to boards in the Qlik World forum to be notified of content that is published. Areas available: • Data Analytics Platform • Data Integration Platform • Data Literacy • Customer Success & Use Cases • Customer Success & Data Literacy • Technical Training & Certifications • Event Info • Panel & Round Table Sessions • Partner Success & Integration So get connected, be involved and share your ideas with your peers and Qlik’s data and analytics experts who are passionate about Qlik's platform, transforming business processes and driving data-driven insights. This forum will get you energized and ready for Qlik’s largest customer and partner event of the year. Let’s start a discussion. Join me in the QlikWorld forum today. Check it out! Register for QlikWorld here. BTW - here is a shameless plug - check out what I'll be up to at QlikWorld- have a question? Let us know, we'll do our best to answer. Hope to see you there!Regards,Mike Tarallo - TwitterQlik ...View More

Hi Guys Recently, we've had some communication in regards to the registration process for a Qlik Sense Business tenant. Though, it is fairly simple and straightforward, some people prefer to see it in action first before actually attempting to do it. So I decided to show you the steps needed to register the tenant both with or without a Qlik Account. I have also created a quick video showing how quickly you can create your first Qlik Sense app and add data to it. (Sample data file attached below). Note these videos can be quickly used in situations where you just need to get started as quickly as possible and don't necessarily have the time to watch a longer product tour (also available). Please see link below for other detailed resources and let me know if you have any comments or question. Also - don't forget to enter the #QlikHighlights2019 $100 Amazon Giveaway for your chance to win a $100 Amazon gift card. Official rules and more information available here:https://community.qlik.com/t5/Qlik-Design-Blog/The-QlikHighlights-100-Gift-Card-Giveaway-Starts-Today/ba-p/1663495 Regards, Mike TaralloQlik Register Your Qlik Sense Business Tenant Create Your First App Resources Topics You Need to Knowhttps://community.qlik.com/t5/Qlik-Sense-Documents-Videos/New-to-Qlik-Sense-Topics-You-Need-to-Know/ta-p/1530582 ...View More

Almost two years ago, in February of 2018, the Qlik Demo Team (Qdt) publicly released qdt-components (GitHub, npm). We originally built Qdt-components as an internal library designed to help us create demos to showcase Qlik Sense Enterprise. We opened up the library to help others use the new Qlik APIs and create interesting mashups with their data. Since that initial release, we've written over a dozen blog posts to the Qlik Community Design Blogdetailing how to use the various Qlik Sense and Picasso.js charts available via Qdt-components. In 2019, we hit 50 stars on GitHub, putting us in the top 1% of all open-source projects on GitHub. We've recently made some updates to our documentation and we wanted to re-introduce Qdt-components, show off our new logo, and highlight this powerful library's practical uses and recently added features. Qdt-components is designed to be a library-agnostic method of connecting to Qlik Sense and displaying visualizations. Whether that is bringing in entire Qlik Sense charts and objects or building your own visualizations, Qdt-components is an easy-to-setup wrapper that can be used in a number of different ways. We've written in the past on this blog about the pros and cons of using the various APIs to connect to Qlik Sense (Getting Started with Qlik APIs, Integrating Qlik Sense into your Web App), an area that developers can easily get tripped up on. With Qdt-components, the question of whether to use the Capability API or incorporating Enigma.js has already been handled. You just need to answer one simple question: do I want to use charts and objects directly from my Qlik Sense app? If so, then you want access to the Visualization API; otherwise, the Engine API is sufficient. Bringing in Qlik objects with the Visualization API means that it'll have the appearance you'd see in a Qlik Sense app. If you don't need to customize the look of your objects for your web app, then you can just build the charts / toolbars / etc. in Qlik Sense and bring them into your mashup using their object id's. If you want to skip all that, you can use our pre-built components by simply specifying the dimensions, measures, columns, etc. you need. Here are the available components as of 01/01/2020, the appropriate Qlik API required for the configuration object, and links to documentation to get you started: QdtViz These are used to bring in Qlik Sense objects exactly as they are in Qlik Sense. QdtViz components require the Visualization API (vizApi: true) and are one of the easiest to implement; you just need the object's id. Visualization API: yes Engine API: no Blog Posts:qdt-components - A Components Library that can be used in simple Html, Angular 5 and React Documentation QdtCurrentSelections Like QdtViz, QdtCurrentSelections requires the Visualization API and appears as it is from Qlik Sense. It can be used to show your user's current selections in the familiar, Qlik-styling. The only property you need to specify is its height. Visualization API: yes Engine API: no Documentation QdtFilter Using the Engine API, QdtFilter is a simple dropdown based on a column from your data. Visualization API: no Engine API: yes Documentation QdtSelectionToolbar This component displays a toolbar with the current app selections. Visualization API: no Engine API: yes Documentation QdtPicasso The QdtPicasso component actually comprises several Picasso.js charts; fifteen (15) as of January 10, 2020. Picasso.jsis a charting library streamlined for building interactive visualizations for the Qlik product suites. With Qdt-components, connecting to and using Picasso.js is super easy because it's already built in...no need to import Picasso.js yourself. Visualization API: no Engine API: yes Blog Posts: qdt-components - Horizontal Barchart by Picasso.js & Selection Toolbar,Qdt-components & Picasso.js - More Charts!,Qdt-components - custom charts with Qlik's Open Source picasso.js,Creating custom charts with qdt-components, Documentation QdtSearch The QdtSearch component is a simple text input field that can be used to search a dimension of your data. Visualization API: no Engine API: yes Documentation QdtMapBox We've recently added our MapBox integration with the QdtMapBox component. You'll just need a MapBox API key and desired styling to create a map showcasing your data. Visualization API: no Engine API: yes Blog Posts:Creating a Geo Map with qdt-components and MapBox Documentation QdtTable Build a sortable table of your data using QdtTable. Visualization API: no Engine API: yes Documentation Getting started with Qdt-components is easy but we've created several templates to make it even easier: HTML / Vanilla JavaScript Template,HTML Documentation, Demo React Template,React Documentation, Demo Angular Template,Angular Documentation, Demo And lastly, do you have an idea for a feature, bug fix, or chart to add? You can open an issue on GitHub or contribute! ...View More

Hey guys – it’s that time of year again for my annual #QlikHighlights contest which showcases the passion you have for Qlik and the interesting solutions created with our products. This is your chance to share an awesome, or memorable, Qlik moment from 2019 - such as a partner or customer success story, a personal experience enriched by Qlik, a global event where we made an impact, or a product feature that transformed your business. Normally, we run this on Twitter, but this time I’m opening it up to our LinkedIn followers as well. This means we will have one Twitter winner (ha ha - say that 3 times fast) AND one LinkedIn winner. Oh, and the Amazon Gift Card prize has increased from $50 to $100! All you need to do is post your memorable Qlik related piece of content or memorable moment with the hashtag #QlikHighlights2019 and tag me @mtarallo on Twitter or @Michael_Tarallo on LinkedIn to be entered and so I am aware and so I can re-share your Qlik awesomeness. For example – did Qlik Insight Bot provide you with a unique, AI powered conversational analytics experience? Did the acquisition of Attunity introduce you to a new breed of enterprise data management capabilities? We want to know! Or you could share your success stories on the use of our multi-cloud architecture, AI capabilities, the associative difference, and other great features that have solved your business problems! We want to hear from you on how Qlik has made a difference and how we have helped transform your business over the past year. Be creative and get posting, I will announce the winner in March. See below for official contest rules. Regards, Mike TaralloLinkedInTwitter #QlikHighlights2019 Giveaway Official Rules Winner will be selected and announced on Twitter and LinkedIn by Michael Tarallo on March 3rd, 2020 in the Tuesday edition of the Qlik Design Blog. Only one unique winner per social media platform. Entries will be randomly selected by a hashtag selection app. Entries must be an interesting or valid Qlik highlight or discovery - which can include screen shots, pictures, videos and links. Only one entry per participant. If multiple entries are submitted they will be considered and the best one judged. Non-qualifying entries will be discarded and the next entry will be selected at random. Contest starts Tuesday, Jan 8, 2020 and ends on February 28th 2020. Amazon Gift cards / codes are only valid to participants where Amazon services are available. Previous Winners: 2017 - Greg Anderson:https://community.qlik.com/t5/Qlik-Design-Blog/and-the-winner-is/ba-p/1467553 2018 - Chris Lofthouse:https://twitter.com/mtarallo/status/1096457870722457600 ...View More

I recently rebuilt our custom table in the qdt-components library that we use on the demo team here at Qlik. You can check out an example athttps://qdt-apps.qlik.com/qdt-components/react/#/table-engine. Perhaps the trickiest part to get just right was sorting. When a user clicks on a column header, the sorting needed to update to sort by that column, and that part is pretty straightforward, just patch the objects qInterColumnSortOrder and move that column's index to the front of the array. But how do I know to display to the user in the column header whether that column is sorting by descending or ascending? And what if the user clicks on that same column header again to reverse the sort order of that column? Then I learned about the qSortIndicator and qReverseSort sort properties. You can find the values of the qSortIndicator and qReverseSort properties in the qDimensionInfo and qMeasureInfo structs in qLayout. Basically, qSortIndicator just returns either 'N' for no sort, 'A' for ascending sort, or 'D' for descending sort, and qReverseSort indicates with true or false whether the sort order is actually reversed. And you can set the qReverseSort to reverse the sort order inside the qDef of the dimension or measure. With these properties in hand, I was able to correctly display in the column header of the active sorted column whether the sort was ascending or descending, as well as handle reverse sorting of a column with relative ease. Let's take a look at it. First thing I do is grab all the information I need for each column. That looks like this. const columns = useMemo(() => ( qLayout ? [ ...qLayout.qHyperCube.qDimensionInfo.map((col, index) => ({ Header: col.qFallbackTitle, accessor: (d) => d[index].qText, defaultSortDesc: col.qSortIndicator === 'D', id: col.qFallbackTitle, qInterColumnIndex: index, qPath: `/qHyperCubeDef/qDimensions/${index}`, qSortIndicator: col.qSortIndicator, qReverseSort: col.qReverseSort, })), ...qLayout.qHyperCube.qMeasureInfo.map((col, index) => ({ Header: col.qFallbackTitle, accessor: (d) => d[index + qLayout.qHyperCube.qDimensionInfo.length].qText, defaultSortDesc: col.qSortIndicator === 'D', id: col.qFallbackTitle, qInterColumnIndex: index + qLayout.qHyperCube.qDimensionInfo.length, qPath: `/qHyperCubeDef/qMeasures/${index}`, qSortIndicator: col.qSortIndicator, qReverseSort: col.qReverseSort, })), ] : [] ), [qLayout]); I'm just looping through all of the qDimensionInfos and qMeasureInfos, grabbing the header name, and storing information such as the column header text in addition to the qSortIndicator and qReverseSort. I also set a property called defaultSortDesc which is true if qSortIndicator is 'D', and false otherwise. This property is what is used by the react-table library, which I used to build the table, to display whether the column header displays whether the sort is descending or ascending. Next, I need a function to handle sorting change. The callback for clicking on a column header in react-table provides a newSorted prop, which includes the new direction of the sort, and a column prop, which includes the column data for the header clicked. I apply two patches when a user clicks on a header, one which sets the qReverseSort correctly if needed, and one that updates the qInterColumnSortOrder to move that columns qInterColumnIndex to the first position in the array. That looks like this. const handleSortedChange = useCallback(async (newSorted, column) => { setLoading(true); await applyPatches([ { qOp: 'replace', qPath: `${column.qPath}/qDef/qReverseSort`, qValue: JSON.stringify((newSorted[0].desc !== column.defaultSortDesc) !== !!column.qReverseSort), }, { qOp: 'replace', qPath: '/qHyperCubeDef/qInterColumnSortOrder', qValue: JSON.stringify([...qLayout.qHyperCube.qEffectiveInterColumnSortOrder].sort((a, b) => (a === column.qInterColumnIndex ? -1 : b === column.qInterColumnIndex ? 1 : 0))), //eslint-disable-line }, ]); setPage(0); }, [applyPatches, qLayout]); Now i can simply display the table using react-table like so. <ReactTable manual data={qData ? qData.qMatrix : []} columns={columns} onSortedChange={handleSortedChange} multiSort={false} /> And that's it. You can check out the example athttps://qdt-apps.qlik.com/qdt-components/react/#/table-engineand the full code for the table athttps://github.com/qlik-demo-team/qdt-components/blob/master/src/components/QdtTable/QdtTable.jsx ...View More

With the November 2019 release came a new chart for Qlik Sense - the mekko chart. The mekko chart allows users to compare a measure by group as well as by category within a group. The mekko chart takes two dimensions and one measure and utilizes height and width to show how values compare across dimensions. Let’s look at an example. In the chart below, quarter is the first dimension, region is the second dimension and the measure is revenue. The quarters are listed across the top along with their normalized percentage value for revenue which is also visible via the width of each quarter (bar). So, you can see that Q1 is the widest bar because it had the largest revenue while Q3 is the narrowest and had the least amount of revenue. The height of each region in a quarter represents the normalized percentage value for revenue for that region within that quarter. So, if looking at Q1, the Americas had the most revenue while Africa had the least. The design of the chart makes it easy for the user to compare revenue by quarter, revenue by region within each quarter, as well as revenue by region across quarters. A few things to note are the mekko chart cannot show negative values and does not work well if there are many dimension values. You should also avoid using the mekko chart if you want to mix absolute and relative values. The mekko chart is easy to create and easy to read. You can learn more about the mekko chart and other new features of the November 2019 release in the Qlik Product Innovation Blog, the What’s New – Qlik Product Release Video and the What’s New app. Thanks, Jennell ...View More

Hi Guys! It's time for another Tuesday Edition of the Qlik Design Blog. Today I have the pleasure of introducing a special guest blogger, Fredrik Lautrup.Fredrik is a long time Qlikkie, leadingour product designers in our Product Design Group. Fredrik’s BI and analytics experience stems from working with many customers in areas of product design, security and licensing. He has worked with numerous enterprises in different roles - from IT, security to strategic information systems and is responsible for design and workflow of our products. Today Fredrik is sharing a 2 part series that will introduce you to our new content management paradigm, available with the cloud editions of Qlik Sense, known as Spaces. In this entry he will discuss what Spaces are, the types of Spaces available and why they are important and should be used. He also elaborates on additional attributes known as Favorites and Collections which adds a personal touch to your Qlik Sense app organization and navigation experience. Allowing you to access and manage content that is most important to you. Take a look at the PDF attachment (1 - Why the need for spaces, favourites and collections.pdf) to get started learning about Spaces. Thank you Fredrik for your valuable contribution. For more information on spaces and our cloud editions of Qlik Sense check out this 2 part videos series plus bonus video on Spaces. Take a Tour of our cloud editions of Qlik Sense Spaces ------ QlikWorld 2020 ------ DON' FORGET - QlikWorld 2020 will be here sooner than you think. Discover how to get the most from your data Register by Dec 31 to save $400. ...View More

Qdt-components is a library that we build in the Demo & Innovation Team to facilitate most of our needs by communicating with Qlik Servers and displaying visualizations in websites. This can happen with either the Capability API where we just supply the object id and show the visualization that we have already created in Qlik Sense or, by the Engine API where we only get the data and then decide on how we want them displayed on the page. To achieve the second, we have added great libraries like Picassojs and now MapBox. If you have not used qdt-components before, we have setup integration guides for the top 3 most popular frameworks like React, Angular and Vue and one for no framehork, just simple html. https://github.com/qlik-demo-team/qdt-components#usage We had a task for a live event that we needed to show data from around the US as a voting was taking place. We thought of trying out MapBox since it was a vary light and fast library that utilizes the latest in OpenGL technologies. We tried it with qdt-components and the results are amazing. Below is a simple example on how to use it and the one that loads over a million rows of data (examples are in ReactJs). Code example: <QdtComponent type="QdtMapBox" props={{ cols: ['ID', 'lat', 'lon', 'gender'], height: 400, qPage: { qTop: 0, qLeft: 0, qWidth: 4, qHeight: 2500, }, }} https://qdt-apps.qlik.com/qdt-components/react/#/mapbox Swipe Night example with over a million rows of data In order to get all 'swipe night' data, I passed the number of seconds that I want the library to loop through and then a callback to get the qData in my browser and calculate the percentages to display on the screen. <QdtComponent type="QdtMapBox" props={{ mapToken: 'pk.xxx', style: 'mapbox://styles/xxx', center: [-97.531708, 39.305878], zoom: 4.3, interactive: false, circleRadius: 2, cols: ['ID', 'lat', 'lon', 'gender'], height, getData: callback, getAllDataInterval: 1, // Get data In Seconds qPage: { qTop: 0, qLeft: 0, qWidth: 4, qHeight: 2500, }, legend: false, }}const callback = (qData, qLayout) => { totalRows = qLayout.qHyperCube.qSize.qcy; currentRows += qData.qMatrix.length; data = [...data, ...qData.qMatrix]; console.log(`${currentRows}/${totalRows}`); const _labels = labels; qData.qMatrix.map((value) => { if (value[3].qText) { counter[value[3].qText] += 1; _labels[value[3].qText] = (counter[value[3].qText] / data.length) * 100; _labels[value[3].qText] = `${Number(_labels[value[3].qText].toFixed(2))}%`; } return true; }); setLabels(() => ({ ...labels, ..._labels })); }; This is it!! Happy Coding!!! Yianni ...View More

Hey Guys - happy Friday!! - You can see by my greeting I am genuinely excited to share with you all what I learned when diving into the world of Attunity. Yes, you heard me right, Attunity. In February 2019 -Qlik acquired Attunity, a leader in data integration and data management solutions. Since then I have been chomping at the bit to get my hands on the software so I could learn what it is and potentially start showcasing how awesome it is. Remember, you guys know me for almost everything Qlik Sense - but as a technology evangelist, I need to expand my video portfolio as we grow and acquire new technologies in order to share all of the amazing software capabilities and solutions available from Qlik. When preparing for our Qlik Products November 2019 What's New video - I had the pleasure of working with Senior Solutions Engineer Thiago Bruch, whom generously shared his knowledge with me on the Attunity platform. To start - I created a video that provides a "Hello World" so to speak of one of the products available in the Attunity platform, Attunity Replicate. I hope to follow with more videos on other pieces and use cases in the future as I continue to learn more. Note - we are opening a new section in the Qlik Community dedicated to Attunity where myself and other Attunity experts will be contributing - so stay tuned to learn more. OK - enough talk - on to the video. The video is much longer than I normally make but stick around - you will see everything in action in real-time. It will even give you some ideas on how you can demonstrate it as well if necessary. Send me your questions, happy to help. Regards, Mike Tarallo ...View More

Hey Guys, we are excited to share with you a new capability available in the cloud-based editions of Qlik Sense. You can now upload, view, organize and share QlikView documents - (.qvw) files right along with your QlikSense apps in Phase 1 of this 2 phased approach. Once uploaded the QlikView documents can be secured and managed just like any app. You can set access roles for users and organize them in spaces and even add them to your favorites and collections. Ourvision is to provide a common platform to create a unified analytics experience, so you can simplify your deployment and make progress toward alleviating entitlement management burdens. Watch this 60 second video to learn more an check out our latest entry in our Innovation Blog here. Have a comment or question? We want to hear from you. Leave them below. Regards,Mike Tarallo ...View More