I’ll be leading a 3.5 hour training June 4 on using the free open source “QlikView Components” scripting library. The training is held on-line and you can find out more and register at this link on the Qlik-On website.
QV Developers around the world use QVC in their scripting to:
- Save time.
- Improve Quality.
- Implement Advanced Functions.
- Get it Right the First Time.
Create a master calendar? No problem — one line of script:
CALL Qvc.CalendarFromField('OrderDate');
Fiscal calendar that begins on Month 4? Again no problem:
CALL Qvc.CalendarFromField('OrderDate','','',4);
What was that Set Analysis syntax for month-to-date in the previous year? The Calendar generates a series of variables for common period to period analysis.
=Sum($(vSetPreviousYearMTD) Sales)
That’s all there is to it. Even if you add fields to the Calendar. Even if you use Italian or Norwegian for the calendar field names.
Quick! Write the script to create an AsOf table for field Year-Month. I’m waiting… I can’t do it either without rooting around for an old project to copy from. But I can write:
CALL Qvc.AsOfTable('Year-Month');
Here’s are a few more things QVC can do:
- Load variables from an external file.
- Load custom icons from a folder.
- Logging, including rolling external files.
- Pause mid-script and let you inspect the contents of a table.
- Incremental Reloads!
- NVL!
The QVC project was founded in 2012 with the goal of simplifying common scripting tasks and implementing best practices. The focus is on what we call the “big middle” of scripting tasks.
The library is continually refined and enhanced with input from QV developers around the world and we expect some exciting new testing routines soon!
I hope you can join me June 4 to learn the details of installing and using QVC. You will leave the class with the confidence and skills to use all the QVC routines and begin supercharging your script!
-Rob
is free or charged?
There is a fee for the course. Please see the course link for pricing and registration information .
Are you gonna dive deep into the set analysis ? like advanced date syntax/examples
There is another course at Q-on.bi that is specifically about Set Analysis
http://q-on.bi/courses/qlikview-set-analysis/
It’s a great course, taught by Barry Harmsen, author of “QlikView 11 for Developers”.
Thanks Rob, I’ve already enrolled in that class. Hope to get most of it!
We will be doing period over period analysis like YTD in the exercises. We will discuss how to use the generated QVC Set Expressions, but not the details of their internal syntax.