Showing posts with label loadscript. Show all posts
Showing posts with label loadscript. Show all posts
Friday, May 4, 2018

Loading a 1% Random Sample

›
I needed to load a one percent random sample of a large file last week. I’m sure others have figured out this method but this was the fi...
6 comments:
Sunday, May 14, 2017

Have you got a function similar to SQL NVL ?

›
I work with a group of people who are all experts in SQL. They all also have varying levels of technical skills and QlikView skills. On...
4 comments:
Wednesday, April 5, 2017

Converting Edited Number Text into a Numeric Field

›
My co-worker, Naveen, had a requirement for a document that would load some financial data from a file that a client had sent to us. The ...
4 comments:
Wednesday, December 28, 2016

Straight Table with Different Expressions on Each Row

›
We had a requirement a few months back for a document that would show a table with different expressions on each row along with some subt...
3 comments:
Sunday, December 4, 2016

Calendar Table and Preceding Load

›
Here’s an example of a calendar table built with a series of preceding load statements. The preceding load technique isn’t essential – th...
Friday, November 18, 2016

MonthsBetween Function

›
A few days ago I needed a calculation in a loadscript that would provide the number of months between two dates. This kind of calculation ...
Thursday, December 24, 2015

Chart Adjusts to Whatever Fieldnames are Loaded

›
I’m often called on to validate a new data file from a client or to examine a new data extract. My first step is to load data into a copy...
4 comments:
Saturday, March 7, 2015

How Many Days Since That Document Reloaded?

›
I was challenged to write a simple blog posting. Here it is, although it still has some code in it. A recent project required a docum...
4 comments:
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...
Sunday, January 11, 2015

A Little More Optimized Load

›
This is a continuation of last week’s blog topic (search on " QlikView Maven Optimized QVD Load With a Where Clause and Dates ")...
4 comments:
Wednesday, January 7, 2015

Optimized QVD Load With a Where Clause and Dates

›
If you are working with large quantities of data and especially if you are working with large data sets of historical data where you add a...
3 comments:
Friday, January 2, 2015

Testing the Aggr Function Used in an Expression

›
I’m often asked to take a look at someone's QlikView document with the explanation that “the expression doesn't work”. If it is a ...
1 comment:
Saturday, April 5, 2014

Inline Load with Where Clause

›
You wouldn’t ordinarily use a Where clause with an inline load… after all, if you didn’t want all of the rows why bother typing them? ...
Wednesday, April 2, 2014

Oracle Hint in the Loadscript

›
People who load data from an Oracle database into QlikView may sometimes want to use an Oracle hint in the SQL query code. An Oracle hi...
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:
Saturday, January 12, 2013

Entire Load Statement in a Variable

›
QlikView document variables contain text. The software allows us to use variables in different situations and, for such a simple idea, the...
1 comment:
Monday, December 31, 2012

Execute Oracle Procedure From The Loadscript

›
I worked on a project a few months ago where several Oracle database tables had been designed specifically to support a QlikView documen...
1 comment: