How to display only null values

[Srinivas]

Hi Friends,

i want to display only null values in front end level and through script as well.

see below data i have this way:

my output is below way:

i need in script and Frontenac as well

Regards

Munna

[pratap6699]

[d_koti24]

IF(LEN(penalty)=0,'null') try this one in expression.

[yink-hpv]

correct answer

[iChord]

You can simply trick it....

Qlik Sense has the option to "Include null values", but doesn't have the option to "Hide values"!!

So simply just change the entries with values into 'Null', and change the null ones into any value, then hide them by unticking 'Include null values'.

By this, you are literary reversing this option, so you will hide nulls (which previously had values), and will show only the ones with the value (which were original nulls)

=if(Len(STYLE)>0,Null(),'Missing')