topic Re: Checking for a null variable in set analysis in App Development

Checking for a null variable in set analysis

Evan0211 — Wed, 09 Mar 2022 14:26:39 GMT

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?

Re: Checking for a null variable in set analysis

srchagas — Wed, 09 Mar 2022 14:29:06 GMT

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

Re: Checking for a null variable in set analysis

marcus_sommer — Wed, 09 Mar 2022 14:51:18 GMT

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