Showing posts with label toolkit. Show all posts
Showing posts with label toolkit. Show all posts
Wednesday, March 14, 2018

Rename a Cycle Group

›
I often use Rob Wunderlich’s excellent Copy Groups utility to copy cycle groups from one QlikView document to another; or to copy a cy...
1 comment:
Saturday, May 27, 2017

Data Profile Tool

›
I’ve written in this blog before about how I’m often called on to validate a new data file from a client or to examine a new data extract...
1 comment:
Saturday, January 31, 2015

General File Loading Technique

›
Here’s a technique I first used several years ago when I started a project where we had several dozen data files, all of them containing d...
Monday, May 6, 2013

Loading an Unstructured Text File

›
This is the start of a series of postings about dealing with unstructured text data. I've used QlikView to help analyze message log f...
3 comments:
Tuesday, April 2, 2013

Update Document Variables Directly From Excel Spreadsheet

›
A few years ago I published a blog entry that showed how to copy all of the variables and their values from a QlikView document into an Ex...
3 comments:
Sunday, March 24, 2013

Macro to Copy Cycle Group From One Document to Another

›
Keeping with the toolkit theme, here's a macro that can copy a cycle group from one QlikView document to another. If you've done m...
2 comments:

More on Copy Variables From One Document to Another

›
Here's an alternate version of that macro from last time. This macro can be copied into the module area of a QlikView document (I call...
2 comments:
Saturday, March 9, 2013

Macro to Copy Variables In From Another Document

›
My preference when I need to copy variables from one QlikView document to another is to use a small Windows script to do the copying (I w...
2 comments:
Monday, March 4, 2013

Make a Copy of a Cycle Group

›
I sometimes build cycle groups with more than a dozen calculated dimension expressions and labels that are text expressions. It used to i...
2 comments:
Saturday, February 23, 2013

Macro Copies Value From a Chart into a Variable

›
Here's an example of a method that will allow a QlikView macro to look at a value inside a sheet object like a straight table and pu...
3 comments:
Monday, June 27, 2011

Export All Data From All QV Tables to Text Files

›
Last week one of our clients asked me to provide a method that they could use to export all of the data from within a QlikView document. T...
8 comments:
Saturday, March 14, 2009

Browse-for-File Macro Button

›
Several times I’ve created QlikView reports that must read data from a file but the name of the file can vary and must be supplied by the re...
9 comments:
Saturday, September 27, 2008

Step Through Field Values

›
Author's Note: Although this technique is still sometimes very useful, there is an easier way to accomplish this in QlikView without a m...
3 comments: