topic Re: Problem with tablebox in QlikView https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653943#M475974 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Tablebox reduces similar data. If you have some key fields(or other fields that differ), like RECID, you can add it into table box to see all data in the table</P></BODY></HTML> Wed, 25 Jun 2014 13:46:07 GMT 2014-06-25T13:46:07Z Problem with tablebox https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653942#M475973 <HTML><HEAD></HEAD><BODY><P>Hello experts</P><P></P><P>I have a problem with a tablebox: When I load data from an sql database into this box, entires that can be found more than once in the database are only shown once. In a graph box (Chart) the values are recognized. I only have this problem in the tablebox.</P><P></P><P>Does anyone have an explanation for this phenomenon?</P><P></P><P>Thank you for your help!</P></BODY></HTML> Wed, 25 Jun 2014 13:41:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653942#M475973 2014-06-25T13:41:04Z Re: Problem with tablebox https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653943#M475974 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Tablebox reduces similar data. If you have some key fields(or other fields that differ), like RECID, you can add it into table box to see all data in the table</P></BODY></HTML> Wed, 25 Jun 2014 13:46:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653943#M475974 2014-06-25T13:46:07Z Re: Problem with tablebox https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653944#M475975 <HTML><HEAD></HEAD><BODY><P>This is working as designed. If you want to see each distinct record, you need some unique record identifier to include in the table box.</P></BODY></HTML> Wed, 25 Jun 2014 13:46:34 GMT https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653944#M475975 m_woolf 2014-06-25T13:46:34Z Re: Problem with tablebox https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653945#M475976 <HTML><HEAD></HEAD><BODY><P>The table box (and straight tables and pivot tables) will not show duplicate rows. So if you leave out the fields that make a record unique then the table box will not show every individual record, only the unique combinations of the fields that you added as dimensions.</P></BODY></HTML> Wed, 25 Jun 2014 13:47:05 GMT https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653945#M475976 Gysbert_Wassenaar 2014-06-25T13:47:05Z Re: Problem with tablebox https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653946#M475977 <HTML><HEAD></HEAD><BODY><P>Thanks Kristina. That works for me. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Jun 2014 13:50:56 GMT https://community.qlik.com/t5/QlikView/Problem-with-tablebox/m-p/653946#M475977 2014-06-25T13:50:56Z