https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331759#M411331 <HTML><HEAD></HEAD><BODY><P>Hi, I've created an xref table so that I when a user selects a server, it automatically pivots to all of the applications on that server. This view is visible in a table box, but not visible when I try to visualize it in a table or pivot chart. Below are images that show;</P><P>1. The table box output next to the pivot chart output next to the server selected.</P><P>2. The relationship manager view.</P><P>Thoughts?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172065_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/172095_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 01 Aug 2017 16:56:13 GMT Anonymous 2017-08-01T16:56:13Z https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331759#M411331 <HTML><HEAD></HEAD><BODY><P>Hi, I've created an xref table so that I when a user selects a server, it automatically pivots to all of the applications on that server. This view is visible in a table box, but not visible when I try to visualize it in a table or pivot chart. Below are images that show;</P><P>1. The table box output next to the pivot chart output next to the server selected.</P><P>2. The relationship manager view.</P><P>Thoughts?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172065_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/172095_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 01 Aug 2017 16:56:13 GMT https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331759#M411331 Anonymous 2017-08-01T16:56:13Z https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331760#M411332 <HTML><HEAD></HEAD><BODY><P>Can you remove synthetic keys by creating a Key or renaming fields like</P><P></P><P>for table v_cm_sc_infra_xref</P><P>LASTID,</P><P>SERVER AS xref_Server</P><P></P><P>then reload the data and see. IF not can you post this qvw file for a quick look. </P></BODY></HTML> Tue, 01 Aug 2017 18:08:41 GMT https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331760#M411332 vishsaggi 2017-08-01T18:08:41Z https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331761#M411333 <HTML><HEAD></HEAD><BODY><P>What is your expression in the pivottable?</P></BODY></HTML> Tue, 01 Aug 2017 18:19:33 GMT https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331761#M411333 m_woolf 2017-08-01T18:19:33Z https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331762#M411334 <HTML><HEAD></HEAD><BODY><P>That fixed it. Thanks!</P></BODY></HTML> Tue, 01 Aug 2017 19:18:24 GMT https://community.qlik.com/t5/QlikView/Data-that-is-visible-in-tablebox-not-visible-in-table-pivot/m-p/1331762#M411334 Anonymous 2017-08-01T19:18:24Z