Adam Cooke

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


Qlik Sense development Tag

Webofwork > Posts tagged "Qlik Sense development"

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

This is a great example of using workbench editor to get the most out of Qlik Sense and achieve things that no other product(including Qlikview) can with drag drop functionality for users with no HTML/CSS skills! Hopefully more to follow. [embed][/embed]   The branch project: This approach is one way to generate very customised web applications using approved branded templates built by an expert and empower business users to professionally publish...

Read More