Adam Cooke

I currently work as a consultant for Qlik, a software company doing some interesting stuff in business intelligence. Check it out Qlik.com. I write this blog to showcase some technical bits that I hope will be useful to others.
adamcooke@webofwork.com

Tags

Webofwork

Webofwork

Yesterday Qlik released Qlik Sense 2.1. This one has loads of things and is really worth a download, the product is starting to mature and i'm very sure there's loads more to come. The variable editor is back If you are familliar with Qlikview you will be happy that this feature has now returned. Really useful for more complex implementations. This will only be seen in unpublished apps, it...

Read More

The dimensions and measures library has a really handy search function to help end users find fields and measures that they want to drag onto a visualisation. Sometimes the fields are not in the most helpful names, especially if they have been pulled directly from a Database. Sometimes the business will actually have completely different naming conventions for fields. This can make their life hard in...

Read More

If you have just started using Qlik Sense then you may be confused about what exactly the difference between a dimension and measure is in Qlik Sense or Qlikview. Any visualisation can be said to contain dimensions and measures. A measure is a calculation. It is something you need to write an excel function like sum() or count() or an if statement for. If you find yourself...

Read More

Subfield() is a great function for splitting a long string into seperate fields. You can use this to split out a date or anything where you have a common delimeter in a string. For example. If you have the string field name: TextString line 1: Big_Frogs_Are_Yummy You may want to split this out into 4 seperate fields. subfield(TextString, '_', 1) as FirstWord, subfield(TextString, '_', 2) as SecondWord, subfield(TextString, '_', 3) as ThirdWord, In...

Read More

Maybe you need to see your dashboard in bright high visiblity colors? When accessing a Qlik Sense dashboard through your browser just put theme/highvis at the end when your on a sheet. http://localhost:4848/sense/app/ %5C%5Cpsf%5CHome%5CDocuments%5CQlik%5CSense%5CApps%5CSales%20Discovery/ sheet/XuWLHFK/state/analysis/theme/highvis Remove the spaces from the link above. Not always perfect but interesting....

Read More