topic Select empty records in set analysis in App Development

Select empty records in set analysis

shreyandutt1 — Thu, 07 Oct 2021 22:32:30 GMT

Hello All,

I have a requirement where I have to display the count of items where Premier RM's is not equal to "Premier". If I use Count({<[Premier RM's]-={'Premier'}>} Items), the records with empty or un-associated values in [Premier RM's] field automatically get disregarded and only records with [Premier RM's] = {'Non Premier'} show up (27 in screenshot). My requirement is to get total count 28 (27+1). Attached screenshot has been taken with set analysis commented out on [Premier RM's] field to give you an idea.

Regards,

Shreyan

Re: Select empty records in set analysis

rubenmarin — Sat, 09 Oct 2021 10:23:59 GMT

Hi, maybe with?: Count(Items)-Count({<[Premier RM's]={'Premier'}>} Items)

Re: Select empty records in set analysis

kKoumoundouros — Mon, 11 Oct 2021 06:20:02 GMT

First replace the null values with a string character, for example "-", and then use the set analysis:

Count({<[Premier RM's] = - {'Premier'}>}Items)

Re: Select empty records in set analysis

shreyandutt1 — Mon, 11 Oct 2021 14:33:16 GMT

@rubenmarin thanks for the reply but the expression is much bigger than this, I just included this part to simplify the example. This is what I am planning to implement as a last resort but looking for alternatives as this is quite a common case that may arise. There should be better a way to select empty records in Qlik, no?

Re: Select empty records in set analysis

shreyandutt1 — Mon, 11 Oct 2021 14:34:23 GMT

@kKoumoundouros thanks but the field doesn't have any nulls as such. They are simply empty records as they don't have any matching associations.

Re: Select empty records in set analysis

stevejoyce — Mon, 11 Oct 2021 15:36:45 GMT

Try this:

Count({<Items = E({<[Premier RM's]-={'Premier'}>} Items) >}Items)

Re: Select empty records in set analysis

Thiago_Justen_ — Sun, 17 Oct 2021 05:41:31 GMT

Hi there,

You could also try this out:

Count({<[Premier RM's]-={'Premier'}>+<[Premier RM's]-={"*"}>} Items)

Regards