topic Sheet object mapping table in QlikView https://community.qlik.com/t5/QlikView/Sheet-object-mapping-table/m-p/724570#M259939 <HTML><HEAD></HEAD><BODY><P>Is there a sheet object in the Full Browser version which could be used as a Mapping table, so that the created Mapping Table can be used in a Calculated Dimension in a Pivot Table ?</P><P></P><P>What is a way to create a mapping table which can be used in a calculated Dimension in the Pivot Table ?</P></BODY></HTML> Mon, 07 Jul 2014 11:29:30 GMT 2014-07-07T11:29:30Z Sheet object mapping table https://community.qlik.com/t5/QlikView/Sheet-object-mapping-table/m-p/724570#M259939 <HTML><HEAD></HEAD><BODY><P>Is there a sheet object in the Full Browser version which could be used as a Mapping table, so that the created Mapping Table can be used in a Calculated Dimension in a Pivot Table ?</P><P></P><P>What is a way to create a mapping table which can be used in a calculated Dimension in the Pivot Table ?</P></BODY></HTML> Mon, 07 Jul 2014 11:29:30 GMT https://community.qlik.com/t5/QlikView/Sheet-object-mapping-table/m-p/724570#M259939 2014-07-07T11:29:30Z Re: Sheet object mapping table https://community.qlik.com/t5/QlikView/Sheet-object-mapping-table/m-p/724571#M259940 <HTML><HEAD></HEAD><BODY><P>No, there isn't.</P><P></P><P>You can try putting an expression in a variable:</P><P>pick(match( DimensionValue, 'MapValueA', 'MapValueB', .... 'MapValueXYZ'), 'ReplacedValueA','ReplacedValueB','ReplacedValueC',...,'ReplacedValueXYZ')</P></BODY></HTML> Mon, 07 Jul 2014 16:21:29 GMT https://community.qlik.com/t5/QlikView/Sheet-object-mapping-table/m-p/724571#M259940 Gysbert_Wassenaar 2014-07-07T16:21:29Z Re: Sheet object mapping table https://community.qlik.com/t5/QlikView/Sheet-object-mapping-table/m-p/724572#M259941 <HTML><HEAD></HEAD><BODY><P>Thanks I will try.</P><P></P><P>Is it possible to </P><P></P><P>1/ use match and pick in a calculated dimension</P><P></P><P>2/ create a new variable in the QV Full Browser version ?</P><P></P><P>Thanks again for your help</P></BODY></HTML> Mon, 07 Jul 2014 16:23:59 GMT https://community.qlik.com/t5/QlikView/Sheet-object-mapping-table/m-p/724572#M259941 2014-07-07T16:23:59Z