Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator
Creator

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
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

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
Creator
Author

Hello Marcus,

 

Thank You, It works !

 

Ramesh