… and points beyond

Download it from http://ftp.qliktech.com/qvwebdownloads/

[Read more →]

My thanks to Henric Cronström for taking the time to review my post on expression variables. He said the name for this new feature is still being decided. And he had some valuable information for getting started.
Your text is good and everything is correct. But you may want to add the following
1) [...]

[Read more →]

One of the more interesting features coming in QlikView 8.5 is “Dollar-Sign Expansion with an Expression”, Section 24.5 in the coming Reference Manual. One place in the manual they are called “on-the-fly variables”, but I prefer “expression variables”.
In many ways expression variables are similar to using the TOTAL qualifier because they are calculated across the [...]

[Read more →]

It is still in development as of the beta. Looks nice.

[Read more →]

[Read more →]

There needs to be a way to say “apply current selections, but ignore any selections in field A”. I submitted this as a feature request, but I hope someone from QlikTech sees this post. My proposed syntax is sum({$<!Year><!Month><!Week><!Date>} Sales). Otherwise, you need to use a positive assertion that lists each and every value, or [...]

[Read more →]

UPDATE: The syntax in QlikView has changed since this was written at the time of the 8.5 beta release.
“Set analysis is the best feature since the new charting engine in version 4,” says Jonas Nachmanson.
That may not reveal the excitement, but it’s true! Set analysis is a big feature.
Want to sum excluded values that are [...]

[Read more →]

Working with variables can be confusing, so I created a demo with 3 variables: a string, a number and a valid function (as a string). It’s worth nothing that the upcoming 8.5 treats sum-if differently than 8.2
Here’s 8.2:

And here is 8.5:

[Read more →]