Hello Qlik Users!It’s our first Featured Content Friday of 2021!We are holding on to the holiday spirit a bit longer with this entry bySergey of Qurious Solutions!Sergey is a principal consultant and has been working with Qlik products for an incredible 12 years. When asked what his favorite thing about Qlik is, Sergey responded:Check out Sergey's creation:A Christmas Tree* Sergey created this visualization with Qlik Sense. He made great use of the scatter plot chart to create the tree and the animator extension in the Qlik Dashboard bundle to make it flicker! He also provided the script in his post so you can create your own.Our whole team was impressed with this visualization. And if points were given, Sergey would get more for creating a GIF (we love GIFs, hint, hint)! 😉*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.Would you like to be spotlighted in a future post? See our Featured Content Friday Revamp for more information on submitting your dashboards, screenshots, ideas, videos, workarounds, how-to’s and more!Thank you for being a part of the Qlik Community and for choosing Qlik!Kind regards,Qlik Digital Support
...View More
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 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:NameQlik Community IDCompanyRoleHow 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
...View More
Hello Qlik Users!Happy Featured Content Friday!This week we are featuring a partner from Vancouver, Canada!Martin of GINQO Consulting Ltd!Martin has been using Qlik products for 7 years. His current role is Senior Qlik Solutions Consultant and he specializes in Public Safety.When asked what his favorite thing about Qlik is, Martin said:"The current pace of development, innovation and expansion is blowing my mind! Amazing set of tools now and more to come." - MartinMartin shared a video showing how he created a keyboard using QlikView and Qlik GeoAnalytics within a Qlik Sense app. QlikView was used to create the shapes of the keyboard and a macro was used to find the coordinates of the buttons. The coordinates were brought into Qlik Sense as an inline table and then the Qlik GeoAnalytics polygon layer was used to "map" the keyboard. Check out Martin's video*:Creating novel shapes for Qlik Sense GeoAnalytics (using QlikView)Martin’s mind might be blown away by Qlik’s innovation but we are blown away by his ingenuity and application of our products!*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 or anything else you would like to share!Thank you for being a part of the Qlik Community and for choosing Qlik!Kind regards,Qlik Digital Support
...View More
Hello Qlik Users!Happy Friday! Did this week fly by for anyone else?It’s Featured Content Friday and I’m so excited to share a writer with you all today!He is an Enterprise Architect and has been working as the global lead architect for the past 6 years.Armand of Tata Consultancy Services!Armand is a former Qlikkie (he worked on the UK presales team for 3 years) and is currently a Qlik Luminary! Total, he has been using Qlik for 11 years. Armand’s favorite thing about Qlik:Armand wrote a great piece on scalability and performance optimization, particularly with how Qlik Sense apps are rendered. He takes you on his journey to discover ways to bypass the no-cache policy for static content. Please check out his article* onStatic Content Cache Policy*The information in this document 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.Would you like to be spotlighted in a future post? SeeIntroducing Featured Content Friday!for more information on submitting your dashboards, workarounds, how-to’s, and articles.Thank you for being a part of the Qlik Community and for choosing Qlik!Kind regards,Qlik Digital Support
...View More
Hello Qlik Users!Not only is it Friday but it is also Featured Content Friday!Today we are featuring another long-time Qlik user (12 years to be exact) and Qlik Luminary:Radovan of EMARK!When asked what his favorite thing about Qlik is, he said:“Very fast answers (because in-memory) to complex business questions (because data is associated, not queried) on top of large amounts of data (because 10s of millions on data records can be handled on anotebook).”Using the REST connector and API’s, Radovan created a Qlik Sense app that monitors current performance and availability of his Qlik Sense environment*. Check out Radovan’s post on Qlik Community for more information as well the QVF file and steps to implement.Qlik Engine Health-Check AnalysisThank you for sharing what you created,@RadovanOresky! It's amazing to see what you can do with the power of Qlik.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, etc.Thank you for being a part of the Qlik Community and for choosing Qlik!Kind regards,Qlik Digital Support*The information in this document 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.
...View More
Hello Qlik Users!Today is very exciting! Not just because it’s Friday but it is our very FIRST Featured Content Friday! We are so excited about this new series to get to know all of you, see how you are using Qlik and for the opportunity to showcase what you all are creating!Thank you to everyone for all the great submissions! Our first creator has been working with Qlik products for 15 years! Congratulations to:Adam Barrie-Smith of Pomerol Insight!Adam submitted a great video showcasing his use of calendar measureswithin Qlik Sense. Calendar measures allow you to easily compare current YTD to the same period for the previous year, for example. Adam also demonstrated the use of variables to easily adjust the timeframe being analyzed and to create titles so users know exactly what they are looking at.Check out Adam’s YouTube video where he explains his use case for calendar measures and variables to create an easy-to-use dashboard that offers his users flexibility in their Sales analysis.Let us know in the comments below if you have used calendar measures before.Do you want to be spotlighted in a future blog? See our previous post, Introducing Featured Content Friday!, for more information on submitting your dashboards, workarounds, how-to’s, etc. We can't wait to see!Thank you for being a part of the Qlik Community and for choosing Qlik!Kind regards,Qlik Digital Support
...View More
Hello Qlik Users,I hope you are doing well!A couple weeks ago, I blogged about the new App Analyzer. The App Analyzer is a new application that was developed for SaaS clients. The application provides a holistic picture of what is happening in your tenant by providing insights on memory footprints, development analysis, threshold analysis, and RAM utilization.I’ve seen a few issues pop up with configuring the app so I figured I would create a quick blog with the errors and troubleshooting tips.Error: HTTP protocol error 405 (Method Not Allowed):Troubleshooting tip: Check the request URL that the connection is pointing to. Verify it is correct and there is not a forward slash (/) at the end of the URL.Example: https://tenantname.us.qlikcloud.com/api/v1/items/ vs https://tenantname.us.qlikcloud.com/api/v1/itemsError: HTTP protocol error 401 (Unauthorized): Requested resource requires authentication.Troubleshooting tips:Authorization is spelled correctly and there is not a space after the wordBearer is spelled correctly and there is one space between the word and the API keyAngle brackets are not being used for the keyThis information is under Query headers and not Query parametersError: (Connector error: Invalid URI: The hostname could not be parsed.)Troubleshooting tip: Verify the vu_tenant_fqdn variable is set to the correct tenant name on the **Configuration** tab of the script.Personally, I found that creating the connection can be a little finicky. If you think that you have fixed the issue but it’s still erroring, try creating a new connection from scratch.Remember that the development team is keeping an eye on the App Analyzer blog for any issues or suggestions so please comment on that blog so the developers can assist.If you found this post useful please give it a ‘like’ and make sure to subscribe to the Qlik Support Updates Blog.Kind regards,Qlik Digital Support
...View More
Hello Qlik Users!With the recent change to Qlik Sense Desktop, we have seen some users facing issues with authentication. Users are reporting the following error message:Failed to authenticate against the selected server. Please make sure your internet connection is working and try again.There are a few reasons why this error could occur.ReasonSolutionThe firewall is blocking the required ports.Contact your local IT/network administrator and ensure that the following URLs can be reached using https (port 443):*qlik.com, *.auth0.comand*qlikcloud.com.Version of Qlik Sense Desktop.Verify that you have the most up to date version of Qlik Sense Desktop installed.A proxy is being used to access the internet.It may be necessary to bypass the Proxy to log on and authenticate or to contact your local/IT network administrator to ensure the appropriate ports are opened.A VPN is being used.Disconnect from the VPN or contact your l local/IT network administrator to ensure the appropriate ports are opened.The incorrect license was granted in Qlik Sense Enterprise.A professional or user access license is required to authenticate against Qlik Sense Enterprise.For more information on these solutions, please see this article. If you have any questions about authenticating against SaaS editions, please see How to authenticate Qlik Sense Desktop against SaaS editions.Please let us know if you have any questions. If you found this blog useful, please give it a like! Also, subscribe to theQlik Support Updates Blogby clicking the green Subscribe button.Kind regards,Qlik Digital Support
...View More
Inline load is a type of data load that can be used when you do not have a data source. The data can be entered manually or by using the wizard within QlikView or Qlik Sense.Here are a couple of key things to remember:Data entered through aninlineclause must be enclosed by square brackets [ ]The columns of the table are defined in the first line of the inline load statement, separated by comas.A semi colon (;) is required after the closing square bracketHere is an example of a simple table using inline load:Load * Inline [ID, Name, Age, Title1, Wladimir, 31, Team Lead2, Paul, 22, Technical Support Engineer3, Mark, 40, Customer Support Engineer4, Janne, 27, IT Specialist];In the example inline load above, the columns for the table are:IDNameAgeTitleThe values starting with 1, are all data values that will populate the table. After loading the data, and looking at the data model, it will look like a normal table:As with any other dataset, two inline load tables can be created and be connected as can be seen below. You can also connect your inline table to an already existing table:Inline load using the QlikView wizard:You can accomplish the same result using the QlikView Inline load wizard.In the edit script window, go to Insert > Load Statement > Load Inline. A window with a structure of a table will appear. Select the top cell indicated by F1 and change its value to the name of your first column. Repeat for the other columns of your inline table. Insert the data to create the table. At the end, your table should look like this:Inline load using the Qlik Sense wizard:In the Data Manager, select the ‘Manual Entry’ option located at the top left corner of the screen.Add the table name and double click on Field_1 cell to insert your first column name. Repeat this for the other columns. After naming all the columns, you should have something like in the image below.Note that at the bottom right you can see the column count = 4 and number of rows = 0. If you Insert data, you see that the number of rows is no longer 0.For more detail information on using the Qlik Sense Wizard, please see the following resources:Manual Entry - Qlik SenseInline load DelimiterPlease 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.
...View More
.png "Former Employee"){kind=icon}