A New Adventure – DataGlow IT

I’m sure most people have experienced a time in their life where the timing just felt right to do something.  For me, one of those moments came along in the last year or so where i saw an opportunity to reach out and go for it into the world of consultancy and being my own boss.

And well, today that ambition of mine was truly realised.  Today, i officially launched my new company DataGlow IT (www.dataglowit.com).  I have been working incredibly hard in the background to time everything to coincide with the ongoing Qlik Qonnections world conference in Orlando, which i’m lucky enough to be attending.  Although it’s a brand new experience having to fund it myself also!

Introducing – DataGlow IT

Today’s been crazy, and i’ll be honest with you – i binned off a session to be writing this, but i don’t regret it.  I’m still recovering from the thrill of this morning, seeing my extension, along with branding for my company presented by Qlik VP of Products, Anthony Deighton on stage at Product general session.  I have no words to describe how i feel that this happened!

DataGlow IT Qonnections

My Qlik Sense Beeswarm extension, DataGlow IT branded, and presented  by Anthony Deighton at Qonnections General Session.  Wow, tell me i’m not dreaming!

Meanwhile, in the background, I’ve been preparing my website specifically to be ready for Qonnections.  I had a funny conversation with Qlik Dev Relations dude Brian Munz about late-night-hacking-on-the-night-before-a-presentation syndrome, and it was kinda the same for me.  But we’re all up and running now and i’m truly proud of that.

DataGlow IT homepage

DataGlow.com is alive!

Qonnections has only just begun, but it’s been just amazing so far.  A more comprehensive blog post to come for sure, but now, it’s back to the pool.

P.S. I actually mean heading back to find out about the Picasso.js visualisation library Qlik is open sourcing, the pool is only wishful thinking.

Anyway, if you think it might be cool to work together, head over to DataGlow IT and contact me.  Or just Tweet me if you’re in Orlando right now anyway 🙂

Until the next Qonnections update, remember to makeitqlik!

Advertisement

Sensify your CV (Final Part and Download)

In Part 2 of Sensify your CV, we looked at creating the Summary and Roles tabs, and also discussed at some length the issues around responsive scrollbars and layout issues in general.

Now, i know you’ve likely only continued this far to get your hands on the app itself, so rest assured it will be made available at the end of this blog. “Yay!”, i hear you cry. Maybe.

But before then, we have some work to do, not least the following:

  • Finish off the Skills and Qlik Dev Group tabs
  • Add some simple, but effective styling to our app to spruce it up
  • Get our app uploaded to Qlik Cloud and manage who can see it

Creating the Skills Tab

The good thing about the remaining tabs is that they mostly use the principles we’ve already discussed. There’s not too much to know about the Skills tab except that it’s all about spacing and how much content you want to display, and personal preference. In my case, i had 5 core Technical Skills i wanted to show off, and 4 Certifications and Awards.

Note: As i was progressing, i tried a trick i use often in QlikView, which is to copy over objects from one app to another (I had already built the app for myself, so i needed to generic it up a bit for this blog). In QlikView, it was easy to copy across a text object with an embedded image. In Qlik Sense, i can’t do that. If i try to copy across a text and image object with an image inside i get this message:

copying-bundled-images-is-not-supported-makeitqlik

Rather unhelpful, and perhaps something to improve on in the future. I might even visit Aaron Couron’s recent blog post regarding 16 things on my Qlik Sense Wish List and note it there. While we’re there actually, let’s add an option to Select All objects on a sheet from one app and paste them into another, a la QlikView.

I’m also intrigued to know if Qlik Luminary Goran Sander’s rather awesome looking Sense App Duplicator Extension might deal with this issue.  For further investigation from a different angle.

As you can see in the screen grab below, i have tinkered a bit with the sizing of the objects, with everything not necessarily being directly symmetrical and aligned. It’s worth noting that apart from the KPI navs on the right, everything else is just Text and Image objects. When you download the app, you will see the mix of settings i have used, but generally, it’s Background Images for the images, and mixed font sizes for the Technical Skills text objects to differentiate between headings and skills.

Skills tab final edit mode makeitqlik.PNG

Laying out the Skills tab

Building the Qlik Branch Tab

To be clear, i built a Qlik Branch tab because that’s where most of my online demos are held, but you could easily flow this in another direction. Perhaps this tab should be named My Work or something similar.

Anyway, I’ve decided to demo 6 of my extensions in this tab. The format for each extension is the same:

  1. Separate text and image object containing an inserted image of the extension (green)
  2. The image links to the Qlik Branch project using the Insert Link functionality we used in earlier episodes (red)
  3. A second text and image object that contains headline title for the extension, an explicit link to the Branch Project and a brief description of the project (blue)

Qlik Branch Extension Example makeitqlik.PNG

Template objects for linking out to a Qlik Branch project

Note: Did you know you can embed animated GIFs in Text and Image Qlik Sense objects? Neither did i until i tried it to show the functionality of one of my extensions in this app. You really do learn something new every day!

Once you have created one correctly, you can Ctrl C+V your way through to create the objects you need, changing images and link locations (don’t forget!) as needed.

Note: It’s worth noting that responsiveness and font sizes across multiple text objects become more unpredictable and difficult to predict as you increase them in volume. Don’t pack your screen too tightly, as you could find a smorgasbord of different font sizes. Keeping approximately the same amount of text in each descriptive Text object helps also. If in doubt, use another tab.

Building the Qlik Dev Group Tab

I’m seriously at the risk of repeating myself now, so I’ve enclosed a screen grab of the finalised Edit Mode for this tab.  Of course, use it for something totally different or for nothing at all – it’s up to you!  No new techniques, just text and image objects, KPI navs and spacing.  Should be easy for you guys now!

Finalised Qlik Dev Group tab edit mode makeitqlik.PNG

Images, text, spacing….you get the idea by now

We’ve done it!  We have built our CV app.  Good work!

But are we done?  We are not.  There’s some things we can do to make our app look even better and more professional.  Let’s crack on with some improvements.

I’m a (Qlik Sense) Professional

Everything we have done so far has been very tab oriented, but now we want t focus on the first impression the app gives when a recruiter or potential employer opens it up, so let’s focus on a few options.

Adding an App thumbnail and some flair

From any tab, in the top left hand corner, hit the App Overview mode.  You will reach a screen like the below.

App overview grey makitqlik.PNG

That’s a bland CV app right there!

Pretty grey and horrible, right?  I would not want to hire that guy/girl!  Time to fix it.

Hit the Edit (pencil) mode it the top right hand corner.  Once you do that, you will notice that the thumbnail image for the app becomes editable, a let’s Change Thumbnail.  I knocked something up in Paint in a few minutes which incorporates the logo of some of my core skill and my profile photo, but i’m sure you can do better.

Now hit the top right hand cog for App Options.  I set up the following settings on my app:

  1. Background color fades from light green to dark green
  2. Font color is white
  3. Image is my profile photo
  4. Image alignment is right

App options makeitqlik.PNG

Adding some colour and profile image

Now let’s open one of the tabs in our app and see what it looks like:

Summary tab with styling.PNG

Looking a bit nicer?

Looks quite a bit better; at least i think so.  The small profile photo in the top right is a non-offensive size, and the green gradient at the top suits our Qlik profile to a tee 🙂  This is replicated across all tabs automatically to give a universal look and feel.  Play about with the App Options and see what you think looks best!

Finally, we want to create some thumbnails for each tab, so that our App Overview gives a nice overall feel for how the CV looks when someone opens it up.

I would suggest that for each tab, it’s worth taking a screen snip of each tab and storing it in the default content folder C:\Users\xxx\Documents\Qlik\Sense\Content\Default .  You can then apply the image by clicking into the Details (redsection on each tab and then Change Thumbnail (blue) as per screen below:

app-overview-tab-thumbnails

If we repeat that process for all of our tabs, we get a really nice looking App Overview screen, that is indicative of the information each tab provides.

Finalised App Overview makeitqlik.PNG

On the other hand, I would soooooo hire that guy 🙂

And ladies and gents, that pretty much completes our app.  Hopefully you agree it looks quite professional now, so now (after some rigorous testing of course!), we’re ready to get this thing on Qlik Cloud.

Optional Improvements:  There’s still more you could try here:

  • Descriptions for App Overview and all tabs
  • Adding a storyboard and / or bookmarks to drive the user through your app.

I would love to see some examples if you decide to go down this route.  Ping me!

I’m (almost) on cloud 9!

Now we have a quality CV app, we need to upload to Qlik Sense Cloud.  Go to Qlik Sense Cloud and either log in or register if you don’t have a Qlik account already.

qlikcloud makeitwlik.PNG

Getting Started with Qlik Sense Cloud

Once you are logged in, we need to upload the app by clicking on the My Work (red) section, then New App (green), and then selecting Upload an app (blue).

Qlik Sense Cloud upload app.PNG

Having uploaded the app, it’s still not available to anyone yet whilst in the My Work area alone.  To make it available we need to Publish the app into My Stream.  We can do that by right clicking on the app in My Work and selecting Publish.

Publish app to My Stream.PNG

Now you should see your app in the My Stream section.

Note: Please be careful of both the apps and the people you are sharing with.  In the free version of Qlik Sense Cloud, all apps in My Stream are shared with all invited recipients.

If you need more granular security than this, you need to look at the paid packages for Qlik Sense Cloud.

The last major task we need to accomplish is to explicitly share our app with recipients.  To do this, you need to know the email address of the person you want to share with, and it’s also important to note that the recipient needs to have a Qlik Sense Cloud account to view your app.

The sharing process is relatively simple.  When in My Stream, on the right hand side, there’s a Share button.  Press it, and enter the email of the recipient.  Then you’ll be informed of the user being in Pending status as per below, whilst the recipient has been sent an email asking them to view your app:

Cloud Pending share.PNG

Once the user has logged into Qlik Sense Cloud – they can see your app.  Yes!!!

The beauty of having this method of delivery is that you can add and remove viewers at any time.  You are limited to 5 shares with the free version, but it is very powerful to be able to offer this live showcase of your skills to employers, recruiters, or even actually in an interview itself.  And they cannot edit anything in your app or download it.  So really, it’s perfect for this situation where you need to give potentially a large amount of people temporary access to your CV app.

And if you need to update your app, you can simply Unpublish it and upload a new version when you’re ready.

Download the app

I hope you managed to try some of these things in your own CV app, but if it’s the app you want, I’ve set up a project on Qlik Branch where you can download it.

Hope you enjoyed this project, and please comment and let me know what you think.

As a final note, its been mentioned to me a few times that this projects could be improved a lot by using extensions.  I agree on this point wholeheartedly, but my aim was to produce something usable by everyone, with no dependencies.  Having said that, i can think of several extensions that would make this app better, so maybe another iteration of the Qlik Sense CV will become available on makeitqlik at some point in the future 🙂

Until next time, happy qliking!

Best,

Brian

Sensify Your CV (Part 2)

Update: The final part is now available here!

In Part 1 of Sensifying your CV, we created an underlying data model for our Qlik Sense app based on our CV.  We also started to create a navigational structure to move around our app easily.

So, onwards!

Creating Master Items for Nav buttons

First thing is to right-click on the Skills button we created and select Add to master items.  You will need to give a Name at least to your master item.  In this case i have called mine Skills Nav.  You might want to add some description and tags (which can be useful for Visual Search in a Qlik Sense app), but we’re gonna keep it fairly vanilla for now.  Click Add and you should have your first Master Item.  Booyah!

add-to-master-items-makeitqlik

The button we created obviously jumps to the Skills tab, but we need at least 4 other buttons to go to the Summary, Roles, Qlik Branch and Qlik Dev Group tabs.  The easiest way i find to do this is to create duplicates in the Master Items menu, which you can find as small chain link icon on the left hand side.

Once you have located that, you can then just right click on your Skills Nav object and hit Duplicate.  After that, it’s a case of changing a few properties on each duplicated KPI object to match the tab you want to jump to:

  • In Data, change the Jump To Expression to the text of the tab you need i.e. Roles
  • In Appearance -> Presentation -> Link to sheet, change the dropdown to the sheet you want to link to.
  • In Appearance -> Master Item Details, change the name of the KPI to reflect the sheet you’re jumping to i.e. Nav to Roles etc.

You then need to repeat that process until all of your KPI nav objects have been created.

Optional: In the version i made for myself, i alternated the colours of the KPIs i would be using on each sheet between light and dark green.  If you want to do that, you need to duplicate each KPI again, and change the Color  in the Jump To Measure.

Once you have completed your Nav buttons, spend a few minutes putting the right Navs in the right sheets.  On a standard Qlik Sense design grid, i have 6 x 3 for each nav on the right hand side.

finalised-navs-summary-sheet-makeitqlik

Positioning Nav buttons in your app.

Building the Summary tab

Our navigation is in place now, so let’s start on our first tab.  It’s worth noting that from this point onwards, we’ll be dealing with a lot of Text and Image objects, and much of what we need to do is configure these to get the right look and feel and balance.

In the Summary tab, there’s several components:

  • 3 highlight / call to action images on the left
  • A personal photo, contact details, and Profile statement in the center
  • Navs on the right

Aside – It just don’t look right!

Formatting the highlight images posed the first noteworthy issue in the app build.  There’s no two ways, images can be a bit of a pain in Sense.  In general, there’s 2 ways to embed an image in a Text and Image object – you either click the picture icon and import from the content library, or you set a background image.

Just pick either one, you might think?  If only it were that simple…

If you don’t need to link to anything, probably using a background image is best.  You can set the Positioning and Sizing attributes and you’ll generally avoid one of the banes of my life in Sense – the Responsive Scrollbar!

However, if you do need to link to a URL or such, you need to Insert an Image into the object and then Edit Link.  That’s all cool and fine and all, but try resizing your app in the window or in Chrome and see what happens  – Responsive Scrollbars.

responsive-scrollbar-makeitqlik

It’s a goddamn responsive scrollbar – argghhhh!

Now honestly, i don’t have a real solution for you, but my advice is: be careful.  Your app might look beautiful on your 4k high resolution TV, but scale it down a bit and play with the responsiveness to see how it behaves overall.

Another nice surprise is that this also happens with Text!  So again, don’t assume that setting all the font sizes to XL or L and letting Sense handle responsiveness resolves the issue.  You should treat each object on it’s own merits based on the amount of text against the size of the object.  You might even have to play with the size of the object to get the responsiveness to flow just the way you want.

Rant over.  For now.

(Back to) Building the Summary tab

background-image-attributes-makeitqlik

So, you need 3 text and image objects, set a background image on those unless you want to link, for reasons discussed above.

Remember to set the Sizing to Always fit and the Position to Center

Create another text and image object and plonk your profile pic in there as a background image.

And another text object for your contact details.  I spent a bit of time tinkering with the format and especially the font sizes but settled on something like the below.  Remember to set the URL links for stuff like Twitter, LinkedIn, blog etc.

Finally for this tab, you need a text object for your Profile.  You could easily load this in from a data source, but for now, and i’m doing a big ole’ copy paste from my CV.

Remember that you can format parts of a Text and Image object individually.  So you can make the text green bold and XL in one part, and red, underlined and S in another.  Be guided by the Responsive Scrollbars.  If they’re around, you need to resize either your object or think about your font sizes.

So, when all is said and done, your Summary tab should like a bit like the one below:

finalised Summary tab makeitqlik.PNG

Clean, simple Summary page and not a responsive scrollbar in sight.

Know your Roles

The Roles tab is where the meat of our interactivity will be, utilising our data model.  We’ll need several objects here:

  • Filter Pane to show our various Positions
  • Table object to detail our Employment History
  • Pie Chart to show our Skills Utilised
  • Text objects for Client List, Role Details and headings
  • Variables to get things in the right format

Creating your Position List

We want the position to incorporate the Company Name and the Position, so whilst we could create that in the script, let’s make it visible and changeable as a Master Item, as shown below:

Position Master Item makeitqlik.png

We then want to create a new Filter Pane for our Position Master Item and place it on the sheet.

Adding the Employment History

Create a Table object and add the following fields as Dimensions

  • Employer
  • Title
  • Website

In order to make the table always show the full Employment History when selections are being made (otherwise this tab can look a bit spaced out), we need to add to add 2 Measures for the Start Date and End Date.

These Measures use the Only() aggregator and some {1} Set Analysis to ensure that we’re always looking at the full Employment History.

Start Date Expression: Only({1}[Start Date.autoCalendar.YearMonth])

End Date Expression: Only({1}[End Date.autoCalendar.YearMonth])

Note: You might notice that the Start Date and End Date has automatically had a calendar created with it.  This is a nifty feature, and saves having to create Master Calendars a lot of the time in Qlik Sense.  Neat!

employment-history-makeitqlik

Now when you make a selection anywhere in the app, the table and it’s full contents are omnipresent – just what we want.

Showing our Utilised Skills

This is down to personal preference, but i like using a donut variant of a pie chart for this.  (Mainly because of the spinning pie chart easter-egg you can invoke by rolling the mouse wheel when on the object )

Create a new Pie Chart in Sense, and add Skill as a dimension.  For the Measure, use the Percentage field.  Change the Appearance -> Presentation setting to Donut and you should get something like the below:

Optional: Now, you might be happy with the default colours or the options that Sense offers, but i decided to Qlik-ify my chart with green and used the following expression under Appearance -> Colors and Legend -> Colors -> By Expression:

If(Skill = ‘QlikView’, ARGB(255,0,255,0),
If(Skill = ‘QlikView Server’, ARGB(120,0,255,0),
If(Skill = ‘Qlik Sense’, ARGB(90,0,255,0),
If(Skill = ‘Qlik Sense Server’, ARGB(70,0,255,0),
If(Skill = ‘nPrinting’, ARGB(50,0,255,0),
If(Skill = ‘Pre-Sales)’, ARGB(70,0,255,150),
If(Skill = ‘Training’, ARGB(120,0,255,150),
If(Skill = ‘Support’, ARGB(170,0,255,150),
If(Skill = ‘Extensions (D3, HTML5)’, ARGB(220,0,255,150), Yellow())))))))))

Pie Chart Qlikify v Normal.PNG

Qlikified Pie Chart vs normal – you decide

Role Details and Variables

In order to read out the details for our roles from our Excel sheet, we need to create some variables that we can drop into a text object at the correct place.

We can create variables using the small symbol in the bottom left hand corner in Edit Mode.  Then we Create New variables as per below:

Repeat the below for vBullet1, vBullet2, vBullet3, vBullet4, vBullet5, changing vBulletx and [Bullet x] accordingly.

vBullet1: If(GetSelectedCount(Position) = 1 and Len([Bullet 1]) > 0, ‘ ● ‘ & Only([Bullet 1]))

vComments: If(GetSelectedCount(Position) = 1, Comments)

vSelectClient: If(GetSelectedCount(Position) 1, ‘Please select one Position to see’ & chr(13) & ‘the Role Description’)

vComments reads the Comments field, which should always be available.

vBulletx fields show the additional achievements in the role, and are optional, as are the Bullet 1 -5 fields in the data model.

vSelectClient is used to prompt the user to select a single Position, as this format only works when loading data in from one Position at a time.

Once the variables are good, you need to place them in the Text object to make the spacing look right.  I placed the variables like below and it seems to work pretty good:

role-details-variable-position

Looks odd but produces decent results

Note: vSelectClient is kind of hidden in among vBullet2 and vBullet3.  In this case, it would be great to use an extension to have more granular control, and i’m even missing QlikView here with it’s pixel perfect capabilities and overlapping text boxes.

Showing the Client List

Our Client List is not too complicated, but it’s up to you whether you want to use it, or if confidentiality is an issue.  Better to have the option than not, right?

In a Text object you need to add a new Measure which does the following expression:

Concat([Client Name], ‘, ‘)

Now, when you make selections in your Position filter pane, you’ll get the clients applicable for each Position.  Assuming you modified the spreadsheet!

client-list-makeitqlik

After this, there’s just a few more Text Objects to include to set some titles (watch out for font sizing!) and we…are…done.  For the Roles tab, of course!

Finalised Roles stab.PNG

In the Final Part…

We’re really motoring now, having created the Roles and Summary tabs.  Nearly there, and in the final part we’ll finish with:

  • Creating the Qlik Branch and Qlik Dev Group tabs
  • Styling our app to make it look more professional
  • Upload and distribute via Qlik Sense Cloud
  • Links to all the files used for this project and final app

I hope you’re still with me and will makeitqlik for the last part.  I would love to hear our thoughts, so please comment and share below 🙂

May you Qlik happily until next time,

Brian

Sensify your CV (Part 1)

Update: Part 2 is now available here, and the final part is here!

I’ll start out with the obvious plug – i really hope you’ll share (buttons at the bottom) or follow my blog, just check out the sidebar for that 🙂  Or hook me up on Twitter or LinkedIn.  Appreciated.  Now, down to business…

The other day, i was digging through my documents folder looking for some old presentation i had done, and i stumbled across an old copy of my CV.  Whilst i glanced through it and struggled to remember some of the things i was once an expert in, it occurred to me how boring it is to read through a CV.  I mean, it really is.

What can i do about this, i thought?  I remember being blown away by Robbie Leonardi’s interactive CV – you really should check it out.

robbie-leonardi

Robbie Leonardi’s fantastic interactive CV

I appreciate that this is an insanely cool example, but wondered what could be done  with Qlik which could make things a bit more exciting, and more importantly – interactive.

I’ll also be providing (not straight away, but soon) downloads for everything i show you here, including a working Qlik Sense app, and supporting Excel Workbook to load and amend your data model – more on that soon.

QlikView or Qlik Sense?

First major decision – which tool?  I must offer disclosure at this point and say that for my day job, I’m embroiled in QlikView for the most part, so am always keen to snap up an opportunity to use Sense for something “cool”.  Putting that reasoning aside, i did decide to go for Sense.  Here’s why…

Responsive Design

Wherever my CV is being consumed, i want it to look good.  It’s going to have a fair amount of graphical elements, so i need things to flex without having to put loads of work in.  Sense is the clear winner here.

Portability and the power of Cloud

The possibility to use Qlik Sense Cloud played a really big part in my decision.  As a completely free resource, it’s invaluable in this type of scenario where ease and control of distribution is important.

When I think about the amount of times in the past i have seen my CV be “moulded” and “shaped” into something it is not by recruiters, it frustrates me.  When i send it out, i want it to stay in that format unless i say otherwise.  Cloud takes on this role perfectly.

Not only can i upload and publish a new version of my CV whenever i want, i also have total control over who is able to access it.  Even better than that, whilst consuming, recruiters or employers can view it as much as they want, but they cannot download my app.  Secure and locked?  Sold!  I’ll cover a bit on the features above in a later blog when we get to releasing our app to Qlik Sense Cloud.

Extensibility and future development

For this version of my CV, I’ve implicitly agreed to make some sacrifices.  By selecting Qlik Sense Cloud as my platform, i’m throwing out the possibility to use extensions and widgets for now, which are not yet supported.  That could pose some challenges in creating the CV i really want, but it also offers opportunity.  I can see a future iteration of this project that includes extensions and widgets, but obviously that would be tricky to redistribute – you would either need to have a publicly accessible Qlik Sense Server with all extensions installed or redistribute the app with all the extensions and how to install them – yuck.

But you know what?  Hopefully the day will come that Cloud will support mashups, extensions and widgets.  It would definitely be fun to use some of the incredible extensions out there in a project like this.  But feet on the ground for now.

Flexing your tech muscles

I always figured it would be a pretty cool moment if you could live demo your work in an interview environment, especially when it comes to your CV.  In the age of digital security that we live in nowadays, it’s become increasingly difficult to demo your past work from previous employers to display your technical prowess.

So then, this is a cool way to show you’re a boss with Qlik Sense without even have to provide a demo of your everyday work.  Bazinga.

Building the app

Now that we’ve decided on Sense, let’s start setting the groundwork for building our app.  But before we do that, it’s time to go and grab the content that we need.

Sourcing assets and storing

As a Qlik guy, i knew i would have to download some assets to include in my app.  For example, i’ll need logos for Qlik Branch, Qlik Sense, QlikView, NPrinting, D3 etc etc.

logos everywhere.png

Logos, logos, everywhere….

Save yourself some time by doing some image pre-processing to ensure that similar types of images are scaled and sized correctly, or you’ll have some formatting hoops to jump through in Sense later.

My advice is to save all your assets into your Sense default content folder, which if you’re using Qlik Sense Desktop, is:

C:\Users\YourUsername\Documents\Qlik\Sense\Content\Default

Creating CV based Data Sources

There’s no getting around this part – you need to manually dig into your CV Word or PDF doc and pull out the text that you need.  But fear not!  I’ve created a simple Excel Worksheet that you can use as a template to load in the data you need for your Qlik Sense CV:

Employers Sheet

  • EmployerID
  • Employer
  • Title
  • Website (Company Website address)
  • Start Date
  • End Date
  • Comments (A blurb describing the role in general)
  • Bullet 1 (Specifics and achievements in this role)
  • Bullet 2 (Specifics and achievements in this role)
  • Bullet 3 (Specifics and achievements in this role)
  • Bullet 4 (Specifics and achievements in this role)
  • Bullet 5 (Specifics and achievements in this role)

Skills Sheet

  • SkillID
  • Skill

EmployerSkills Sheet

  • EmployerID
  • SkillID
  • Percentage (Percentage of time (decimal) spent on skill during employment)

EmployerSkills Sheet

  • EmployerID
  • ClientID
  • Client Name

Note: Bullet 1 – 5 are used to describe up to 5 key points relating to each role.  I know it’s not automated, but given that it won’t change that much over time, and the fact it’s real easy to add more bullets, this is an accepted compromise on my part.

Hopefully the above is self explanatory.  The key things are you have a set of employers that you need to fill in the details for, and making sure your list of skills and employers are relevant.

Loading the data into Sense

Create a new app in Sense, and then simply drag in the template spreadsheet.  Everything is all named to join together correctly, so you should be good to go if you just make sure you select all tables in the sheet. Hit Load data and finish.

Add CV Data to Sense.png

If things have worked correctly (i’ve tested it, honest!), your lovely associative bubbles should look just like this:

Data loaded and in bubbles in Sense.png

I just love those bubbles and the ability for Sense to prepare data for me, but that’s for another time.  Now we have a data model to work with, let’s start creating some structure in our Sense app.

Sheets, navigation, and abusing the KPI object

My app is going to have 5 sheets, so i’m going to create those blank first.  For my purposes, i’m going to go for Summary, Skills, Roles, Qlik Branch and Qlik Dev Group, but just flex the amount of sheets to the content you will need.  You should end up like this:

Blank Sheets for MakeItQlik CV.PNG

I’m pretty aware that this app might be landing on the desk(top)s of folks that don’t know Sense too well, so i want to give them some clear navigation points in the app (even though this is built in already) and use that as a template to create all my sheets.

Normally in this scenario, i would rely on Stefan Walther’s wonderful Sheet Navigation extension, but extensions are out for now, sowe need to use another solution.  Enter the KPI object….

Obviously, that’s mainly used for displaying KPIs, but it does have another very useful secondary feature: it allows you to link to another sheet, which is just the functionality i’m looking for.  Let’s set it up.

Open your Summary sheet and go into Edit mode.  Select the Charts icon in the top left corner and and the KPI object, as below.

Create first KPI MakeItQlik.PNG

summary-kpi-measure-makeitqlik

 

Add a Measure and type in =’Skills’ to your measure expression.

Also change the label to Jump To, to make it more obvious it’s a nav button.

I’ve changed the colour to green because i can 🙂

summary-kpi-measure-link-to-sheet-makeitqlik

Then, in the Appearance settings, make sure the Link to sheet setting is on, and select the Skills sheet.

I prefer the Open in new tab setting to be off to make sure there’s only one instance of the app open for a user.

 

jump-to-skills-makeitqlik

If all this worked, you should now be able to hit Done, and when you hit your KPI button, you’ll get confirmation that you will be jumping to the Skills sheet.  Yeah!

Now we have the basis to navigate in our app, and we’ll repeat this step to create KPI objects to navigate through all combinations of our app.

Next Time…

We’re off to good start – we have a data model containing our CV details, a shell of an app and a neat and obvious way to navigate around our app.  In part 2 we’ll look at:

  • Creating Master Items for our Navigation buttons
  • Adding to our Roles sheet to create an interactive employment history
  • Explore some funky Background Image vs Embedded Image arguments
  • Apply consistent layout and import all our images
  • Some more stuff 😉

I hope you will join me for Part 2 soon, and if you have any comments, please do let me know.  Until next time….just makeitqlik 🙂

Update: Part 2 is now available here!

From me to you,

Brian

Aside

Can’t Stop the Feeling…

A few months ago, I was lucky (??) enough to take my kids to go and see the movie Trolls,  and witnessed two of the most insanely annoying characters possible lodging deep into my psyche for several months thereafter in Branch and Poppy.

Still with me?  Good.

If you are, you’ve inevitably also been subjected to “Can’t Stop The Feeling” literally thousands of times since, and despite being that “No WAY am i dancing to Justin Timberlake!” dad, every morning my kids pull me up (yeah, that’s the story i’m sticking with) and we end up doing karaoke around the kitchen with reckless abandon.

I digress, but the point (yes, there is one) is that my resistance to JT kinda feels like my resistance to starting this blog – it’s been in my brain now for longer than i can really remember, and slowly it’s worn me down to the point where i just Can’t Stop The Feeling!

So, it’s time to finally put all of the moral lessons dolled out by DreamWorks into action.  Hopefully, my passion for Qlik translates into something that somebody might find useful.

I have loads of things whirling around, and over the next week or so, i’m hoping to actually translate that into a real blog post.  If you correlate that to work, you might find my first topic interesting.  After all, wouldn’t it be nice to present your CV in a way that shows off your wondrous skill levels in Qlik Sense?  Well, over the coming weeks, let’s see what we can do.