Reacties voor Quick - Qlear - Qool

Reactie op DTAP deployment with common script door Bas

Bas — Sun, 22 Jan 2012 18:27:22 +0000

You have pointed me to another way of doing it. It can also be achieved by placing your common script in a share. When you use a share you are also independent of the filestructure of Windows.

For instance when you create the folder “C:\MyScript” and create “Common.qvs” there. You can share the folder with the name “QlikView_Script”.

In your QlikView app you can include the script like this: $(Include=\\localhost\QlikView_Script\Common.qvs);

When you are on another machine you can use a different folder, but use the same share name. So the next machine can have the common file in “C:\QlikView\Scripts”. But still share this as “QlikView_Script”. This means that the same include will still work.

Reactie op DTAP deployment with common script door Brian S

Brian S — Fri, 20 Jan 2012 18:56:49 +0000

I see. Yeah we have a standard directory structure on all of our QV servers and developers machines. So then we just have a relative path ($(Include=..\..\shared includes\incDataSource.qvs)) to the include file. Many ways to “skin the cat” depending on how you need to do it. QlikView is nice that way.

Reactie op DTAP deployment with common script door Bas

Bas — Fri, 20 Jan 2012 15:48:35 +0000

That is also a very good option. There are multiple ways of solving the inclusion of a common script. I suspect that your include points to a static file path? That’s something I wanted to prevent. But of course in my method I point to a static registry location. Just a matter of preference I guess.

- Bas

Reactie op DTAP deployment with common script door Brian S

Brian S — Fri, 20 Jan 2012 14:31:38 +0000

We use a little simpler method. We have a common include script that all apps include. The include script detects the machine name it is running on and then we use a case statement that sets a standard set of variables to the appropriate connection strings for that machine. Each app can then instantiate any connection string variables it needs for its script. We try to avoid having any registry dependencies for portability sake.

Reactie op How To: Create User Defined Buckets door William

William — Fri, 20 Jan 2012 08:03:41 +0000

your welcome!

Reactie op How To: Prevent Circular Reference in a Qlikview Data Model door william

william — Fri, 20 Jan 2012 08:01:20 +0000

Hi May,

You could rename a field with as like in the example CustomerCode field below:

Example:
load
CustomerCode as RenamedCustomerCode,
LineTotal,
ItemCode,
CustomerCode
resident
example;

Reactie op How To: Create User Defined Buckets door koala kare baby changing station

koala kare baby changing station — Fri, 20 Jan 2012 07:51:41 +0000

nice posts and nice site Great post man! Continue the good work!

Reactie op How To: Prevent Circular Reference in a Qlikview Data Model door May

May — Sat, 10 Dec 2011 13:26:48 +0000

Hello,
this is useful article.
Btw, Qlikview is automatically join table when field names are similar.

How can I unspecified some fields (with the same name) not be the the key fields…

Reactie op Managing expressions in QlikView: the use of variables door jagan

jagan — Thu, 20 Oct 2011 05:34:17 +0000

Very Very Very helpful Juan.

Reactie op How to: Market Basket Analysis door William

William — Tue, 04 Oct 2011 17:36:44 +0000

@Fabio Great to hear. Your welcome!
@Breakpopin your welcome! Still having those questions? If so let me know