How to replace ID with membername at a time?

[#1]

Hi,

I have ID and membername. whereever there is ID I have to show membername in straight table . I am aware it will get by using

If(ID=1, 'XX',ID) as ID

I have to replace 300 rows with membername instaed of ID.

Is there any way I can do this with script at a time or with expression?

Thanks.

[ngulliver]

Hi, Amelia.

have you seen Steve's blog on using ApplyMap.

It may give you a better idea of how to use it to get what you want.

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards,

Neil

[ngulliver]

There is an ApplyMap example on the forum posted recently:

Brief Explanation about Apply map

Regards,

Neil

[#4]

Thanks and I will explain my problem clearly.

I have Three tables:

Table A has fields ID and others...

Table B has fiellds PID, MemberName and others....

Table C has fields  BatchID and others....

so, now I need to show in two striaght tables.

One striaght table should have MemberName instead of ID

Another straight table should have MemberName instead of BatchID.

Please can help me.

[juleshartley]

Where is the relationship between ID, PID and BatchID?

[#6]

there is direct relation ship between Table A and Table B. But there is no direct relation between Table B and Table C. is that the problem?

[juleshartley]

You need to be able to relate BatchID to either PID or ID, otherwise how can you associate BatchID to Membername?

[#8]

Yes I did attached but it is showing values incorrect count of records when I compared from database.

[magavi_framsteg]

Hi Amelia.

Do you know about "QlikView and associative data modelling", in which common field names are automatically associated?

It is of great use if you have for example TableX.ID and TableY.ID | TableY.Membername.

They will get linked automatically, and you can show the Membernames in a table. Or a graph should you like.

You could accomplish this in several ways where JOINS and MAPS are two examples.

Or by plain field association using facts and dimensions.

Hope it helps