topic Re: Relations without duplicate in QlikView

Relations without duplicate

Anonymous — Thu, 12 Nov 2015 07:09:59 GMT

How can I make relations between [date] and [user ID] without duplicate in data

Regards

Re: Relations without duplicate

pokassov — Thu, 12 Nov 2015 07:11:00 GMT

Hello!

Concatenate all tables?

Re: Relations without duplicate

Anonymous — Thu, 12 Nov 2015 07:18:45 GMT

Its look like all the tables have same records...simple solution is. Concatenate All and maintain a flag for each table,

also make sure while concatenating all the tables have same field name, rename all the fields of table

like:

Load

Date01 as Date, //repeat for all fields

'Hed' as Flag

from Inthed;

concatenate

Load

Date02 as Date, //repeat for all fields

'Hed1' as Flag

from Inthed1;

and so on..

Re: Relations without duplicate

tresB — Thu, 12 Nov 2015 07:20:22 GMT

Concatenate them with a flag field additionally, like:

Load

User_ID,

Memo01 as Memo,

Date01 as Date,

...,

'Source1' as Flag

From <Source1>;

Load

User_ID,

Memo02 as Memo,

Date02 as Date,

...,

'Source2' as Flag

From <Source2>;

......;

Then use this flag field in the front-end expression (wherever you need to seperate out) like: =Sum({<Flag={'Source1'}>} Amountfield), or so.

Re: Relations without duplicate

Kushal_Chawda — Thu, 12 Nov 2015 07:21:55 GMT

You can Concatenate all the tables

for eg

InvHed:

Load UserID,

Date01 as Date

Memo01 as Memo,

'InvHed' as Flag,

From InvHed

concatenate

InvHed:

Load UserID,

Date02 as Date

Memo02 as Memo,

'InvHed1' as Flag,

From InvHed1

likewise you can concatenate all the tables

Re: Relations without duplicate

Anonymous — Thu, 12 Nov 2015 07:22:48 GMT

Thanks all