https://community.qlik.com/t5/QlikView/Show-fields-with-a-value/m-p/2007184#M1289448 <P>Good afternoon</P> <P>Ive been asked for a list of all the fields in our datamodel that have data for a specific client.&nbsp; We have over 1500 fields so I only want to return the fields that hold data.</P> <P>&nbsp;</P> <P>Any idea how I could do this so that I end up with a list of the fields in column A and whether they hold any data on the client in column b, something like that?</P> <P>Thanks in advance</P> Mon, 26 Jan 2026 18:19:17 GMT cooper_yonk 2026-01-26T18:19:17Z https://community.qlik.com/t5/QlikView/Show-fields-with-a-value/m-p/2007184#M1289448 <P>Good afternoon</P> <P>Ive been asked for a list of all the fields in our datamodel that have data for a specific client.&nbsp; We have over 1500 fields so I only want to return the fields that hold data.</P> <P>&nbsp;</P> <P>Any idea how I could do this so that I end up with a list of the fields in column A and whether they hold any data on the client in column b, something like that?</P> <P>Thanks in advance</P> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Show-fields-with-a-value/m-p/2007184#M1289448 cooper_yonk 2026-01-26T18:19:17Z https://community.qlik.com/t5/QlikView/Show-fields-with-a-value/m-p/2007254#M1289450 <P>If the clients are listed in a field, you can user a where&nbsp; exists.&nbsp;<BR /><BR /><A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/InterRecordFunctions/Exists.htm" target="_blank">https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/InterRecordFunctions/Exists.htm</A></P> Mon, 21 Nov 2022 19:48:30 GMT https://community.qlik.com/t5/QlikView/Show-fields-with-a-value/m-p/2007254#M1289450 Bill_Britt 2022-11-21T19:48:30Z