topic Qlikview Improvement in QlikView

Qlikview Improvement

pgalvezt — Fri, 25 Feb 2011 15:58:46 GMT

Hello!! I´ve working with twelve reports with many columns each one and I've using almost 7 of them. Basically the idea is to do a clik on a particular date and change all charts and values (in one clic) I left you a sample for better explanation. And How can I realize a better optimization of this. Thanks... If you have question just let me know...

Qlikview Improvement

pgalvezt — Mon, 28 Feb 2011 15:15:43 GMT

Anyone?

Re:Qlikview Improvement

llauses243 — Mon, 28 Feb 2011 19:24:30 GMT

Hi Pablo,

This is my offer (schema)

Create a .qvw with calendar, with a button ... when press open your .qvw (with reports) pass date as parm, you .qvw must contains module deploy

Module deploy is based in a sheet excel (object id ej. CH01; user id; route ej. email, export; bookmark id) all this with set of macros

Good luck, Luis

chi, chi Viva Chile¡¡

Qlikview Improvement

Mon, 28 Feb 2011 23:01:09 GMT

I may be missing something but it looks like your biggest performance hit is coming from your synthetic table. I'd take care of that before worrying about the clicking on one date.

Here's my suggestion:

1. Place a QUALIFY statement in front of each of the tables. This adds the table name to the beginning of each of your column names and eliminates your synthetic table.

2. Run multiple columns together to create a common key for each table. Forgive me for only speaking English and not using your column names, but an example would be

TABLE_NAME_DATE&','&TABLE_NAME_POLICY_NUMBER&','&AUTOHASHNUMBER128(DATE&','POLICY_NUMBER) AS TABLE_NAME_COMMON_KEY

3. In separate table

RESIDENT LOAD SUBFIELD(TABLE_NAME_COMMON_KEY, ",",1) AS DATE,

CONCATENATE

RESIDENT LOAD SUBFIELD(TABLE_NAME_COMMON_KEY_2, ",",1) AS DATE

This would give you a table with all your keys that you wouldn't have to store, get rid of your synthetic table and give you a common DATE selection across the entire document.

Qlikview Improvement

pgalvezt — Tue, 01 Mar 2011 13:25:59 GMT

Thanks to all of you for a quick response.

Actually my dashboard works fine.

I was seeing I can use a function like "outer" I think this could very useful.

Thanks all.