Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator II
Creator II

How to find Null Value fields in Dashboard ?

Hello All,

 

In my application we have nearly 670 filelds in the datamodel(some are key fields).

Can we find null value fields out of these 670 fileds ?

Please help !

 

Thanks,

Ramesh

1 Solution

Accepted Solutions
marcus_sommer

You may use the  object structure-table within the UI - the last entry by new objects and adding fieldvaluecount($Field) as expression.

Beside this 670 fields sound a bit as if crosstable-structures are loaded and/or created. If so I suggest to rethink the approach and to transform the tables with The-Crosstable-Load.

- Marcus

View solution in original post

2 Replies
marcus_sommer

You may use the  object structure-table within the UI - the last entry by new objects and adding fieldvaluecount($Field) as expression.

Beside this 670 fields sound a bit as if crosstable-structures are loaded and/or created. If so I suggest to rethink the approach and to transform the tables with The-Crosstable-Load.

- Marcus

ramcena306
Creator II
Creator II
Author

Hello Marcus,

 

Thank You, It works !

 

Ramesh