Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
xtrimf
Creator
Creator

Solution for multi-use of DateTable?

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?

3 Replies
Not applicable

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
Creator
Creator

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

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

Not applicable

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.