Showing posts with label variables. Show all posts
Showing posts with label variables. Show all posts
Friday, January 19, 2018

Utility That Can Extract and Show All of the Variables from Your QlikView Document

›
Some of our project teams at work are required to use a standard QlikView document for several clients and then use a client-specific loa...
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 ...
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:
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:
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...
Sunday, June 16, 2013

Maven's Sliding Window

›
Expanding on the example from last time about loading unstructured text data (to read about it, search on QlikView Maven Loading an Unst...
1 comment:
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

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:
Saturday, March 2, 2013

Referring to a Column Label When the Label is a Text Expression

›
Last week, I added an enhancement to a QlikView document that had been in use for over two years. My task was simply to add a column to a...
1 comment:
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:
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:
Sunday, February 12, 2012

Expression Overview - Find/Replace

›
The desktop QlikView Expression Overview is a useful tool for searching expressions in a document or doing a Find/Replace on terms and val...
3 comments:
Sunday, April 3, 2011

Variable That Acts Like a User-Defined Function

›
QlikView document variables are really just text strings with a name. In various places in the document where expressions are used you can ...
Thursday, February 12, 2009

Capture Variable Values in the Loadscript

›
I often put statements in the loadscript that record current conditions as document variables in case the information might be useful someda...
2 comments:
Thursday, December 4, 2008

Variables in the .bat script

›
This series of blog postings about variables has probably been of interest mostly to technical folks concerned with automating QlikView docu...
1 comment:
Tuesday, December 2, 2008

Loading Variables Via Loadscript

›
You have two basic alternatives if you want to load document variables from a database or file. You can load them as part of the loadscript ...
1 comment:
Wednesday, November 26, 2008

Listing All Variables and Contents

›
[Author's note:  You can see information about a different method for accomplishing this same thing. Search on: QlikView Maven Utility T...
3 comments: