… and points beyond

Wordpress destroys code. Live and learn. You can download the code here.

[Read more →]

My apologies for the code that was posted here. Copying and pasting broke the code. Download a ZIP of the code here.
I have expanded on the demo code that was floating around at Qonnections 2008. That code included an ASP page that made the requests using system objects and will not work outside IIS.
What about [...]

[Read more →]

I don’t know if you use a lot of Sum-If logic like I do. It’s a blessing and a curse. For example: sum(if(Category=’Sales’,Amount)). It just doesn’t scale up to tens of millions of rows. Even with only a million rows, if you have a sheet loaded with these expressions, QlikView will calculate the chart objects [...]

[Read more →]

Starting in Server 8.2, QlikView authentication is much more flexible with tickets. I’m just getting started with them myself, and I’ll be sharing the resources I find along the way.
Big thanks to Dan English, Johan Jeanson and Claes Linsefors for my education about tickets at Qonnections 2008.
If you have a working QV Server implementation including [...]

[Read more →]

QlikView is multi-threaded in many areas but not during the load process. Next time you’re running a load script, open the Windows Task Manager. If you have 2 cores, the processor usage will never go above 50%. You can to do this while QlikView is running and see what actions are single- and multi-threaded.
Load times [...]

[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 →]

What settings do you use for the gauge and bar charts? Watch the video!
Stephen Few, who spoke at the QlikView conference in April, devised the bullet graph a few years ago. A QlikView customer used bullet graphs and sparklines and was very generous to allow QlikTech to post a working demo of their application. I’m [...]

[Read more →]