Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
There is an ApplyMap example on the forum posted recently:
Brief Explanation about Apply map
Regards,
Neil
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.
Where is the relationship between ID, PID and BatchID?
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?
You need to be able to relate BatchID to either PID or ID, otherwise how can you associate BatchID to Membername?
Yes I did attached but it is showing values incorrect count of records when I compared from database.
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