Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
cooper_yonk
Contributor III
Contributor III

Show fields with a value

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

Labels (1)
  • Other

1 Solution

Accepted Solutions
Bill_Britt
Former Employee
Former Employee

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...

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

1 Reply
Bill_Britt
Former Employee
Former Employee

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...

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.