topic Re: How to concatenate 2 fields as one with bookmarks in QlikView https://community.qlik.com/t5/QlikView/How-to-concatenate-2-fields-as-one-with-bookmarks/m-p/418295#M1153801 <HTML><HEAD></HEAD><BODY><P>See attached qvw. That's the best I can do. Pivot tables don't lend themselves to much customization.</P></BODY></HTML> Wed, 03 Apr 2013 13:18:57 GMT Gysbert_Wassenaar 2013-04-03T13:18:57Z How to concatenate 2 fields as one with bookmarks https://community.qlik.com/t5/QlikView/How-to-concatenate-2-fields-as-one-with-bookmarks/m-p/418293#M1153799 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Please find attached a QVW which has bookmarks within it, and the buttons are associated with the bookmarks&nbsp; </P><P></P><P>The bookmarks work well, however I now want to add 2 fields called In_Test and Out_Test to the table on the left hand side </P><P></P><P>However I want to concatenate the 2 fields so that when the All button is selected, both In_Test and Out_Test will show in the table</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inpatients button is selected, only In_Test will show in the table</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Outpatients button is selected, only Out_Test will show in the table</P><P></P><P>Can anyone help me try and achieve this?</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Wed, 03 Apr 2013 12:31:36 GMT https://community.qlik.com/t5/QlikView/How-to-concatenate-2-fields-as-one-with-bookmarks/m-p/418293#M1153799 helen_pip 2013-04-03T12:31:36Z Re: How to concatenate 2 fields as one with bookmarks https://community.qlik.com/t5/QlikView/How-to-concatenate-2-fields-as-one-with-bookmarks/m-p/418294#M1153800 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Have a look at the application attached.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Is this what you want?</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 03 Apr 2013 13:10:13 GMT https://community.qlik.com/t5/QlikView/How-to-concatenate-2-fields-as-one-with-bookmarks/m-p/418294#M1153800 kaushiknsolanki 2013-04-03T13:10:13Z Re: How to concatenate 2 fields as one with bookmarks https://community.qlik.com/t5/QlikView/How-to-concatenate-2-fields-as-one-with-bookmarks/m-p/418295#M1153801 <HTML><HEAD></HEAD><BODY><P>See attached qvw. That's the best I can do. Pivot tables don't lend themselves to much customization.</P></BODY></HTML> Wed, 03 Apr 2013 13:18:57 GMT https://community.qlik.com/t5/QlikView/How-to-concatenate-2-fields-as-one-with-bookmarks/m-p/418295#M1153801 Gysbert_Wassenaar 2013-04-03T13:18:57Z