topic Values missing from straight table in QlikView https://community.qlik.com/t5/QlikView/Values-missing-from-straight-table/m-p/1366481#M515412 <HTML><HEAD></HEAD><BODY><P>Afternoon!</P><P></P><P>I have been noticing some data not pulling through to straight tables.&nbsp; It appears as '-' in the field, but there is a value in that field when looking at our CRM database. </P><P></P><P>Can anyone explain why this happens?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168267_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 27 Jun 2017 13:55:56 GMT 2017-06-27T13:55:56Z Values missing from straight table https://community.qlik.com/t5/QlikView/Values-missing-from-straight-table/m-p/1366481#M515412 <HTML><HEAD></HEAD><BODY><P>Afternoon!</P><P></P><P>I have been noticing some data not pulling through to straight tables.&nbsp; It appears as '-' in the field, but there is a value in that field when looking at our CRM database. </P><P></P><P>Can anyone explain why this happens?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168267_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 27 Jun 2017 13:55:56 GMT https://community.qlik.com/t5/QlikView/Values-missing-from-straight-table/m-p/1366481#M515412 2017-06-27T13:55:56Z Re: Values missing from straight table https://community.qlik.com/t5/QlikView/Values-missing-from-straight-table/m-p/1366482#M515414 <HTML><HEAD></HEAD><BODY><P>Is your second column an expression or dimension? If it is an expression and you are using just the field name, then you might see -, if there are more than one values to show. May be try to use it as a dimension or use Concat(DISTINCT FieldName, ', ') as expression</P></BODY></HTML> Tue, 27 Jun 2017 14:35:53 GMT https://community.qlik.com/t5/QlikView/Values-missing-from-straight-table/m-p/1366482#M515414 sunny_talwar 2017-06-27T14:35:53Z Re: Values missing from straight table https://community.qlik.com/t5/QlikView/Values-missing-from-straight-table/m-p/1366483#M515416 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Might be a linking issue. Perhaps look at your modelling again</P></BODY></HTML> Tue, 27 Jun 2017 15:50:23 GMT https://community.qlik.com/t5/QlikView/Values-missing-from-straight-table/m-p/1366483#M515416 Anonymous 2017-06-27T15:50:23Z