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.
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.
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
See here for example
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?
MapName:
mapping load ID, MemberName
from TableA;
TableB:
load ID, applymap('MapName',ID) as MemberName, ...other fields ...
from TableB;
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
Please refer the example Julian has provided
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
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.