![]() Please note they will look bland on Internet Explorer but should show up nicely in Firefox or Chrome, so you need to test from the devices of your users. They also work in KPIs (to show up nice and big), export to Excel and PDF OK (but don't look as pretty). If(closed, Dual(' ',1), Dual(' ',0)) AS ,Īnnd you can even sort by or filter on our little picture friends: running a count on the screenshot below would give you 6. In this instance I set it up as a Dual to retain the 0 or 1 of the underlying data for counting purposes. Using this method if they add the Closed flag they can see it is closed. Sure we could use conditional formatting, but that relies on the user configuring it for each table they are building (unless there is some Qlikfu to 'tag' a column for conditional formatting, hint hint). Next up the stock order table, wanted to show a quick visual way whether the order was closed or not. (Emoji's are actually just rendered as text, not images, so there isn't even an image there to attach hover text to). Unfortunately we can't set the hover text on the emoji to show what the issue is, so we'll still need a Warnings tab of some sorts. Append warning emoji to procedure name if has exceptions I'll come back to the 'ApplyMap' bit later, but either of the lines below would achieve the same result. ![]() In this first screenshot I've set the Procedure name up to append a warning Emoji if the procedure has exceptions. Thankfully, it survived a Load Data and made it through to the data Table I was working on: To my surprise it pasted into the editor pane and showed up among the Console font text (I thought at least would have to do some special Unicode /x01513/ string or something to make it work). Went to looking for a Warning symbol (which looks nice and Yellow and sufficiently warning in Firefox) and pasted this into a string in Qlik Sense. Couldn't find anything online except someone having issues with Emojis in source data freezing Qlik So I thought I would try out using Emojis in Qlik. My current text exception column is taking up precious screen real-estate and 'Ex Procedure Has Exception = 1' doesn't mean much anyway. Next part of the challenge - how do indicate this to the user. (I mention all these because I'd love to know what solutions people have come up with, maybe someone out there sees this and things 'oh I can explain how to do that in a forum post!') ![]() Unfortunately none of the above solve my original question of how do we warn users about this datum. So I reverted to prioritising the exceptions in an if statement, and just setting 'Exception' to be whatever reason is matched first. Also not a job for today, and I don't think our Qlik partners would appreciate trying to debug that!įinally I was going to try appending a written exception into a single column, but again I don't have enough Qlikfu to figure that one out. from a data quality page) to find out what exceptions each row had. But because of the coding you can still separate it out later (i.e. That way I could at least use one column in each table as an Exception column, and be able to indicate a number of different exceptions all in the same field. you might have come across these before if you've ever had to change settings in the registry. Next I considered using bitmask status codes. I'd still like to figure this one out, but this is not a job for today. To be effective though one would somehow have to then have an Exception link table and insert a row dynamically linking back to any rows in any tables which had data quality issues. My first thought was 'could I setup an Exception table', which could have different numbers and exception reasons linked. ![]() ![]() So I searched for a better solution, for about an hour. But I don't want to rely on having to do that, let alone if other staff are building any of their own apps. Maybe in QlikView this might work because the experience can be more tightly controlled you could set up a Data Quality tab, add in all of the various exception flags from around the data model and then filter each of the exceptions. Our data model has quality checks as part of the data load scripts, and was reporting these to various exception flags. One area I was considering today was how to better communicate to users when there might be something wrong or they need to be aware of with the data they are looking at. I'm a newcomer to Qlik, and am working on implementing Qlik Sense for a hospital. ![]()
0 Comments
Leave a Reply. |