Data Dupllication

[renjithpl]

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

[deepakk]

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.!!

[#3]

HI,

I dnt understand your problem. its working as expected.

Check the attached application.

Elaborate your problem to suggest better solution

Regards

Sridhar

[#4]

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

[renjithpl]

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

Thanks for your reply. 🙂