topic Re: New version of Qlikview Cookbook in QlikView

New version of Qlikview Cookbook

rwunderlich — Tue, 07 Jun 2011 05:25:01 GMT

A new version, V10, of the Qlikview Cookbook is available for download at

The Cookbook contains working samples of a number of common Qlikview tasks. The Cookbook is Personal Edition enabled. All files may be opened by PE users. Please UNZIP the file before trying to open or reload the examples.

In addition to editorial corrections, examples added or substantialy revised since Cookbook V9 include:

--Logging script message to an external file.

--List files from filesystem using FILELIST and DIRLIST.

--Using MapSubstring to edit strings.

--Load from Active Directory - Users and Groups.

--Making initial selections on document open - V9.

--User selectable dates using Input Box

--Incremental reload example.

--Converting raw time units into Qlikview intervals.

The Cookbook version, "V10" is coincidentaly the same version as Qlikview V10, and is not dependent on QV V10. The Cookbook examples have been tested with QV 8.5+. Examples that require a specific QV version are identified in the Cookbook documentation.

I hope the Cookbook is useful in your QV learning journey. Thanks to the many community members who have contributed inspiration or code to the Cookbook examples.

If you have questions or comments about the cookbook, please post them in this thread.

-Rob

http://robwunderlich.com/

New version of Qlikview Cookbook

rbecher — Tue, 07 Jun 2011 10:22:04 GMT

Hi Rob,

thanks! But it still says version 9?

Btw., how you can make it PE enabled?

- Ralf

Re: New version of Qlikview Cookbook

rwunderlich — Tue, 07 Jun 2011 14:57:29 GMT

Hi Ralf,

Website problem. It's still downloading V9. I'll try to fix it today..

Qliktech does the PE enablement for me. I send them the file and they apply the PE magic to it.

-Rob

New version of Qlikview Cookbook

rwunderlich — Tue, 07 Jun 2011 17:23:05 GMT

Ok, the download should be working correctly now.

-Rob

New version of Qlikview Cookbook

Anonymous — Tue, 07 Jun 2011 19:13:22 GMT

Thanks Rob!

I was inspired.

New version of Qlikview Cookbook

Wed, 08 Jun 2011 09:42:17 GMT

Hi Rob,

This is great stuff -thanks!!

When clicking on the info button in Cookbook.qvw I get a 'Failed to open document' message. Any suggestions how I can overcome this problem?

It's not to serious though, as I can open the qvw files from the various sub-directories. There is a lot of stuff in there, and it certainly gives me plenty of 'food for thought'.

Like Henrik remarks 'I was inspired'.

Arie

Re: New version of Qlikview Cookbook

rwunderlich — Wed, 08 Jun 2011 14:55:41 GMT

Hi Arie,

Did you UNZIP the file before opening the cookbook.qvw?

-Rob

Re: New version of Qlikview Cookbook

Thu, 09 Jun 2011 08:41:58 GMT

Yes, I did Rob -see attachment.

Regards

Arie

Error message

Arie van Dongen

Business Analyst

Re: New version of Qlikview Cookbook

marcos — Thu, 09 Jun 2011 09:58:35 GMT

i have tested and works perfectly.

There are some examples very interisting.

Thanks Rob for your good job.

Re: New version of Qlikview Cookbook

rwunderlich — Thu, 09 Jun 2011 14:07:42 GMT

Arie,

I have received occasional reports of this problem. It's usually cured by redownloading. Can you please try that if you haven't already?

-Rob

New version of Qlikview Cookbook

Thu, 09 Jun 2011 14:37:22 GMT

I learned a lot from the last cookbook, hopefully this one is no different.

Thanks

Re: New version of Qlikview Cookbook

Thu, 09 Jun 2011 14:43:49 GMT

I have done that. But don't worry, Rob, I can open all the QVD files

from the sub-directories.

Arie

Arie van Dongen

Business Analyst

Re: New version of Qlikview Cookbook

mellerbeck — Thu, 09 Jun 2011 15:06:00 GMT

You are awesome Rob!

New version of Qlikview Cookbook

Anonymous — Wed, 15 Jun 2011 10:14:52 GMT

Thanks Rob,

This is great!

Dennis.

New version of Qlikview Cookbook

Tue, 28 Jun 2011 13:29:30 GMT

Hi Rob. A newbie to QlikView.

First of all impresive cookbook!

I have got the problem that some of the files do not open (trailingMinus.qvw or adgroupsandusers.qvw, for example) while others do (DateTable.qvw). I am working with QlikView 8.01 Do you know if it's a problem related to the version?

Thanks in advance.

Mikel.

New version of Qlikview Cookbook

rwunderlich — Tue, 28 Jun 2011 15:57:02 GMT

Hi Mikel,

It's possible that your opening problem may be related to using V8.01. I only test the cookbook on V8.5+ and don't have an 8.01 to test with.

On the other hand, I get occasional reports from people about trouble opening files. In most cases, it's fixed by downloading and unzipping the file again.

-Rob

Re: New version of Qlikview Cookbook

Wed, 29 Jun 2011 05:14:15 GMT

Hi Rob,

definitely the version is the problem. I have downloaded QV 10 and the files

open with no problem...

Thanks.

***********************************************

Mikel Artaso Landa

mikel.artaso@gmail.com

***********************************************

2011/6/28 Rob Wunderlich <qliktech@sgaur.hosted.jivesoftware.com>

**
QlikCommunity <http://community.qlik.com/index.jspa> Re: New
version of Qlikview Cookbook created by Rob Wunderlich<http://community.qlik.com/people/robwunderlich>in
Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/128257#128257>

New version of Qlikview Cookbook

qliksus — Wed, 29 Jun 2011 05:41:00 GMT

rob ,

can u help me on this thread http://community.qlik.com/thread/30743 its quite urgent

New version of Qlikview Cookbook

Thu, 11 Aug 2011 16:21:52 GMT

Thanks a lot Rob.

I'm a newbie, and it's really useful.

Thanks again

Pablo

Re: New version of Qlikview Cookbook

dirk1955 — Tue, 09 Jul 2013 15:02:03 GMT

THX Rob