topic Solution for multi-use of DateTable? in QlikView

Solution for multi-use of DateTable?

xtrimf — Sun, 10 Jan 2010 12:08:41 GMT

Hi,

I have 10 tables in this solution.

The problem is that 5 tables need a relationship to the DateTable in order to view their data on a timeline on the same chart.

I guess its a known issue which developers tend to avoid using multiple keys or concatanations (or they just don't mind all those SYNC tables)

I prefer not to use concatenations, and It creates to many Sync tables for my taste.

Any suggestions?

Sun, 10 Jan 2010 19:04:30 GMT

You need concatenations or 5 unique data tables.

I suggest you do the concatenation. This is preferable for QV, since there won't remain links that need to be handled.

If you want to be able to see what field belongs to what table, just do a qualification ...


QUALIFY *;
UNQUALIFY '%*_Key';

The key field for all 5 tables needs to be like '%*_Key'. So for instance: %CalenderDate_Key

This way the 5 tables can be concatenated and all the fields will still be identifyable by the original tablename before each field.

xtrimf — Mon, 11 Jan 2010 07:09:58 GMT

So there is no avoiding concatenation then...OK.

What is the "%" good for? or is it just your naming convention..?

Mon, 11 Jan 2010 21:07:15 GMT

Yes, the '%' is a standard used by QV, but you can use whatever you like. You can also leave it out just use '_Key'.

The point is to create a unique naming convention for your keys.