Q&A with Qlik: App Development

[Troy_Raney]

Environment

• Qlik Cloud
• Qlik Sense Enterprise on Windows
• QlikView

Transcript

Welcome to Q&A with Qlik. Today we're going to be talking about App Development; my name is Troy Raney and. I work putting together videos and webinars like this one. We've got an excellent expert panel for you today. Why we just go around the table and introduce ourselves, Ola why don't we start with you?
Just need to find the mute button; thank you so my name is Ola Roxendal. I work as a Senior Technical Learning Consultant at Qlik. Mostly, I produce enablement material for internal employees, partners, and customers; been with Qlik for about 7 years.
Great, and Patrick?
Thank you. My name is Patrick Lundblad. I'm a Lead Product Designer for Qlik Sense the Analytics part, the augmented part; been here for soon 11 years, and I'm mainly involved in the design (part of my title) trying to understand what is the require from the users; what is the best way of incorporating into our products; what is the best way of getting pleasant user experience that makes it easy to use, but still powerful, and yeah, gives you all the options that you need.
Great. Well, we've already got some questions come in so I'll go ahead and take them from the top. Do you have any plans to add field level triggers to Qlik Sense or QlikView? So, I would say when it com to QlikView, I can't answer those questions as. I just said I'm mainly working on Qlik Sense in that area around the triggers and things like that, the main thing we would start working with. Which I can't say when is to have it on objects so wouldn't be field level to begin with it would be objects and depending on what you do in the objects a trigger or an action happens just like you're having QlikView.
That makes sense, okay next question: any plans at option to select multiple fields at once to add to a visualization like we see in the new Straight table?
So, I will say my hope is Yes, actually starting with the pivot table; so we released our first Version of the pivot table before Christmas, so you can actually have it yeah as a early Christmas gift, and now we're working on a new iteration of it where we're adding in more features and functionalities. Hopefully Patric Nordström has prepared his slide deck for upcoming release and so on, but we will be adding things to the Pivot table such as chart exploration where you can pivot and unpivot your data and say what's included or excluded, and at the same time; then changing the property panel you can multi add Fields Dimensions, measures, change aggregations to it, so the new straight table already in there; the new pivot table, we're working on we'll see what happens after that; depends on what the needs is of you as users. That's fair. Okay, next question: could you show how to use the container object in Qlik Cloud versus Qlik Client Managed?
So, I can show you how you use it, probably get that later when there are a couple of questions around it, but if we talk about the difference between having it on Cloud; so I'm not going to demo now, I'll demo later, because I know there are some other questions around the container, but from my perspective, I don't believe there is any difference between having it on Cloud or Client Managed other than the release cadence on Cloud, you get the latest updates, you get the newest things first. Most often on Client Managed, you'll have to wait until the release and when you upgrade to that release. So, that would be the main difference around release cadence rather than anything else.
Perfect all right, next question: what settings would you suggest for the KPI along with an image and an icon besides? So, I guess if you wanted to include an image right next to the KPI object.
Yeah, so these some of these questions were actually prepared before. They were part of the people signing up for this webinar, so I've had this day today preparing and that's why I knew I was going to actually show the Layout Container. See if I can have the screen.
Yeah, let me stop sharing, go ahead.
I'll share my screen, second was actually looking at another question also in there. So the Layout Container; so when you use the KPI, you have options like adding a background image; you have a text; you have some predefined things you can do with it. If you want to do something outside of it, if you want to do a more, let's use the term “bespoke” or a customized KPI, I would actually more move towards using the new Layout Container instead; gives you more the options of layering things, positioning them as you want, instead of trying to tweak the font sizes and the settings to fit it, so you can do things like… I have a Layout Container here. I have a KPI inside, you could use a text object instead, you could use bar chart or mini chart, things like that. I have a logo in here. I'm using the text and image object; and I have the logo as a background on it. If I go up here, text image properties, add it as a backround image, you can also use any empty object use as a background image. I just like text object, because then I can have that image with nothing else; and I can also do something like: putting an image inside the layer container. So in this case, going to styling; saying that I want to have a background image from media library. I have a background demo image; that's not that interesting, but I can now use it in here; original size means that I can't actually see it, because it's outside the object; but I can do things like: always fit. Then it's going to put on the sides or on the top; so the extra spacing in there; in this case that might be good if you have a logo or something like that. What I have here is just an image that should work when I'm stretching it; so this case, I'm actually going to just stretch it. And now, I have a bit of a custom KPI with something on the side, and indicated colors indicate what the measure might be around. I have the logo. I have the KPI. I can freely re-size it. I can have either a static font sizes, or I can have responsive font sizes and things like that. So if you're not happy with what the KPI can give you, I think another option would be using the Layout Container and any object we have in our product or any extension you're using inside there to create that more custom look and feel.
That looks great.
Yeah. lt was a very quick demo. You can spend a lot more time making it more nice.
Definitely well we got a lot of questions so we'll move on: any plans to add layout conditions to objects for the new Layout Container? So objects can be shown and hidden rather than just layered behind while still technically there?
Actually let me grab the ball again since I have this one. So we already have a show condition inside the Layout Container. So this is one of those questions, I was asked before; so I don't know if the author of the question is here and can clarify it if I'm missing something, but if you go to an object in Layout Container, the text and image, the KPI object, there is a show condition; if I set it to false or zero, then it's hidden. I believe it's not calculated, it's not being used, and if you've been to LinkedIn or YouTube, you can see many of the people using our new Layout Container, actually adding in 100s of objects in there, creting that video game Gallery we show in hide conditions. So I think that's what you're asking for, and then it's available in Layout Container as a show condition per object. Once we actually; so the in the future is; I will take this Layout Container and we'll put that option on top of the sheet instead, so we don't have to be forced to use the grid we have today. So then in the future, you would see all the objects on the sheet. You would freely position them; have them on top of each other, and each object would have a show condition; or right now if you want to show hide, you need to put it into a Layout Container, or the normal container if you use show and hide tabs instead.
Thanks for demoing that. All right, next question: how can you change the text color in a pivot table based on conditions?
Well there is an option under the Dimensions. So in the right bar, under Dimensions, there is something where you can set both the color expression on text, but also the color expression on the field or the background value as well.
Great thanks. Okay next question: how to capture bookmark IDs from a published Qlik Sense dashboard?
So I can take this one. I think it depends on if you're on Client Managed or on Cloud.
Okay.
If it's Client Managed, I think you could use the DevHub or you could use the single - Engine API to find out what are the bookmarks in there, and what are their IDs. If you're on Cloud, let me show you quickly; then so you just got this question. I haven't thought much about it. So the first thing I would say is that: if you have a bookmark and if you're allowed to publish it, see you have the copy link option; but in order to use it, you need to publish it. But if you copy the link and the bookmark is published, then within the link in here, the bookmark ID is part of the string or the URL. But I don't; I can't actually right now think of any way of doing it for a private bookmark. There might be something, but yeah; I'm not something that I've tried before. So I wouldn't be able to say more than that.
Okay.
I could add an addition there as well. It's possible to access the bookmarks from Automations as well, so if you're trying to automate something, you could capture the bookmark, but I'm unsure on private bookmarks there; but I know (as you said Patrik) that you can can get the the public bookmarks as well; and then either use them in Automation or again from there.
Awesome. Okay next question: (I don't know if you guys are able to answer this but) we we using NPrinting 16, and would like to know if the new Version supports the same functionality? I would Point people towards the release notes, but do you have a better?
Yeah. I can answer that: both the yes and no. So if you're using NPrinting, I assume that you're either on QlikView or Qlik Sense On-Prem; and we did do a large upgrade when we moved to NPrinting 17; so there I know that we we've added functionality afterwards; and as you said there, I’d go to the release notes, but no they're not the same; but we do think that we've captured the key functionality with…
Great, thank you. Is there an option to request future functionality and where can we find that? I was prepared for a question like that. Let me just share my desktop. On Qlik Community, there is a forum called Ideation; and this is excellent. People can suggest (customers, Partners, anyone) can come in here and suggest ideas for future requests or improvements to any of our products; and you can see the suggestions that have already been submitted and upvote them. And our product team definitely takes this into consideration when it's time to introduce new functionality and new innovation; so please check out Qlik Ideation on Qlik Community, and I'll be sure to include that link. Next question: is there a public Qlik?
Not quite sure if you what they mean by that. Maybe something like Qlik desktop or…
There is a trial Version of Qlik, but I know that many years ago, we used to have very basic Version that was for personal use only. We do not have that anymore.
But yeah there's a trial Version of Qlik Cloud right like for personal use, and once you get into Qlik Cloud you can actually still download Qlik Sense Desktop, so you have a bit of an on-prem development tool. Hopefully that helps answer your question. Next one: are there any video resources that show how to create a custom REST connector connection to my Google my business to Google my business as well as the Facebook connection and Google Analytics? it's a very good question. Can't; I feel like I've seen demos and even been a part of creating REST connections, but I can't think of them off top of my head.
It used to be a app. Maybe if you Google on it to try to find it; there was an app for connection to (I think it was) Twitter back in the day at least.
Okay.
For Qlik Sense On-Prem. Haven't seen any what, but maybe it's on Qlik Community if it's anywhere.
Yeah. So I apologize for not having a more direct link to provide you, but I think Google is your best resource there: to just type in REST connector demo, and see what you can find. Next question: why Qlik Sense Cloud features not available for On-Prem Versions? That's a fair question.
So I would say: many of the features we're looking at, we talk about subscription, we talk about Automation, talk about Auto ML; all requires a pretty big and robust back end when it comes to microservices, different services. We're using a lot of Cloud specific things which it makes it really hard taking that from the Cloud and put it On-Prem without requiring pretty big server investment and maintenance and so on. So scalability and things like that is one of the main reasons; but I think that's also interesting topic for another webinar something I can help.
Sure.
I think in addition to that as well is that: we're seeing a lot of hybrid solutions as well; where the functionalities that aren't On-Prem that we see customers using the Cloud for, for those specific instances like Auto ML for example. So those those solutions are out there as well.
Great, next question: how do we access the Qlik community and blog if it exists?
So Qlik Community: you can get to it at Community.Qlik.com; and there are several blogs on here that I would recommend; especially if you're into app design and development. There's the Design Blog, it's a great resource for getting ideas and seeing what's available out there. There's also Product Innovation Blog if you're into new features and new capabilities. Those are two really great blogs there's also the Support Updates Blog, and I had the tab somewhere - the App Development Forum if you have any specific questions or issues you're having, trying to get some feedback or support on, feel free to come in here and search, see if anybody else has had the same question, or post your questions. There's a very large community of Qlikkies out there that are eager to help, and we also have several employees that are constantly monitoring this blog as well. So there's a lot of resources there to check out. Next question: can you please provide some insight on Qlik to PowerPoint export? So how can we export to PowerPoint Point?
There is the the Story Telling function. Just slipped on the name of it, but where you can create a presentation or within a PowerPoint-esque way where you can put visualization, snapshots of visualizations throughout your your application, and then add some text to that as well; and then that's exportable to to PowerPoint. Although there isn't a live connection between the PowerPoint export and the The Qlik application of course; but I think that's one of the easiest way to do it definitely.
Definitely. Okay next question: how do backups work with Qlik Cloud? Yeah it's a good one. That's kind of one of the advantages of running on Qlik Cloud is that we take care of all that backend infrastructure for you; but if anything would happen to disappear, you guys have any suggestions on what they can do?
We talk about actually what's in the product and what may or may not be coming. So one of the things we have in the product (I believe since this fall when it comes to Cloud) is Versioning. When it comes to your load script, so you can actually have multiple people working if an app is in a shared space or private space, but then you're probably alone, but then when you're working in there and you have your section you're working on, that is actually being Versioned; and you can see the different Version histories, and you can go back to an earlier Version if some of your colleagues removed something, or if you happen to press the wrong button and so on. Looking into the future, I'm hoping we'll get the same thing when it comes to sheets. Do you actually have multiple people working in the same app; not having to actually make a sheet private public; things like that; but actually just being able to lock a sheet, make changes to it, unlock it, the lock of course goes away if you're spend too long to it, but not doing anything, and then Versioning would be part of that. But for pure backup if you think it's. I mean, we have the Cloud, we're doing backups there. If you want to have something extra, then I think it's using Automation or using an external solution that would be my thought.
Yeah just to add on the Automation part there. We have Automation templates for exporting applications; that's applications both the visual side and the script, and also actual Automations themselves to platforms like GitHub, so that's also something that's available out of the box Cloud Version.
And kind of a followup to that one, the next question was: are there any plans for Version Control with Qlik Sense apps?
So as I said, Version Control is there on Cloud when it comes to the script, and hopefully maybe in the future for sheets, for the dashboards, the objects, and so also
Yeah. I know that, I feel like I saw a demo of app Automation being able to help with that as well.
Yeah.
Yeah, so there a lot of actually there. There is if you go to Qlik Learning, the Learning portal. I know that there's some videos on Automations there where we use export to GitHub import.
Thank you for that. Yeah, GitHub. All right: do you have any plans to make an option for straight tables to be horizontal in Qlik Sense as they are in QlikView?
Not that I know of. I would be using the pivot table instead. Just making certain that the; yeah, you swap the axis what is columns, what is rows that way.
Okay, next question: how can a QlikView based NPrinting report migrated to Qlik Sense without much manual change?
All right is it Qlik Sense, Qlik Sense On-Prem?
I'm assuming.
Yeah exactly. I need to refer to community or or one of those resources to see if there's a migration tool in in place. I always recommend taking the opportunity when it's time to migrate from one platform to another to look if there any way to rework and make your reports more efficient as well. So maybe taking the opportunity to go in and create it from scratch, but if there are any migration tools; probably reference those on Qlik Community.
Next question: any chance to have a Gantt view as a graphical object available?
So Gantt as its own object it's not available now. I believe you showed how to request it or put it on the wish list. I believe Patric Nordström might have some for his tips and tricks if…
Yeah he demoed. He's definitely demoed how to build a Gantt chart out of a what was it a bar chart or something?
Yeah, a chart where you use show where you use opacity to hide, a stack bar chart. We use opacity to hide some of the segments; so that would be the way to work it and that's; Patric Nordström has done it for his tips and tricks. I don't know which one of them, but they're all available on Qlik Community.
I'll try and find the link to that and share it along with this recording. Next question: can a dat- can data visualizations be created from a shared drive? You can definitely load data from a shared drive. There's lots of connectors available to be able to connect to your shared files and even On-Prem locations. Yeah, I don't know if you have anything to add to that, or I can just move on. Yeah, next question: how to gain access to ESG add-on? How does that work? I'm not familiar with what ESG add-on is; what are we talking about? Do you guys know, recognize that?
No.
All right. I apologize. Let's see if we can get some, loop back around to that one. Does Qlik allow Automation of workflows? Oh boy, does it ever! Who wants to talk about Application Automation?
Yeah. I can do Application Automation, the - So yes! We do, in the Cloud product have an out of the box Application Automation functionality where we allow Automation of workflows; example of workflows that are commonly automated as reload; multiple reload tasks where you reload applications in a sequential order, for example: exporting and importing apps to GitHub as we talked about before; and the Application Automation product works both with the internal Qlik Cloud environment, but also through a very rich API to other platforms as well. It is a product that has a tier when it comes to what what you're allowed to do with it out of the box. So automating reloads for example, that's included in the product; but then if you hit a certain amount of reloads for external APIs, and so on there there is a extra added on for that. There's a lot of good material out there on Automations on Qlik Learning on Qlik community, and there's soon going to come a new course as well on Qlik Learning which will kind of allow you to play around with it a little bit inside of the environment, so.
Great.
Yes.
Next question: in Qlik Cloud we have performance evaluation of apps. Will we get similar in Qlik Enterprise soon? There's a lot of apps out there actually. Do you guys have any off the top of your head? What would be a good performance evaluator of apps? It's off the, on the tip of my tongue right now.
I some, you go by Patrik.
I gonna say. I know of one which is the QSDA. I believe it is by Rob Wandel, like Sense Performance Analyzer or something like that, that's available in Cloud. We have the built-in App Analyzer, you can use by just right-clicking app in the hub, looking at.
Yeah, that's one I was thinking of. What, did you want to share something?
Yeah, there are a couple of monitoring applications that are available for for Qlik Sense On-Prem as well. The, when you install the product, two are automatically installed, but you can, there are a couple of more that are available where you can go down both on an app level and monitor, and look at the performance there, but also monitor environment tasks and so on. So those are available. They’re easy to install for no extra cost.
Great. Do you plan for pivot tables to have the tool tip enabled in Qlik Sense?
So yes, we plan for it. I can't say when it will happen, but we have a lot of ideas around the new pivot table, and improvements we can make to it; so while we've been chatting here, I've been typing answers to some of these questions. So I thought I’d just do a demo and just show some of things when it comes to the new pivot table if that's okay.
Great!
And Ola can start having some questions if he wants. We got a little bit more people than I think we're expected today.
Great these are great questions so far, so keep them coming. We'll answer as many as we can.
So when it comes to the old pivot table, there are some columns that you can adjust. Mainly this divider between what is the rows and what is the columns. So if I add in here to this Pivot table; if I add in one more; for example: the name of the car. Let's do it, put expanded; then in the old pivot table, that's actually not inent, the row in the old Pivot table, you are only able to adjust the rows; and you have to do it by going into Analysis mode; making the changes to it; open up the Edit button; clicking Apply. Now we're saving the width here in pixels; so that's what's available in the old Pivot table. If you're going to new Pivot Table, it's available in the visualization bundle. I think it's from the February release this year for Client Managed. It's been in Cloud since (as I said) before Christmas; so you have the new Pivot table in here. So let me just convert it to New Pivot table; and just like the old pivot table, you can go in here and you can adjust the size in pixels for these areas; but you can also do it for in here. We don't do actually a live update here when you drag it, came a little bit too flickering and so on; but I can make it larger or smaller in here for the columns. Also mainly for the bottom rows, when it comes to columns; we can also go into the new pivot table, and you can go into the different the dimensions‚ measures, or the sub- dimension; and you can go in here and you can see that we have a column width option that is either in Auto. We based on the data we have in the column, or actually Auto we split it by the screen size, how many columns you have, fit the content: what is the width of your data. That might mean that you have empty space on the side, pixels or percentages. Do you want it to be 25% per column and things like that. So here you can go in, you can either put a manual value; you can use an expression to calculate how many percent it should be. So new Pivot table opens up a lot more options when it comes to the amount of pixels or percentages for your different columns.
Fantastic, yeah. I feel like you hit a lot of different questions there; several questions around pivot table and possibilities there. There's a question about creating a live report.
So question is what do you mean with our live report?
Yeah.
I mean, we can do really quick reloads we can have a Reload schedule. I mean, when I talk to customers and users, some think a live report is having the data loader every week; some think it’s about having the data loaded every day; some think you think is every hour, every five minutes. That depends on what the definition of live is. If you want to have truly live where you go for the chart actually goes to the source data; we have the (I think it's called) the Direct Query where you can create a direct query app, for example: towards Snowflake or any other database; and then you can create some of those resource stations and they will be quering the database live for that dashboard so looking towards direct query as the solution for that if you're talking truly live going to the source data without any reload.
Okay, next question: is there an introductory training available for new Qlik users?
Yes. Go to Qlik Learning. Once again, there are a couple of Pathways depending which type of user you are; if you are just a, or not just, if you're a regular Qlik user, using the application for Analytics that's focused more on on how to actually interact with the application; and then there's a path as well if you create applications, the visual part of it. And also if you create the the script, so the back-end data loading part, so that's available there.
A lot of those introductory courses are free as well; that was a bit of a followup. I forgot to read that: are these those available free?
Yeah they're available for free. And then if you want to go more in depth, there there will be there subscription options, and all around that subject.
A question came up: looking for how to use maps in Qlik? And I believe there's a course in Qlik Learning on map objects, is there?
Yeah, so when you look for information on maps, you should have the word Geo Analytics in your back head as well, because that's part of the the map functionality. So if you're having problem finding information on maps, you could always try Geo Analytics as well, get some more information on that.
Okay, thank you. Next question: how can we calculate memory consumption in Qlik Cloud? Are there any consumption regarding the number of users that are using the app? I guess they're concerned about performance in Qlik Cloud.
They're. I would refer to the monitoring applications that are available.
Yeah; and it - the performance is a bit dynamic; so if more users do hop-on it's built to meet that demand. And if you have any heavy apps, like the actual size of the app is extremely large, there are some thresholds that perhaps might price you up a different level, but there are a lot of capabilities to meet those demands. So I guess it's good to be aware of, but it's all kind of taken care of in the back-end. Our next question: how do performance evaluation visuals? So know which elements take a time to load? I guess the same kind of question.
So I would say, talking from my experience, it is rarely the random rendering that takes time; it is the calculation. So using any of those tools for checking how long calculation takes would give the most performance Improvement. The actual running of the chart is very fast compared to other things.
Great. Next question: when the native write back solution will be available for Qlik Sense Enterprise? I'm not that familiar with that.
So native write back; not being able to. I can't answer that area. I believe we can use Automation to do write back to Source system. I've seen people using the button object variable input form, being able to click a button, and running an Automation to write back to the source and so on.
Okay. Is there a scheduled subscription to email or file transfer? I didn't quite understand that one.
So you can have on Cloud; you can have schedule subscription or emails for example: file transfer. I mean with Automations, you can probably do most of those things.
Great.
Yeah exactly. Automations is the way to go there.
Great, we're working through these. We develop apps on Cloud and deploy to QAP Client Managed server. Would we have any issue with the Layout Container? Any considerations we should be aware of?
Not that I can think of. The Layout Container is responsive. We use pixels for width, height, X and Y position. We have looked into using pixels, also that may or may not be coming. So I would say just like any chart, make it really small. Of course, every content in there would not be as readable, making it larger more readable and so on. Off the top of your head, do you remember when that new Layout Container became available in Qlik Sense On-Prem?
Qlik Sense On-Prem was in the February release this year, I believe.
Okay, so just make sure you're on that release or newer, and you should be good. Yeah. If, so if you have, if you develop on Cloud, if you put the app On-Prem; you're not using a version that has released that container an error message will be in there instead saying that: the visualization type Layout Container cannot be found on this Server.
That's good to be aware. Yeah. Can Qlik be used to create an Analytics platform with dashboards for nursing performance metrics? I would say definitely. We've got a lot of medical field demo apps available on demos.qlik.com, if you want to take a look at what's possible. Next question: in order to increase the user selection capacity, would it be possible to implement an import/export module for with different options? Import for example an Excel or CSV file with selections of what the user wanted to select. Of course it is at the user's discretion to be careful in the selections. That was a a mouthful. I'm trying to wrap my head around what they're… So, I think they want to have a dashboard where a user uploads their own data, and they get something fill in for that. I mean using APIs anything is possible, out of the box using it with inside a dashboard, not that I know of.
Okay. That's a good question. I think this was a follow-up to something that came in earlier. I know I can set up the chain of op 1 and op 2 and so on, in order to set up other options. I've lost track of the context of that. I'll move on. I need to know if it's possible to connect Qlik to Big Query using Qlik Version 2022 via a web browser. I tried but couldn't. Using Qlik 2023 app it worked. Yeah, I'm not sure.
Yeah. I did refer to Support in that case.
Yeah. I come from Support and we would probably say “you've already found your solution.” Unfortunately, but it's always good to check the release notes to see what's capable of the Version that you're actually running; and's see if that is available. And it could have been that maybe they had some issues in the version that you're running; so when in doubt, always double check the release notes. And those are version-specific. Qlik Sense Client Managed I'd like to create a line chart with 2 Y-axises; one for absolute value, the other for percentage. How can I do that?
Yay! So let's, so depending on what type of line chart you have. Let's do a demo again.
Awesome.
I think just seeing us answering questions might be boring towards them. So you don't actually want to use the line chart object for this. You have to use the combo chart if you want to have two axis. So in this case here, I can add for example, the Dimension should be Years. And then I can add here, I can add in a Measure, such as Average Work power, it put us in as bars to begin with; if you open up the Measure, you can go in and click the More Properties; and you can switch it to a Line, and then if you add in one more for example. Let's do the Average Work Power again. Let's break this one, and then you can go in here and use the Modifiers; and then I think you can do as relative numbers. And then I think it's respect mention. Yeah, you have some options in here for using percentages that you can calculate. I'm not certain exactly why, yeah in here. So now you have one axis absolute value, one axis with percentages; of course being the same measure, it's the absolute value and percentage is going to be the same here. You can certainly not add in two dimensions in here; so you would have to add in - if you have a dimension with a couple of values, like continents or something like that; you would have to use set expression, and add in one measure for every component that you're doing. And while we're here, we have the next question: are there any plans have functionality to be able to click on a bespoke visualization and there be sort of analysis tool that creates live commentary/text? You can be add to the sheet to enhance the Insight? We do have an NL Insight object today that I can add in here to the sheet. And then I can pick and add the chart; and I can pick any of the chart that I have on the sheet in here. So I haven't put a name on this object; that's why it's the ID of the object. And it says Combo Chart, but if I go up in here, and I say my Combo Chart; then when. I Qlik on ADD chart down here you'll see my combo chart as an option and then when I click here; I've linked this, and the inside object. Okay it's too little data, but had it been more data in here, it would have put out some insights for that one. Let's see if there's - that was Siri saying hello to me. Let's see if we have a table in here. For example: this is a details table with a little bit more data. Let's switch so that it's not that chart. Let's use the table. Hopefully this works. Of course I'm unlucky today with a demo. So you could do this for - click one chart, connect it to the NL Insight; see what type of insights have been found for it; if you want to have multiple ones; I would use the tab container; and I would hide and show the different tabs, and I would have a button next to every chart and say: click “View Insights,” and that NL object would then be visible inside the typ container. It's a little bit more of setup if you want to have it per chart, but you already know that which charts you want to have description for; you can add this object in here and hopefully you're slightly more lucky than I am right now. That's with the live demos and questions.
Yeah. I appreciate you, yeah, demoing. We are developing dashboards using only Layout Container. My question is regarding performance. Should we see Major Performance and rendering hits using Layout Container as the main element versus the normal way?
I don't think you see any real difference, other than you can probably add in a lot more objects into a Layout Container than you can on a sheet. I think a sheet is limited by the grid lay container. I don't actually think we put in a limit, so if you want to have a thousand objects in there, feel free to do that. I don't believe there's any extra performance; not that I can think of now.
Great. I'm trying to set up email notification settings in Qlik Cloud settings page. I've struggled with it and was told by our IT Department that it will not work with our company's Outlook setup. Essentially entering a username and password with Qlik to access the SMTP server is not secure enough and Outlook will not allow it. I realized there were some changes, I'll finish the question. I also found online other Qlik Cloud customers facing the same issue. Is there a work around for this or what does Qlik suggest? I personally ran into this myself setting up a Qlik Cloud tenant to connect to an SMTP server and I found that Microsoft and I think Gmail or Google has recently made changes to their SMTP servers to require more strict authentication, and basic username and password doesn't work that well anymore. There are some workarounds and there is an article in our support knowledge base on Qlik Community; and I'll try and search for that and find it in a moment. So it is a known issue; it is relative to Microsoft and Google, if you face it on Google; but I believe there is a work around, so I'll try and find the link to that. Next question: I would like to know if a connection created within a space can be used by applications from another space? Should projects use the same connections be in the same space? That's always a good question that comes up. So can Data Connections in one space be used by apps in another?
I believe so. I believe that's part of the security that you can have, one group, one space for a certain amount of users; and another space for another; and you can actually have your connectors connections inside one space, and being used by others. So I believe so, but I haven't done it myself.
It all comes down to permissions, I think. So it's good to check that the users trying to access it have permissions to the data source.
Exactly, and some data connections if you're having problem seeing them, it could be that they're they're user; connected to a user, not to space as well. So something to check.
Great. Layout in terms of the company or institution colors is it a must to use this, or just how the developer understands data?
If we talk about company branding. I think it's up to the company you work for. If you're forced to use the company brand color or not in your dashboards; or if you have other colors that are of use. I would say the best thing is: to have maybe not use the brand colors, because sometimes those brand colors are not perfect for visualizing data; but at least have a couple of colors that you and your colleagues have decided upon, so that all the dashboards are using similar colors for similar things; like what is the primary color? Is it green to indicate that this? Is the important value? What is the color for warning? What is the color for something bad? Things like that, but which colors you use very much up to where you work and what the requirements are.
Yeah and you can always Implement background images or watermarks if you would like to yeah add something. Next question: will there be a solution for showing of HTML formatted text inside Qlik Sense objects like table cells within table objects or pivot tables? When Source data is HTML enriched text. I guess it could be like a popup maybe.
Solution, not that I can say anything about. We do know that there is a requirement. I'll come back to The Qlik Innovation blog. Some of these are, some of the other questions I've seen are also asking for a certain feature of functionality. Do use the Qlik Innovation blog. Do see if the ID is already in there, and if so give it a thumbs up also give it a comment, if you can maybe expanding on the use case telling us a little bit more about what it is you want to do and why, and if the idea doesn't exist; make sure that you actually add it in there and feel free to talk about it on community and getting other people involved in, and so we do look at the -and we do take that as part of our road map to see what we want to add to the product and how…
Great. Next question: how to hide certain sheets to certain users? For example, don't want to show all the sheets of certain users of used. We're discussing the On-Premise version.
So we have a show/hide condition on the sheet where you can either use a variable, and of course you're going to have to use buttons and user clicks on a button and then the variable is set to what type of user are. If you want to look at who the user is; you're going to have to use Section Access to find out what type of group they're in, and what they're allowed to see, or what you want to present to them or not; and then you can use the show/hide conditions. So that’s depending on your Section Access group, you will hide and show certain sheets. But we can't say that a certain user has a certain sheet. It has to be connected to the data; therefore the Section Access part. I think that one when I was out building applications for customers; our recommendation was usually that: if you have groups that need to see different parts of an application, rather look at publishing two different versions of that application, if you want to go into the sheet level and and look at that. Because otherwise it'll come very messy quite quick with both Section Access and all the other stuff that was talking about.
Thank you. Okay: how to replace the default selection of a field given in actions with a selection from previous sheets while navigating to the sheet.
So normally in Qlik Sense, when you do a selection, you don't do it per chart. You don't do it per sheet, it is a global thing. So if you navigate from one sheet to another sheet, it should be the same. Then the question is: if you for example have a trigger or something or an action that overwrites it; then I mean, you can add action to do a certain selection on a sheet. I don't know if you can do an action to do a certain selection while still keeping the user selection or not. I think it depends on how you set up your app, and the fields and things like that. But normally, a selection carries over from one sheet to another.
Yeah: how to update existing bookmark every day with the current date?
Yay one of my favorite topics. So I'll share my screen again. So normally when you do a selection on a bookmark, here for example. I have some couple of cars; and I have it by year. It's one of my favorite data sets, that's why I always use it. If I do a selection here on 1982; if I go up here and I click the new bookmark; and I say: demo bookmark. Great, and then I click on Okay. If I click the Information button here; you will see here that there is a set expression that says year is 1982. Click on it; so that means that it is a static bookmark. That's one of the where you have to go in and update it every day. You can use the replace selection. What you can also do is: you can go in here and you can add a filter pane, a table or something, that would you feel that you want to use. You type in, I have a cheat sheet down here on the left: equals the field that you want to do your selection in; equals in first is; because it's a something that needs to be evaluated. So that's, it's an expression, search expression; and then equals, and then you can have in your expression function; in this case: I want to find the maximum of all years; and this is the important part: if I click this value, click okay; I'm still doing a static selection. If I click the Enter button, and then click the Close button; now I actually Dynamic selection. So if I go in here and I say: demo Dynamic selection; and I create it. Now if I click on Okay here; and if I open it up; you can see it's actually the expression that is in here within a bookmark. So compare that to having the value part of the bookmark, and having the expression. This means that whenever I reload the data, there's a new day, there's a new year, or something like that. There's a your car; then it will select the latest value within that field, so that's a dynamic bookmark compared to a static bookmark. That's great. Thank you. When using a master calendar in combination with Section Access, should it be possible to ignore the Section Access applied on the master calendar? Not quite sure how the calendar Works in combination with Section Access.
So Section Access sets row and column level security on your on the data model itself. So it depends a little bit on how the data model is set up, but if the data model the is the associations are set in; set in; set up in such a way that there is an association which you're not allowed to view, because you allow to view that column or view that that row, you won't be able to to see that data.
Great thank you. And these are all great questions. We're getting close to the top the hour. We'll answer as many as we can. Is it possible to track actual users that look at certain sheets within an app and not the app as a whole? So sheet-level auditing.
Yeah, through monitoring applications. It depends which platform, but if Qlik Sense on-prem for example, you can view that through the monitoring applications we've talked about before. You can view exactly which users access which sheets, which objects on those sheets, so on.
Great. Next question: what is the best sheet size under custom width and height as in pixels?
So that depends on your users. I'm of course always using a high screen resolution: 1920, 1200 something. Maybe some of your users are on laptops with a small screen size: 1280 or something. So it depends on what they're using. The main thing to think about which is a bit tricky is: that the screen size you're putting in there is not the screen size of the entire Sense product. It is the screen size of the sheet; so you have to account for: do you have a sub bar enabled or not; do you have a top bar or are you embedding it; does the user have a bookmarks bar in their web browser; and things like that. So I would say the screen resolution that is most commonly used and then doing it down on the height slightly. So that they don't get the scroll bars.
That's a good tip. Next question: can we create a square pie chart? It should take two dimensions and inside the squares it has to show two different measures.
I think and I'm probably not going to have the time to test it now; but we have in the custom objects in visualization bundle; we have a grid chart actually. I can quickly just share my screen. I can add two Dimensions to it. I can add Country. I can add Year. I can add a Measure: average horsepower. Of course, I have a selection up here. Let's ignore that. So I'm not getting a square pie chart, and I don't have two values in here; but I can change the presentation. Now to be, let's see layout should be a heat map instead. And then I can do: so you have two values on each side; two values on each side here. So I think you could do something like this; then you would have to rescale it; if you want to add in two measures, you're going to have to use the Dual option to get two measures in there and so on. I would say that's the closest I can think of that works right now, but there may be other ways of doing it also; or you can use a Tree as someone just said in the chat, Tree Map them. It doesn't actually put - if you make them equal to size, then you can use a tree map with 2 by 2, yes.
That's great: is it possible to specify column width in a pivot table?
I think. I answered that. You can do, the put a new pivot table that is in the visualization bundle released on Cloud before Christmas, and client manage on-prem in February. So yeah.
Great, and do you guys see any questions that you feel like you've got a burning answer for.
I have one that's interesting which is: any plans to offer folder organization options for sheets and bookmarks? Yes. I'm hoping so; it's something we're looking into: being able to have groups for sheets, so they don't have just a list of sheets.
Great. And see if we can squeeze in one more: will there be a solution for a date slider filter, not variable input with two nodes for start date and end date which makes it easy for users to find the date range?
Also something we have on the road map. I'll come back to go to Qlik Innovation blog. You'll probably find that as an idea in there, I'm pretty certain. Make certain to give it a thumbs up that makes it come higher up on the road map.
Great we've got lots of questions, but we're nearing the top of the hour and I appreciate all the wonderful questions; and thank you so so much to our expert panel: Ola and Patrik. I appreciate you guys working through this. We got through a lot of questions, and I realize there were a lot we didn't get to, but I hope you stay engaged. And if you have further questions, there's always the App Development Forum, is a great resource so you can post questions and hopefully get some answers there as well. Hope everyone has a great rest of the day. Thank you so much.
Thank you.
Thank you.