topic Mapping work arounds? in QlikView https://community.qlik.com/t5/QlikView/Mapping-work-arounds/m-p/194966#M55670 <HTML><HEAD></HEAD><BODY><P>Still you can use set anlysis, right?</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=only({1&lt;Value={'0'}&gt;} text)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 22 Sep 2009 22:54:46 GMT 2009-09-22T22:54:46Z Mapping work arounds? https://community.qlik.com/t5/QlikView/Mapping-work-arounds/m-p/194965#M55669 <HTML><HEAD></HEAD><BODY><P>All, I have an interesting scenario where I have a field that has 7 possible values and 7 corresponding text values that are linked, i.e.</P><P>Value, text</P><P>0, This number is zero</P><P>1, This number is one</P><P>2, This number is two</P><P>My dilemma Is that I need to have the comparable "text" field as the title for 7 different Pivot Tables, <B style="mso-bidi-font-weight: normal;">without having</B> to select anything. I know you can use set analysis to do this in instances where you are using aggregations, but my scenario does not have that. All I need for it to do is basically return the text</P><P>I have tried MAPPUING and I always receive NULL</P><P></P><P>Any ideas? Thoughts examples?</P></BODY></HTML> Tue, 22 Sep 2009 22:43:48 GMT https://community.qlik.com/t5/QlikView/Mapping-work-arounds/m-p/194965#M55669 james 2009-09-22T22:43:48Z Mapping work arounds? https://community.qlik.com/t5/QlikView/Mapping-work-arounds/m-p/194966#M55670 <HTML><HEAD></HEAD><BODY><P>Still you can use set anlysis, right?</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=only({1&lt;Value={'0'}&gt;} text)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 22 Sep 2009 22:54:46 GMT https://community.qlik.com/t5/QlikView/Mapping-work-arounds/m-p/194966#M55670 2009-09-22T22:54:46Z Mapping work arounds? https://community.qlik.com/t5/QlikView/Mapping-work-arounds/m-p/194967#M55671 <HTML><HEAD></HEAD><BODY><P>Have you looked at <EM>DUAL</EM> ? It can be used in the loadscript to associate a number and a text value - it may give you a field name to use in your titles.</P></BODY></HTML> Wed, 23 Sep 2009 00:23:22 GMT https://community.qlik.com/t5/QlikView/Mapping-work-arounds/m-p/194967#M55671 2009-09-23T00:23:22Z