<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Hide key columns in bridge table in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Hide-key-columns-in-bridge-table/m-p/922806#M986579</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have tables A,B,C in which B table acts as Bridge table. My question is I want to hide all the columns in the Bridge table. But I don't want to hide the corresponding key columns in the A and C tables.&lt;/P&gt;&lt;P&gt; Table A -- Key1, Col1, Col2&lt;/P&gt;&lt;P&gt;Table B - Key 1, Key2&lt;/P&gt;&lt;P&gt;Table C- key2,Col13, Col4&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Using &lt;SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';"&gt;&lt;STRONG&gt;SET&lt;/STRONG&gt;&lt;/SPAN&gt; &lt;SPAN style="color: gray; font-size: 9.0pt; font-family: 'Courier New';"&gt;&lt;STRONG&gt;&lt;EM&gt;HidePrefix&lt;/EM&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt; = &lt;SPAN style="font-family: arial,helvetica,sans-serif;"&gt;'_'; it may hide the column in bridge but join is not happening between the tables. Please advice.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 9pt; font-family: arial,helvetica,sans-serif; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 9pt; font-family: arial,helvetica,sans-serif; color: black;"&gt;Thanks,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: black; font-size: 9.0pt; font-family: arial,helvetica,sans-serif;"&gt;Pavan&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 31 Jul 2015 05:36:58 GMT</pubDate>
    <dc:creator />
    <dc:date>2015-07-31T05:36:58Z</dc:date>
    <item>
      <title>Hide key columns in bridge table</title>
      <link>https://community.qlik.com/t5/QlikView/Hide-key-columns-in-bridge-table/m-p/922806#M986579</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have tables A,B,C in which B table acts as Bridge table. My question is I want to hide all the columns in the Bridge table. But I don't want to hide the corresponding key columns in the A and C tables.&lt;/P&gt;&lt;P&gt; Table A -- Key1, Col1, Col2&lt;/P&gt;&lt;P&gt;Table B - Key 1, Key2&lt;/P&gt;&lt;P&gt;Table C- key2,Col13, Col4&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Using &lt;SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';"&gt;&lt;STRONG&gt;SET&lt;/STRONG&gt;&lt;/SPAN&gt; &lt;SPAN style="color: gray; font-size: 9.0pt; font-family: 'Courier New';"&gt;&lt;STRONG&gt;&lt;EM&gt;HidePrefix&lt;/EM&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt; = &lt;SPAN style="font-family: arial,helvetica,sans-serif;"&gt;'_'; it may hide the column in bridge but join is not happening between the tables. Please advice.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 9pt; font-family: arial,helvetica,sans-serif; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 9pt; font-family: arial,helvetica,sans-serif; color: black;"&gt;Thanks,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: black; font-size: 9.0pt; font-family: arial,helvetica,sans-serif;"&gt;Pavan&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 31 Jul 2015 05:36:58 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Hide-key-columns-in-bridge-table/m-p/922806#M986579</guid>
      <dc:creator />
      <dc:date>2015-07-31T05:36:58Z</dc:date>
    </item>
  </channel>
</rss>

