topic Re: How to replace ID with membername at a time? in QlikView

How to replace ID with membername at a time?

Thu, 06 Feb 2014 13:57:58 GMT

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.

Re: How to replace ID with membername at a time?

Gysbert_Wassenaar — Thu, 06 Feb 2014 14:12:32 GMT

You could simply load the list of ID's and member names and use the member name dimension instead in the straight table. Or you could use a mapping table and the applymap function to replace ID's with member names.

Re: How to replace ID with membername at a time?

brindlogcool — Thu, 06 Feb 2014 14:15:06 GMT

You can use ApplyMap in load script . If id and Membername is in data model then you should be able to display it in the straight table without any script. Hope i have not missed anything

Re: How to replace ID with membername at a time?

juleshartley — Thu, 06 Feb 2014 14:15:48 GMT

See here for example

Re: How to replace ID with membername at a time?

Thu, 06 Feb 2014 14:32:58 GMT

Thanks and I don't have ID and memebername in both tables. that is the main problem now. I tried using APPLYMAP but it is not showing values accurate.

TableA has only ID

TableB has ID and memebername.

In this case how can I use this?

Re: How to replace ID with membername at a time?

Gysbert_Wassenaar — Thu, 06 Feb 2014 14:35:15 GMT

MapName:

mapping load ID, MemberName

from TableA;

TableB:

load ID, applymap('MapName',ID) as MemberName, ...other fields ...

from TableB;

Re: How to replace ID with membername at a time?

brindlogcool — Thu, 06 Feb 2014 14:36:55 GMT

So you want to update the Table A with Member Name? It should work.Please refer this example. Can you attach your file if possible

Re: How to replace ID with membername at a time?

brindlogcool — Thu, 06 Feb 2014 14:37:31 GMT

Please refer the example Julian has provided

Re: How to replace ID with membername at a time?

Thu, 06 Feb 2014 14:43:22 GMT

Thanks and sorry it's not working when I reload it is showing field not found membername.

actually I have in TableA ID

and in TableB PID,membername

Re: How to replace ID with membername at a time?

Gysbert_Wassenaar — Thu, 06 Feb 2014 14:49:52 GMT

Use the exact case sensitive names. Qlikview is case sensitive so MemberName is not the same as membername. Because I don't have your document I cannot know the exact field names you need to use.

Re: How to replace ID with membername at a time?

ngulliver — Thu, 06 Feb 2014 14:58:19 GMT

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

Re: How to replace ID with membername at a time?

ngulliver — Thu, 06 Feb 2014 15:00:56 GMT

There is an ApplyMap example on the forum posted recently:

Brief Explanation about Apply map

Regards,

Neil

Re: How to replace ID with membername at a time?

Thu, 06 Feb 2014 15:21:24 GMT

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.

Re: How to replace ID with membername at a time?

juleshartley — Thu, 06 Feb 2014 15:23:50 GMT

Where is the relationship between ID, PID and BatchID?

Re: How to replace ID with membername at a time?

Thu, 06 Feb 2014 15:33:29 GMT

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?

Re: How to replace ID with membername at a time?

juleshartley — Thu, 06 Feb 2014 15:50:20 GMT

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

Re: How to replace ID with membername at a time?

Thu, 06 Feb 2014 15:56:13 GMT

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

Re: How to replace ID with membername at a time?

magavi_framsteg — Mon, 10 Feb 2014 08:43:17 GMT

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