Michael Ellerbeck

So this is a simple idea so that users know who to go to with questions about specific Qlikview i.e. who is the ‘SHMEEEE ‘

So use a variable in the load script

vDocOwner = ‘youremailaddress@somewhere.com’

Now create a text object displaying the vDocOwner

If you want to be extra fancy (For extra fancy you can even include the name of the document in the subject…. & subject=)

In its properties, on “Action” tab, choose : “Open URL”

In the command line, write :

mailto:noone@nowhere.com

Now if they click on they can send the responsible party an email….

There, enjoy extra responsibility responsibly

Also, I should make a link to a wiki page that describes the Qlikview but I will save that for later.

Filed under: Qlikview | Leave a Comment »

This is a short list but will continue to add more. These are mainly coming from the Qlikview masters summit

Declare all variables in the script (Especially important if you use source control)

Drop the seconds from DateTimeStamps if not needed (probably not needed most of the time)  I’ve been using cast(TheDate as Smalldatetime) as TheDate as a SQL way of doing it (any better ways??)

IF’s are evil, especially if the execute for every row

Filed under: Qlikview | Leave a Comment »