Checking for a null variable in set analysis

[Evan0211]

I have a KPI that expresses as:

=count(DISTINCT {<[OFFICE_CODE]={"=Match([OFFICE_CODE],$(vFilterOffice))"}>
* $(=right(left('$($(vFilter))', len('$($(vFilter))') - 1), len('$($(vFilter))') - 2))

} [Title])

This works correctly when vFilter is initiated, however upon load, it is not initiated, which is causing my KPI to print at -.

The expressions upon load expresses as * -

Is there a way to check if vFilter is null or empty on load?

[srchagas]

Hello

if you want to count null values i strongly suggest you to use Null as values 

NullAsValue ‒ Qlik Sense on Windows

then you user one special character to that and user count distinct base by the particular character 

[marcus_sommer · Accepted solution]

You used already len(var) - why not also for if(len(var), your's ..., 'default value'). Another approach may be:

coalesce(Expression, 'please define vFilter')

- Marcus