topic Data Dupllication in QlikView

Data Dupllication

renjithpl — Wed, 07 Apr 2010 08:12:40 GMT

hi,

i have two different tables

DocID	Name	Stage
1000	Alan	Stage 1
1001	Alan	Stage 1
1002	Alan	Stage 1

DocID	Name	Stage
1000	Smith	Stage 1
1003	Smith	Stage 1
1004	Smith	Stage 1

i have loaded two tables in qlikview,

i want to display this data in pivot table, i put the dimension as DocID, but since the DocID 1000 has assigned to Alan and aswell as Smith, the datas are not showing correctly.

Is there any way to rectify it.

is it to do with the dimension.

Thanks

Ren

Data Dupllication

deepakk — Wed, 07 Apr 2010 08:16:34 GMT

Add New Field to both the Tables eg :

'01' as DocType for one table and

'02' as DocType for Secondtable and use this as a Dimension in you pivot table.

It will work fine.!!

Data Dupllication

Wed, 07 Apr 2010 09:05:36 GMT

HI,

I dnt understand your problem. its working as expected.

Check the attached application.

Elaborate your problem to suggest better solution

Regards

Sridhar

Data Dupllication

Wed, 07 Apr 2010 09:43:46 GMT

Hi Renjith,

I have attached an application which works fine with the pivot table. Is this what you are looking for. Please explain your problem well.

Thanks

Data Dupllication

renjithpl — Wed, 07 Apr 2010 12:49:34 GMT

yeah thopz, your application clarified my problem.. Thanks.. i have to put both DocID and Name in the dimension.

Thanks for your reply. 🙂