Showing posts with label field names. Show all posts
Showing posts with label field names. Show all posts
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:
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:
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, 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...
Thursday, April 24, 2014

Note About Dollar-sign Expansion

›
Katrina, from the Marketing Group, came to me yesterday with a QlikView document she was working on. It had three scatter plot charts arr...
1 comment:
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:
Wednesday, May 2, 2012

List Box to Select Values From Two Fields at Once

›
I posted this answer on QlikCommunity yesterday and several people remarked on it so I thought I’d repeat it here. I recently had a Qlik...
Wednesday, April 4, 2012

Translate a Field Name into a User-Friendly Field Label

›
In my last two blog postings and in the one I’m preparing for next week I’ve described techniques that use the GetCurrentField   functio...
3 comments:
Sunday, March 18, 2012

Using Cycle Group in a List Box Expression

›
Here are a few more ideas from the Directed Creativity exercise in finding other ways to use Cycle Groups. You can use expressions in a list...
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:
Wednesday, January 14, 2009

Load a Table With All of the Values for a Field

›
An idea for developers of large reports-- Sometimes in the loadscript you need to build a table that contains all of the previously loaded v...
2 comments:
Saturday, September 20, 2008

Fixing the Field Name in an Exported Bookmark File

›
Last month, I wrote about how useful bookmarks are because they can be exported as a file and then imported into different QlikView reports ...
Saturday, August 23, 2008

Field names and compressing data

›
One of the cool things about QlikView is the way it can store enormous amounts of data in the report file. It can load many millions of rows...
Wednesday, August 20, 2008

More you can do with Partial Reload

›
See the previous posting about removing tables. In the same way that you can enter a Drop Table command to remove a QlikView table from an ...