Show fields with a value

[cooper_yonk]

Good afternoon

Ive been asked for a list of all the fields in our datamodel that have data for a specific client.  We have over 1500 fields so I only want to return the fields that hold data.

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?

Thanks in advance

[Bill_Britt · Accepted solution]

If the clients are listed in a field, you can user a where  exists. 

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/InterRe...