Quick and Dirty tips for QlikView

Category: Scripting

This is a follow-on from my previous post on loading section access from SQL http://qlikanddirty.com/2017/03/29/section-access-from-sql-and-automating-wildcard-access/ What we will look at now is how you can create a system to mimic what other people can see, note because section access is applied in the document, users will still only be able to see their valid values. […]

While writing this I was able to code a method whereby a user can be given * access and it will show all values. Do NOT try and use section access on a key column (one qlikview uses to link on) while using the included QV code. SQL Setup The setup is simple, create a […]

This is something which has bugged me for ages, there doesn’t appear to be a way to generate a completely accurate % sample. For example if I have 10,000 rows and I want a 10% sample, I want to see 1,000 rows in my sample, not 1,043 or 958 There may well already be an […]

Sometimes qualifying your tables is a necessary evil and does have its uses, however the tablename.fieldname syntax isn’t very friendly. We can use a little script to whip through the data model and rename all of our fields to something friendlier for example tablename_fieldname The only caveat is that it won’t rename a field to […]

This is a quick answer to the post here: https://community.qlik.com/message/1183485 The question was, with an input of type [parent,child] where there could be many children to one parent, is it possible to create a cross-table style output to put each layer in a new column. The trick here is to work out the maximum depth […]

So I was sat in the office today and my clunky day1 code was irritating me. I only had a quick 20mins but when I thought about it, it was possible to really cut the code down: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 […]

If you haven’t seen https://adventofcode.com/2016 I can recommend checking it out for a bit of coding fun! Being slightly stubborn I wanted to do it in SQL (why not!), I’ve only managed time to do the first day so far and below are my workings: –Create a simple function to split a comma string CREATE […]

Today I had to remind myself how simple the solutions can be sometimes. I’m working on optimising the QVD loads in a significant incremental load process, some simple changes dropped our reload time from 1hr15 to 41mins (30mins is SQL) but I figured I could strip out some time downstream as well by loading some […]

Recently I’ve done a chunk of work with UK mapping of statistical data, which has involved a lot of working with the Geography data type as well as extracting from GEOJSON files. This has then been plotted in Qlik using a variation of Brian Munz’s Qlikmap which I tweaked to allow me to plot two […]