Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Create overview of empty cells per field

Hello

I would like to create an overview in the layout(preferably a table) containing all the fields in the rows and the number of empty cells as measure.

An important note: the number of empty cells should be dynamic (when adding a filter, it should change)

fictive dataset:

IDdescriptionPersonMeasure
1tableHarryST
2Olga
3ScreenEduardo

Preferred outcome table in the lay out (but WITH dynamic :

FieldNull values
Description1
Person0
Measure2

Any feedback would be GREATLY appreciated

1 Reply
MVP
MVP

Re: Create overview of empty cells per field

Check the attached out:

I can't find the thread, but this expression was proposed by someone else

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',nullcount([' & $Field & '])', ',') & concat(right($Field&')',1)))